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.

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

Thread ID:

Created:

Updated:

Platform:

Replies:

37622 Nov 28,2005 07:14 AM Nov 29,2005 01:33 AM Windows Forms 2
loading
Tags: XlsIO
Prathima Venkobachar
Asked On November 28, 2005 07:14 AM

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 [Syncfusion]
Replied On November 29, 2005 01:22 AM

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 [Syncfusion]
Replied On November 29, 2005 01:33 AM

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

CONFIRMATION

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.

;