Specify alphabets for first column and last column in importWorkSheet.ExportDataTable

[Prathima Venkobachar]

Hi,

I want to export data from the excel to datatable.

I am using
IWorksheet importWorkSheet = importWorkBook.Worksheets[0];
dtExcelImport = importWorkSheet.ExportDataTable(firstRow, firstColumn, firstRow, lastColumn, ExcelExportDataTableOptions.ComputedFormulaValues);

I want to specify the alphabets for the first column and last column(lets say from A - AA).
But importWorkSheet.ExportDataTable() takes int.
How can I do this..?

Thanks and Regards,
Prathima

[Administrator]

Hi Prathima, The Sheet.ExportDataTable() method takes the rows and columns as integers. I herewith attach a Sample for your reference: exportdatatable.zip Please take a look and let me know if you have any questions. Thanks for your interest with Syncfusion products. Best Regards, Seetha >Hi, > >I want to export data from the excel to datatable. > >I am using >IWorksheet importWorkSheet = importWorkBook.Worksheets[0]; >dtExcelImport = importWorkSheet.ExportDataTable(firstRow, firstColumn, firstRow, lastColumn, ExcelExportDataTableOptions.ComputedFormulaValues); > >I want to specify the alphabets for the first column and last column(lets say from A - AA). >But importWorkSheet.ExportDataTable() takes int. >How can I do this..? > >Thanks and Regards, >Prathima

[Administrator]

Hi Prathima, Sorry for the inconvenience caused. Here is the correct link: exportdatatable.zip Best Regards, Seetha >Hi, > >I want to export data from the excel to datatable. > >I am using >IWorksheet importWorkSheet = importWorkBook.Worksheets[0]; >dtExcelImport = importWorkSheet.ExportDataTable(firstRow, firstColumn, firstRow, lastColumn, ExcelExportDataTableOptions.ComputedFormulaValues); > >I want to specify the alphabets for the first column and last column(lets say from A - AA). >But importWorkSheet.ExportDataTable() takes int. >How can I do this..? > >Thanks and Regards, >Prathima