I have an excel workbook with many worksheets that I would like to embed it onto my web application. What is needed is this: The excel workbook will be the UI whereby user enters their inputs, after which my web application will save these data into a database. There are currently many buttons, dropdown selection lists, cell references,formulas and macros in the excel workbook. These will have to remain, or at least majority of them have to be there when the excel is on the web. I was wondering if this is possible with Aspose.Cells.
Aspose.Cells for .NET does provide a web based grid control named Aspose.Cells.GridWeb. I think you may try this control. Users can enter data visually and you may also save the data to database too. Aspose.Cells.GridWeb does provide features like data-binding for this purpose. It does support to set/get or calculate formulas too. But I am afraid regarding macros and other a few custom controls, it does not support much.
You may check the demos and documentation for your reference: See a few demos in the nodes:
Thanks Amjad. I have gone through the demos that you have provided, but it seems to me that the excel/grid inputs are built from scratch (i.e. on the .cs file) as the user input. What I am looking for is to embed an existing workbook into the web application as an UI:
I have got a workbook with user inputs, formulas etc. Currently my end users will enter in the data into this workbook, and upload it via a web application. This uploading actually reads the workbook and saves the user inputs into an external db (MSSQL). What I would need is to embed this workbook into the web application, so that the users do not need to upload it anymore. Just go to the URL of the web application, enters the data and save it. There will be no need for them to use the excel workbook anymore. The reason to embed the workbook is that it contains many worksheets, and we do not want to meddle with the calculations, cell references in the sheets. In short, it's more like using the workbook as a template to be embedded in the web application for user input instead of building a same-look input screen in the web application. Is it possible?
hmm..looks like what I needed, except that the saving example seems to be saving the whole excel workbook. I can save the workbook first then have a program to read the workbook and save the data into the db, but is it possible to save the data in the cells directly into the db when I click on the save button?
“I can save the workbook first then have a program to read the workbook and save the data into the db,…”
Well, as I told you earlier, you may try this control. to enter data visually and you may also save the data to database directly too. Aspose.Cells.GridWeb
does provide features like data-binding for this purpose. Please check the demos regarding Data-Binding:
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.