Excel API Library for .NET - Sample Browser | Document Solutions | Insert or delete table rows and columns
[
フレーム]
This sample demonstrates how to add and delete columns and rows in a table.
//create a new workbook
var workbook = new GrapeCity.Documents.Excel.Workbook();
object[,] data = new object[,]{
{"Name", "City", "Birthday", "Eye color", "Weight", "Height"},
{"Richard", "New York", new DateTime(1968, 6, 8), "Blue", 67, 165},
{"Nia", "New York", new DateTime(1972, 7, 3), "Brown", 62, 134},
{"Jared", "New York", new DateTime(1964, 3, 2), "Hazel", 72, 180},
{"Natalie", "Washington", new DateTime(1972, 8, 8), "Blue", 66, 163},
{"Damon", "Washington", new DateTime(1986, 2, 2), "Hazel", 76, 176},
{"Angela", "Washington", new DateTime(1993, 2, 15), "Brown", 68, 145}
};
IWorksheet worksheet = workbook.Worksheets[0];
worksheet.Range["A1:F7"].Value = data;
worksheet.Range["A:F"].ColumnWidth = 15;
//add table.
ITable table = worksheet.Tables.Add(worksheet.Range["A1:F7"], true);
//add table column before first column.
table.Columns.Add(0);
//add table column before second column.
table.Columns.Add(1);
//delete first table column.
table.Columns[0].Delete();
//delete "City" table column.
table.Columns["City"].Delete();
//insert a table row in table's last row.
table.Rows.Add();
//delete second table row.
table.Rows[1].Delete();
// Save to an excel file
workbook.Save("InsertDeleteTableRowColumns.xlsx");
' Create a new Workbook
Dim workbook As New Workbook
Dim data As Object(,) = {
{"Name", "City", "Birthday", "Eye color", "Weight", "Height"},
{"Richard", "New York", #6/8/1968#, "Blue", 67, 165},
{"Nia", "New York", #7/3/1972#, "Brown", 62, 134},
{"Jared", "New York", #3/2/1964#, "Hazel", 72, 180},
{"Natalie", "Washington", #8/8/1972#, "Blue", 66, 163},
{"Damon", "Washington", #2/2/1986#, "Hazel", 76, 176},
{"Angela", "Washington", #2/15/1993#, "Brown", 68, 145}
}
Dim worksheet As IWorksheet = workbook.Worksheets(0)
worksheet.Range("A1:F7").Value = data
worksheet.Range("A:F").ColumnWidth = 15
'add table.
Dim table As ITable = worksheet.Tables.Add(worksheet.Range("A1:F7"), True)
'add table column before first column.
table.Columns.Add(0)
'add table column before second column.
table.Columns.Add(1)
'delete first table column.
table.Columns(0).Delete()
'delete "City" table column.
table.Columns("City").Delete()
'insert a table row in table's last row.
table.Rows.Add()
'delete second table row.
table.Rows(1).Delete()
' save to an excel file
workbook.Save("InsertDeleteTableRowColumns.xlsx")