We have requirement in which we need to open excel file along with number calculations and allow user to edit editable field in the excel, also need to save data in database. To serve the purpose we need to read excel and retrieve data from the excel.Please note that solution should support macro base and simple excel files(.xlsm and .xlsx) and development environment is MVC .Net.
may i know is there any way to serve the requirement?
We have Aspose.Cells (written in managed .NET), which is a library that supports reading/writing, manipulating or rendering MS Excel spreadsheets (XLS, XLSX, XLSB, XLSM, etc.). It doesn’t have any UI. Therefore, if your requirement does not correspond to display Excel files in a separate window/grid grid in WYSIWYG (visible) mode, you can try using the Aspose.Cells API.
For your scenario/case, you can open an existing workbook, then manipulate the data in the worksheet cells, and then you can export the data to populate the DataTable using the Aspose.Cells API. Finally, you can use the ADO.NET API to save data to a database table.
Please refer to the documentation for reference:
Browse and view the documentation for your reference:
See the examples (projects) for your complete reference:
Or (if you need to use MS Excel like a grid control), you can consider using our grid control:
i) Aspose.Cells.GridWeb Control - a Grid control designed for web environments or Asp.NET projects. It is a stand-alone control that allows you to load an Excel file into its grid matrix, create/design a worksheet, and update/operate data into cells in WYSIWYG (visual) mode. It can dynamically load, manipulate/edit and save/re-save Excel files, all content in the browser type. Please refer to the file/article for reference: Aspose.Cells.GridWeb|Documentation
Also, see the documentation on how to add a reference to the Aspose.Cells, Aspose.Cells.GridWeb component in your project: