MS Excel-like web app

Question

MS Excel-like web app

Arshad Nazeer 21

Hi.

How to build MS Excel Spread Sheet like web app?
How to design the cells of the sheets?
How to save data from the cells of the sheets?

Thanks!

Lan Huang-MSFT 30,186 Reputation points Microsoft External Staff

2022-10-11T09:31:40.44+00:00

Hi @Arshad Nazeer ,
I don't quite understand your needs, do you want to implement something similar to MS Excel in aspnet web pages? Or just want to do it in MS Excel?
Best regards,
Lan Huang
Arshad Nazeer 21 Reputation points

2022-10-11T10:15:54.217+00:00

Thanks for the reply. I want to develop a web app that has ms office excel-like spreadsheets. For example, when a user visits my web page and requests a spreadsheet to save some data in excel-like format, I want to render this spreadsheet on the user's screen.
So, how to build cells and extract data from these cells and store the data in Db?

Is building cells in the spreadsheet part of frontend development and saving cells' data in Db part of backend development?

If you look at the link: onedrive.live.com/edit.aspx?action=editnew, it shows extension ".aspx" which is dotnet backend, but I don't know how to build cells and save data from these cells to the Db in the web technology. Please help.

1 answer

Your answer

Lan Huang-MSFT 30,186 Reputation points Microsoft External Staff

2022-10-11T09:31:40.44+00:00

Hi @Arshad Nazeer ,
I don't quite understand your needs, do you want to implement something similar to MS Excel in aspnet web pages? Or just want to do it in MS Excel?
Best regards,
Lan Huang
Arshad Nazeer 21 Reputation points

2022-10-11T10:15:54.217+00:00

Thanks for the reply. I want to develop a web app that has ms office excel-like spreadsheets. For example, when a user visits my web page and requests a spreadsheet to save some data in excel-like format, I want to render this spreadsheet on the user's screen.
So, how to build cells and extract data from these cells and store the data in Db?

Is building cells in the spreadsheet part of frontend development and saving cells' data in Db part of backend development?

If you look at the link: onedrive.live.com/edit.aspx?action=editnew, it shows extension ".aspx" which is dotnet backend, but I don't know how to build cells and save data from these cells to the Db in the web technology. Please help.

Answer 1

Hi @Arshad Nazeer ,
I think you can use GridView control to achieve something similar, you can check GridView documentation for details.
https://learn.microsoft.com/en-us/dotnet/api/system.web.ui.webcontrols.gridview?view=netframework-4.8
The GridView control supports the following features:

Binding to data source controls, such as SqlDataSource.
Built-in sort capabilities.
Built-in update and delete capabilities.
Built-in paging capabilities.
Built-in row selection capabilities.
Programmatic access to the GridView object model to dynamically set properties, handle events, and so on.
Multiple key fields.
Multiple data fields for the hyperlink columns.
Customizable appearance through themes and styles.

Unfortunately, I do not have access to the link you provided.
Best regards,
Lan Huang

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

MS Excel-like web app

1 answer

Your answer