Workbook.SaveToFile('InsertDataTable.xlsx', ExcelVersion.Version2016) Worksheet.Range(1, 1, 1, 3).Style = style Worksheet.InsertDataTable(dataTable, True, 1, 1, True) Workbook.SaveToFile('InsertDataTable.xlsx', ExcelVersion.Version2016) ĭim dataTable As DataTable = New DataTable()ĭ('SKU', Type.GetType(Int32))ĭ('NAME', Type.GetType(String))ĭ('PRICE', Type.GetType(String)) Apply a style to the first and the third row Auto fit column width in the located range Worksheet.InsertDataTable(dataTable, true, 1, 1, true) Write the DataTable to the worksheet at the specified location using Worksheet.InsertDataTable() method.ĭ('SKU', typeof(Int32)) ĭ('NAME', typeof(String)) ĭ('PRICE', typeof(String)).To import data from a DataTable to a worksheet, use the Worksheet.InsertDataTable() method. Workbook.SaveToFile('InsertArrays.xlsx', ExcelVersion.Version2016) Worksheet.Range(3, 1, 3, 6).Style = style Worksheet.Range(1, 1, 1, 6).Style = style 'Apply a style to the first and the third row 'Auto fit column width in the located range Worksheet.InsertArray(twoDimensionalArray, 3, 1) 'Write the array to the worksheet starting from the cell A3

Save the workbook to an Excel file using Workbook.SaveToFile() method.Insert the arrays to worksheet using Worksheet.InsertArray() method.Create a one-dimensional array and a two-dimensional array.Get the first worksheet through Workbook.Worksheets property.The steps to write arrays to a worksheet are as follows: NET provides the Worksheet.InsertArrary() method, allowing programmers to write one-dimensional arrays or two-dimensional arrays into the specified cell range of a worksheet. Workbook.SaveToFile('WriteToCells.xlsx', ExcelVersion.Version2016) Worksheet.Range(1, 1, 1, 4).Style = style Worksheet.Range(3, 3).Value = 'Technical Support' Worksheet.Range(2, 3).Value = 'Marketing' Worksheet.Range(1, 3).Value = 'Department' Workbook.SaveToFile('WriteToCells.xlsx', ExcelVersion.Version2016) ĭim workbook As Workbook = New Workbook()ĭim worksheet As Worksheet = workbook.Worksheets(0) Worksheet worksheet = workbook.Worksheets

Data pass c spire