Syncfusion.XlsIO.Base
Example 


The number of rows in the new range.
The number of columns in the new range.

Resize Method

Resizes the specified range a IRange object that represents the resized range.
Syntax
'Declaration
 
Function Resize( _
   ByVal rowSize As Integer, _
   ByVal columnSize As Integer _
) As IRange
'Usage
 
Dim instance As IRange
Dim rowSize As Integer
Dim columnSize As Integer
Dim value As IRange
 
value = instance.Resize(rowSize, columnSize)

Parameters

rowSize
The number of rows in the new range.
columnSize
The number of columns in the new range.

Return Value

Returns the resized range.
Remarks
Use the Resize method to change the size of range by specified rows and columns from the current range.
Example
using Syncfusion.XlsIO;
            
class Example
{
 static void Main() 
 {
   using(ExcelEngine engine = new ExcelEngine())
   {
      ExcelEngine engine = new ExcelEngine();
      IApplication application = engine.Excel;
      application.DefaultVersion = ExcelVersion.Excel2013;
      IWorkbook workbook = application.Workbooks.Open(Sample.xlsx);
      IWorksheet worksheet = workbook.Worksheets[0];
      IRange range = worksheet.Range[5,6];
      var resize = range.Resize(1000,2000);
      var address = resize.AddressLocal;
      workbook.SaveAs("output.xlsx");
   }
 }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 16.4460.0.40

See Also