ResizeTable(SheetTable,Int32,Int32) Method

Visual Basic
C#

'Declaration
 
Public Overloads Sub ResizeTable( _
   ByVal table As SheetTable, _
   ByVal rowCount As System.Integer, _
   ByVal ColumnCount As System.Integer _
)

'Usage
 
Dim instance As Worksheet
Dim table As SheetTable
Dim rowCount As System.Integer
Dim ColumnCount As System.Integer
 
instance.ResizeTable(table, rowCount, ColumnCount)

public void ResizeTable( 
   SheetTable table,
   System.int rowCount,
   System.int ColumnCount
)

Parameters

table: The table instance to resize.
rowCount: The new table row count.
ColumnCount: The new table column count.

This example uses the ResizeTable method.

C#

gcSpreadSheet1.Sheets[0].Cells[1, 1].Text = "Last Name";
gcSpreadSheet1.Sheets[0].Cells[1, 2].Text = "Value";
gcSpreadSheet1.Sheets[0].Cells[2, 1].Text = "Smith";
gcSpreadSheet1.Sheets[0].Cells[2, 2].Value = 50;
gcSpreadSheet1.Sheets[0].Cells[3, 1].Text = "Vil";
gcSpreadSheet1.Sheets[0].Cells[3, 2].Value = 10;
gcSpreadSheet1.Sheets[0].Cells[4, 1].Text = "Press";
gcSpreadSheet1.Sheets[0].Cells[4, 2].Value = 78;
gcSpreadSheet1.Sheets[0].AddTable("Table1", 1, 1, 5, 2);  

GrapeCity.Windows.SpreadSheet.Data.SheetTable ntable = new GrapeCity.Windows.SpreadSheet.Data.SheetTable();
ntable = gcSpreadSheet1.Sheets[0].FindTable("Table1");
gcSpreadSheet1.Sheets[0].MoveTable(ntable, 3, 3);
//gcSpreadSheet1.Sheets[0].ResizeTable(ntable, 6, 3);   
//gcSpreadSheet1.Sheets[0].RemoveTable(ntable);

VB.NET

GcSpreadSheet1.Sheets(0).Cells(1, 1).Text = "Last Name"
GcSpreadSheet1.Sheets(0).Cells(1, 2).Text = "Value"
GcSpreadSheet1.Sheets(0).Cells(2, 1).Text = "Smith"
GcSpreadSheet1.Sheets(0).Cells(2, 2).Value = 50
GcSpreadSheet1.Sheets(0).Cells(3, 1).Text = "Vil"
GcSpreadSheet1.Sheets(0).Cells(3, 2).Value = 10
GcSpreadSheet1.Sheets(0).Cells(4, 1).Text = "Press"
GcSpreadSheet1.Sheets(0).Cells(4, 2).Value = 78
GcSpreadSheet1.Sheets(0).AddTable("Table1", 1, 1, 5, 2)

Dim ntable As New GrapeCity.Windows.SpreadSheet.Data.SheetTable()
ntable = GcSpreadSheet1.Sheets(0).FindTable("Table1")
GcSpreadSheet1.Sheets(0).MoveTable(ntable, 3, 3)
'GcSpreadSheet1.Sheets(0).ResizeTable(ntable, 6, 3)   
'GcSpreadSheet1.Sheets(0).RemoveTable(ntable)

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

Worksheet Class
Worksheet Members
Overload List