ResizeTable(String,Int32,Int32) Method

Changes the table size.

Syntax

Visual Basic
C#

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

'Usage
 
Dim instance As Worksheet
Dim tableName As System.String
Dim rowCount As System.Integer
Dim ColumnCount As System.Integer
 
instance.ResizeTable(tableName, rowCount, ColumnCount)

public void ResizeTable( 
   System.string tableName,
   System.int rowCount,
   System.int ColumnCount
)

Parameters

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

Example

This example uses the ResizeTable method.

private void Window_Loaded(object sender, RoutedEventArgs e)
       {
           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);           
           gcSpreadSheet1.Invalidate();                 
       }

       private void button1_Click(object sender, RoutedEventArgs e)
       {
           //listBox1.Items.Add(gcSpreadSheet1.Sheets[0].FindTable(1, 1).Name.ToString());
           //listBox1.Items.Add(gcSpreadSheet1.Sheets[0].FindTable("Table1").ShowHeader.ToString());
           //gcSpreadSheet1.Sheets[0].RemoveTable("Table1");
           //gcSpreadSheet1.Sheets[0].MoveTable("Table1", 3, 2);
           //gcSpreadSheet1.Sheets[0].ResizeTable("Table1", 6, 3);
           gcSpreadSheet1.Invalidate();
       }

VB.NET

Private Sub Window_Loaded(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles MyBase.Loaded
        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)
        GcSpreadSheet1.Invalidate()
    End Sub

    Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
        'ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).FindTable(1, 1).Name.ToString())
        'ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).FindTable("Table1").ShowHeader.ToString())
        'GcSpreadSheet1.Sheets(0).RemoveTable("Table1")
        'GcSpreadSheet1.Sheets(0).MoveTable("Table1", 3, 2)
        'GcSpreadSheet1.Sheets(0).ResizeTable("Table1", 6, 3)
        GcSpreadSheet1.Invalidate()
    End Sub

Requirements

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