How to open Excel in Asp.net page

Question

0.00/5 (No votes)

See more:

Hi,

I want excel in C#.net page in which user can insert data in excel but before insertion user set how many number of rows and colums he want to insert.When user insert data, that data automatically save in database and i m using Sql Server To save data in database

Along with insertion, user can do other operations like delete/update/select.

Please help me to solve this problem.

Thanks
Twinkle Kumar

Posted 16-Sep-10 22:25pm

jindi123

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dylan Morley · Answer 1 · 2010-09-16T22:43:00

You need to think a bit about what will happen here, what you're asking for isn't really feasable

Excel is a program & for the user to be able to interact with it, it must be installed on their computer. You can't really control Excel on the client from web pages, that would be a massive security hole. (NB: There's a certain amount you can do, but it has to be explicity allowed and permissions set. Best just to forget about it imo )

What you actually want to do is display data in a grid like format and offer the client functionality to work with data before persisting it to the database. For this, something like the GridView component is perfect for your requirements.

Have a look into GridView

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.aspx[^]

jindi123 · Answer 2 · 2010-09-16T23:03:00

Solution 2

I m Already used Gridview With All options Like Edit / Delete / Update and as well as Cancel. but now i m all things do in Excel Format . This is Possible Or not .

Please Give me some idea

Thanks

Posted 16-Sep-10 23:03pm

jindi123

Comments

Dylan Morley 17-Sep-10 5:21am

No, as explained you can't use Excel like this in a web page. You can use Excel on the server, to create a file or report for example. You can automate Excel on the client (if permissions allowed, they aren't by default) to show Excel to the user.

You cannot control Excel from a web page for data input. Why you would even want to is beyond me.

**Dalek Dave** · Answer 3 · 2010-09-16T23:19:00

There is no way of doing what you are after.
Excel is a proprietry product, and it is not set of general web use.

You would also have to have a license for every single person who went to your website.

What you need is a Datagrid, and feed that data into a database.
(If you need functionality, it can be fed into a spreadsheet, but only for your own use.

How to open Excel in Asp.net page

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0