read data from excel file (urgent)

  • Thread starter Thread starter vimal.424
  • Start date Start date
V

vimal.424

Hi......all....
can any body tell me how can we upload excel file & send the excel
file data in database.
I;m not able to do........please help me......
thanks in advance
 
thanks 4 given reply but my problem is that i want only the excel file
as in browser & after that validate that data & save into uor
database.........
tell me 4 this problem
thanks
 
i want only the excel file
as in browser & after that validate that data & save into uor
database.........

Could you repeat that in different words? I'm having difficulty
understanding exactly what you want... in a browser, you can use an
<input type="file" /> (with the correct form-encoding for multipart-
mime) to allow the user to attach a file for upload. At the web-server
you can read this uploaded stream - for instance in ASP.NET it is
accessed by Request.Files (multiple files can be uploaded at once on
different inputs).

Now; most parsers will accept a stream as input; for instance, I do
something *very* similar using a CSV reader. I'm guessing that
filehelpers will do similar. And as a last resort you can save the
request stream to a temp area, and then point the parser at the temp
file [parsing direct of the request is cleaner IMO].

If you want the browser experience to *be* Excel, then you might want
to look at something like sharepoint, and customising the behavior
there.

Marc
 
Hi,


You need to have the excel runtime installed in the server. Can you upload a
CSV file instead?

--
Ignacio Machin
http://www.laceupsolutions.com
Mobile & warehouse Solutions.
thanks 4 given reply but my problem is that i want only the excel file
as in browser & after that validate that data & save into uor
database.........
tell me 4 this problem
thanks
 

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

Back
Top