Spreadsheet Worksheet to Datatable

[Indy]

Hi, I am using Telerik.Web.Spreadsheet to load an Excel sheet.  I would like to return the Excel sheet as a datatable, I cant see a property on how to do this.  Any ideas would be much appreciated.  Below is my code thus far:

        Dim ExcelPath As String = "C:\Test\Test.xlsx"
        Dim WorkBook As Telerik.Web.Spreadsheet.Workbook = Telerik.Web.Spreadsheet.Workbook.Load(ExcelPath)
        Dim ws As Telerik.Web.Spreadsheet.Worksheet = WorkBook.Sheets(0)

Many thanks in advance

 

[Peter Milchev]

Hi,

You can iterate through the Worksheets and the cells inside to obtain their values and then transfer them in a DataTable object.

You can convert the Ajax spreadsheet to DocumentProcessingLibrary one as explained below:

• https://www.telerik.com/support/kb/aspnet-ajax/details/understanding-telerik-ajax-and-document-processing-library-spreadsheet-workbook-and-worksheets;

• Dim ExcelPath As String = "C:\Test\Test.xlsx"
          Dim WorkBook As Telerik.Web.Spreadsheet.Workbook = Telerik.Web.Spreadsheet.Workbook.Load(ExcelPath)
          Dim ws As Telerik.Web.Spreadsheet.Worksheet = WorkBook.Sheets(0)
          Dim dplWorkbook = WorkBook.ToDocument()

 

You can also import the file directly to the DocumentProcessingLibrary:

• https://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/formats-and-conversion/xlsx/xlsxformatprovider

Direct conversion is currently unavailable and we have logged a task to implement it. I added an additional vote for the item on your behalf to increase its priority.

You can subscribe to the item if you would like to receive updates about status changes on it:

• Introduce conversion from DataTable to RadWorkbook/RadWorksheet and vice versa.

Regards,
Peter Milchev
Progress Telerik