We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Missing documentation

Thread ID:





90826 Oct 20,2009 11:19 AM Dec 21,2017 08:03 AM ASP.NET Web Forms (Classic) 5
Tags: XlsIO
Brett Wilbur
Asked On October 20, 2009 11:19 AM

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.


Ashish Pillai [Syncfusion]
Replied On October 21, 2009 01:17 AM

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);

Ashish Pillai

Brett Wilbur
Replied On October 21, 2009 04:48 PM

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).


Ashish Pillai [Syncfusion]
Replied On October 22, 2009 02:04 AM

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.


Please let me know if you have any questions.

Ashish Pillai

Uchechukwu Uwakah
Replied On December 20, 2017 09:22 AM

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

Abirami Varadharajan [Syncfusion]
Replied On December 21, 2017 08:03 AM

Hi , 

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

Please let us know if you have any concerns. 



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.