Integrat excel workbook in asp.net for edit and display

[Rad]

Hi,

I am trying to integrate MS Excel 2003 workbook in an ASP.NET project. I
want to be able to browse to the page, then see Excel workbook on the page.
I also like to be able to edit the work that is done in the workbook.

IS this possible?, and if yes, where do I start?


Thank you,
Rad

 

[ZSvedic]

Hi,

I am trying to integrate MSExcel2003 workbook in an ASP.NET project.  I
want to be able to browse to the page, then seeExcelworkbook on the page. 
I also like to be able to edit the work that is done in the workbook.  

IS this possible?, and if yes, where do I start?

Thank you,
Rad

Hi,
You can convert XLS/XLSX to DataTable and display in a web grid, and
then import data back to XLS/XLSX after user finished with editing.
Below is procedure for our GemBox.Spreadsheet Free Excel component
(http://www.gemboxsoftware.com/GBSpreadsheetFree.htm), but it is
similar for automation:
1) Load XLS/XLSX/CSV to our component using some of the
ExcelFile.LoadXY methods.
2) Use ExcelWorksheet.ExtractToDataTable Method:
http://www.gemboxsoftware.com/help/...elWorksheet.ExtractToDataTable_overloads.html
Then you can send that DataTable to some ASP.NET WebGrid in order to
display it.
3) After user has edited the table, use ExcelWorksheet.InsertDataTable
Method:
http://www.gemboxsoftware.com/help/GemBox.Spreadsheet.ExcelWorksheet.InsertDataTable_overloads.html
You can use automation in a similar way, but that has other issues:
http://www.gemboxsoftware.com/GBSpreadsheet.htm#Automation
--Zeljko