Worksheet worksheet = workbook.Worksheets[0];
1 public void InsertDataTable() 2 { 3 Workbook workbook = new Workbook(); 4 workbook.LoadFromFile("F:/Row1.xlsx"); 5 Worksheet worksheet = workbook.Worksheets[0]; 6 DataTable table = new DataTable(); 7 DataColumn column; 8 for (int i = 1; i <= worksheet.LastColumn; i++) 9 { 10 column = new DataColumn(); 11 column.DataType = System.Type.GetType("System.String"); 12 column.ColumnName = i.ToString(); 13 table.Columns.Add(column); 14 } 15 button1.Text = "worksheet.LastRow = " + worksheet.LastRow.ToString(); 16 worksheet.InsertDataTable(table, true, 2, 1); 17 CellRange ranges = worksheet.Range[worksheet.FirstRow, worksheet.FirstColumn, 18 worksheet.LastRow+1, worksheet.LastColumn]; 19 DataTable dataTable = worksheet.ExportDataTable(ranges, true, true); 20 dataGridView1.DataSource = dataTable; 21 }
TMD
1 private void button1_Click(object sender, EventArgs e) 2 { 3 Workbook wb = new Workbook(); 4 wb.LoadFromFile("F:/datawrite.xlsx"); 5 Worksheet sheet = wb.Worksheets[4]; 6 DataColumn column = new DataColumn(); 7 column.Unique = false; 8 CellRange range = sheet.Range["A31"]; 9 label1.Text = range.Value.ToString(); 10 byte i = 1; 11 label4.Text = textBox1.Text + i.ToString(); 12 }
Spire.XLS使用记录（没有什么逻辑）（如果有例程，程序在上，说明在下。一个圆点点一个说明）
原文：https://www.cnblogs.com/Jane-share/p/15166267.html
