Excel as Frontend for SQL Server

Aspose.Cells Product Family
1

I have need to provide Excel as frontend for data in SQL Server. Is it possible to update the excel changes back to SQL Server using Aspose.Cells?

2

@nitinbansalonline

Thanks for your posting and considering Aspose APIs.

If you want to save entire Excel file or workbook, then you can first save it into byte[] and then save it to SQL Server.

But if you want to save the data found inside the worksheets of your Excel file, then you will first export the data into data tables and then export the data tables into SQL Server.

Please see the following two articles related to this topic.

3

@shakeel.faiz - Thanks for the reply. Also, is it possible to have the Excel file be shown in browser so that the user can makes updates to data which can eventually be saved into SQL Server.?

4

@nitinbansalonline

Excel file cannot be shown to browser. Because modern browsers do not render Excel. However, Chrome and FireFox are able to open Pdf inline. It means, if you convert your Excel to Pdf, then modern browsers will be able to open them.

Besides, you can convert your Excel Sheets into Images and browsers will be able to display them. You can also convert your Excel file to HTML and browsers will be able to display them.

Another way is that you use GroupDocs, it may help you to display Excel in Browsers.

Website Link:

For this, you should create ASPX web form and takes the user input and then insert that input to your Excel file via Aspose.Cells APIs.

5

@nitinbansalonline,

I think you may consider using our Aspose.Cells.GridWeb control - A grid control that is specifically designed to work on web environments or in Asp.NET projects. It is an independent control where you may load Excel files into its grid matrix, create/design worksheets and update/ manipulate the data into the cells in WYSIWYG (visual) manner. It supports all the main features MS Excel if not everything though. It also supports to read/write and calculate formulas dynamically too. It can load and save/re-save the files to Excel files on the fly, everything in your browser type.

Please see the documents / articles for your reference:

Also, download the VS.NET featured demos “Examples.GridWeb” @ Github repos:

For your requirements, Aspose.Cells.GridWeb supports data binding feature, see the documents/ articles in the section on how to use/implement DataBinding feature in GridWeb control for your reference here: