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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Missing documentation

Thread ID:





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

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 05:17 AM UTC

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 08:48 PM UTC

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 06:04 AM UTC

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 02:22 PM UTC

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

Abirami Varadharajan [Syncfusion]
Replied On December 21, 2017 01:03 PM UTC

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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon 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.Close Icon