I want to read contents of excel file which is in my attachment file?How can I do it
2 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   hari_krishna
Posted On:   Tuesday, November 13, 2001 01:15 AM

I am using jsp for my application.I able to get The File but I want to read contents of Excel file into database?How canI do it?

Re: I want to read contents of excel file which is in my attachment file?How can I do it

Posted By:   John_Zukowski  
Posted On:   Thursday, November 15, 2001 08:15 AM

There are also several entries around jGuru that cover reading Excel files. The fact that it comes across as an attachment really doesn't matter.

Re: I want to read contents of excel file which is in my attachment file?<br>!_NEWLINE_!How can I do it

Posted By:   Anonymous  
Posted On:   Tuesday, November 13, 2001 03:37 PM

I'm not an expert on this topic, so you might want to wait for more answers, but here's a start.

This is what I'm thinking: there's an extensive tool set in Visual Basic to handle Excell files... and there are bridges between Java and Visual Basic...



Here are some links I found on the net that "might" be useful:

http://developer.java.sun.com/developer/technicalArticles/Interviews/Update/index.html

http://www.intrinsyc.com/pdfs/vb-ejb_bridge.pdf

http://www.intrinsyc.com/pdfs/asp-java_bridge.pdf

... and this project on SourceForger, which looks interesting, with a example on using Excell worksheets in Java:

http://sourceforge.net/projects/jcom/



Enjoy! :)

-w
About | Sitemap | Contact