Missing documentation

[Brett Wilbur]

I have been trying to get up to speed with the ExportDataTable function for xlsio, but I keep running into references (in syncfusion documentation and in postings) to this article: http://www.syncfusion.com/products/Xlsio/web/Articles/import_export.aspx

Unfortunately, this link is dead (I only get whitespace). Can anyone point me to an actual link that provides updated documentation on the export to datatable functionality?

Also, I'm having difficulty identifying in the documentation how to specify multiple ExcelExportDataTableOptions for the data table export. Any help on how to do this would be much appreciated.

Thanks.

[Ashish Pillai]

Hi Bwilbur,

Sorry for the inconvenience caused.

1. http://help.syncfusion.com/ug_73/xlsio/ImportExportDataTable.html

Please find the above link for documentation of Import/Export Data table.

2. Please find the below code snippet for multiple ExcelExportDataTableOptions for the data table.

DataTable VendorTable, VendorTable1;
ExcelEngine excelEngine = new ExcelEngine();

IApplication application = excelEngine.Excel;
IWorkbook workbook = application.Workbooks.Open("../../Test.xlsx", ExcelVersion.Excel2007);
workbook.Version = ExcelVersion.Excel97to2003;

IWorksheet sheet = workbook.Worksheets[0];

IWorksheet sheet1 = workbook.Worksheets[1];

//Read Data
VendorTable = sheet.ExportDataTable(sheet.Range[1,1,63356,6], ExcelExportDataTableOptions.None);
VendorTable1 = sheet.ExportDataTable(sheet.Range[63356,6,64460,6], ExcelExportDataTableOptions.None);

DataView VendorView = new DataView(VendorTable);
DataView VendorView1 = new DataView(VendorTable1);
workbook.Close();

Regards,
Ashish Pillai

[Brett Wilbur]

Thank you Ashish, I have a couple of follow-up questions.

1) The link you provided gives a good high-level description of the import/export to datatable functionality. In the page, there is a link to another (I'm assuming) more detailed definition of the exportdatatable functionality here: http://www.syncfusion.com/products/xlsio/backoffice/Articles/import_export.aspx

When I click on this link, it takes me to a blank page. Do you have an updated link to this page/documentation?


2) The code-snippet you provided gives an example of loading one ONE Excel file into TWO datatables, each with their own ExportDatatableOption (both using the Option of None).

Do you have an example of loading ONE Excel spreadsheet into ONE datatable with MULTIPLE ExportDatatableOptions?

I'm looking for something like:

VendorTable = sheet.ExportDataTable(sheet.UsedRange, ExcelExportDataTableOptions.ColumNames | ExcelExportDataTableOptions.ComputedFormulaValues);

Having both options specified in the one export function would allow me to reference column names in the datatable as well as pulling only the computed values (I don't want the formulas).


Thanks.

[Ashish Pillai]

Hi Bwilbur,

Sorry for the inconvenience caused.

1. http://www.syncfusion.com/products/Xlsio/web/Articles/import_export.aspx

The above link is not properly functioning. So please ignore it.

2. We have created a sample as per your requirement. Please find the sample in the below link.

http://www.syncfusion.com/uploads/redirect.aspx?file=ExportData_545c6d9c.zip&team=development

Please let me know if you have any questions.

Regards,
Ashish Pillai

[Uchechukwu Uwakah]

Hi,

Is there a replacement for sheet.ExportDataTable(). Seems not to be there anymore.

[Abirami Varadharajan]

Hi , 

You can import data from worksheet to data table using ExportDataTable. Please refer below documentation to know more about  ExportDataTable. 

Documentation Link: https://help.syncfusion.com/file-formats/xlsio/working-with-data#exporting-from-worksheet-to-data-table  

Please let us know if you have any concerns. 

Regards, 

Abirami.