Exporting all data in column into list

Aspose.Cells Product Family
1

can any one help me........

how to exporting entire data inside column into list .net c#

e.g. i have an excel table

data number

213 6768

112 3244

234 86787

now i want to export all the data in the data column (213,112,234) into list< > on C#

thanks.....

2

Hi,

I think you may try to export your desired data range to fill a data table or an array for your requirement. e.g

<span style=“font-size: 10pt; font-family: “Microsoft YaHei”,“sans-serif”; color: black;”>Cells.ExportDataTable(int firstRow, int firstColumn, int totalRows, int
totalColumns) — set the parameters accordingly.


<span style=“font-size: 10pt; font-family: “Microsoft YaHei”,“sans-serif”; color: black;”>

<span style=“font-size: 10pt; font-family: “Microsoft YaHei”,“sans-serif”; color: black;”>DataTable dt = worksheet.Cells.ExportDataTable(1, 0, worksheet.Cells.MaxDataRow + 1, 1);

<span style=“font-size: 10pt; font-family: “Microsoft YaHei”,“sans-serif”; color: black;”>

<span style=“font-size: 10pt; font-family: “Microsoft YaHei”,“sans-serif”; color: black;”>

<span style=“font-size: 10pt; font-family: “Microsoft YaHei”,“sans-serif”; color: black;”>object[,] oExcelRangeValues;
oExcelRangeValues = (System.Object[,])workbook.Worksheets[0].Cells.ExportArray(1, 0, 10, 1);



Thank you.