469,963 Members | 1,962 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,963 developers. It's quick & easy.

read data from excel file (urgent)

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
Jan 16 '08 #1
5 7112
<vi*******@gmail.comwrote in message
news:46**********************************@l32g2000 hse.googlegroups.com...
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

Export from Excel to a CSV file then check out http://www.filehelpers.com/ .

Jan 16 '08 #2
"Todd Carnes" <to********@gmail.comwrote in message
news:eX**************@TK2MSFTNGP02.phx.gbl...
<vi*******@gmail.comwrote in message
news:46**********************************@l32g2000 hse.googlegroups.com...
>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


Export from Excel to a CSV file then check out http://www.filehelpers.com/
.

Actually, you don't even need to do the export. Just use
http://www.filehelpers.com/ . It can handle Excel files.

Todd

Jan 16 '08 #3
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
On Jan 16, 10:39*am, "Todd Carnes" <toddcar...@gmail.comwrote:
"Todd Carnes" <toddcar...@gmail.comwrote in message

news:eX**************@TK2MSFTNGP02.phx.gbl...
<vimal....@gmail.comwrote in message
news:46**********************************@l32g2000 hse.googlegroups.com...
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
Export from Excel to a CSV file then check outhttp://www.filehelpers.com/
.

Actually, you don't even need to do the export. Just usehttp://www.filehelpers.com/. It can handle Excel files.

Todd
Jan 16 '08 #4
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
Jan 16 '08 #5
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.
<vi*******@gmail.comwrote in message
news:57**********************************@d21g2000 prf.googlegroups.com...
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
On Jan 16, 10:39 am, "Todd Carnes" <toddcar...@gmail.comwrote:
"Todd Carnes" <toddcar...@gmail.comwrote in message

news:eX**************@TK2MSFTNGP02.phx.gbl...
<vimal....@gmail.comwrote in message
news:46**********************************@l32g2000 hse.googlegroups.com...
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
Export from Excel to a CSV file then check
outhttp://www.filehelpers.com/
.

Actually, you don't even need to do the export. Just
usehttp://www.filehelpers.com/. It can handle Excel files.

Todd

Jan 16 '08 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Peter | last post: by
1 post views Thread by rainxy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.