A have a very old application using Aspose.Excel which uploads Excel file from web, parses it and adds entries to a database.
I need to replace Aspose.Excel by Aspose.Cells.
How to do it?
Example of current code is attached.
Hi Mark,
Thank you for contacting Aspose support.
Please check the code segment according to the new Aspose.Cells for .NET APIs. Please note, Workbook class has replaced the Excel class whereas rest of the APIs are more or less similar in latest releases of the API. I would also suggest you to review the Programmer’s Guide & API Reference Guide for your future reference.
C#
MemoryStream ms = new MemoryStream(FileUploader.FileBytes);
Workbook book = new Workbook(ms);
Worksheet sheet = book.Worksheets[0];
Cells cells = sheet.Cells;
int maxRow = cells.MaxDataRow;
int maxColumn = cells.MaxDataColumn;
DataTable table = cells.ExportDataTable(0, 0, maxRow, maxColumn, true);
Workbook book = new Workbook(ms);
Worksheet sheet = book.Worksheets[0];
Cells cells = sheet.Cells;
int maxRow = cells.MaxDataRow;
int maxColumn = cells.MaxDataColumn;
DataTable table = cells.ExportDataTable(0, 0, maxRow, maxColumn, true);