Import an excel spreadsheet in ASP.NET

U

Uma Muthu

Hi,
I have an ASP.NET (2.0) webform. I want to import an excel spreadsheet.

In that Excel spreadsheet are specific cells that I want to capture
specific
data from. Is it doable?

Thanks,

Uma
 
J

Jeff Dillon

Is the Excel file on the server? Import to where?

You can open the Excel file using ADO.NET

Jeff
 
U

Uma Muthu

Thanks for your reply Jeff.

Most likey the file will be in the client machine.(Browse to...)

Import to where?
In that Excel spreadsheet are specific cells that I want to capture
specific data from and post it on the web grid.

Thanks,
Uma
 
J

Jeff Dillon

Well, the first task is to get the Excel file to the server. You'll need to
upload the file to the server, and then open it, parse it, and go from
there.

Check into the HTML Input (File) control to get started.

Jeff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,479
Members
44,899
Latest member
RodneyMcAu

Latest Threads

Top