 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Java Forum / General / June 2006Java MS Excel read write question
Hi Everybody! I need to move data between Java and Excel (mostly read data from Excel files for now). I am currently looking at POI and JExcelApi. Does anyone have any experience with either of these? Horror stories? It saved the day stories? What does Open Office use? Any help would be appreciated. Thanks, John > Hi Everybody! > [quoted text clipped - 4 lines] > > Any help would be appreciated. I'm searching google and most of the top hits are pay products. Typically that means that your only real option is to pay for something. But it looks like you are already considering that. Now you could do what I have done and just export a comma delimited file and parse that. -- LTP :) >> Hi Everybody! >> [quoted text clipped - 5 lines] > Typically that means that your only real option is to pay for something. > But it looks like you are already considering that. Excel->odbc->jdbc->java ?? Lordy > Excel->odbc->jdbc->java ?? Have you ever triied it? I used to try it to read a MS Excel 97. It didn't recognize it (the Exception was something about no table found in the file). And if you want to read a MS Excel format generated by a third party software, you'd better pray it is not a Binary File Format (before MS Excel 95). http://udk.openoffice.org shows a Java API. I don't know if you need to pay for it.  SignatureJSC Thanks for the help everybody! I don't want to use the save as csv option as the problem I have is that I have a large number of existing files that I need to read and I don't want to manually open each one and do a save as csv. Thanks for the uno tip. I'll let you know how I make out. John >> Excel->odbc->jdbc->java ?? > > Have you ever triied it? Thankfully not :) > http://udk.openoffice.org shows a Java API. I don't know if you need to > pay for it. It does sounds sensible to look at integration possibilities using OpenOffice. Lordy >>> Excel->odbc->jdbc->java ?? >> Have you ever triied it? [quoted text clipped - 3 lines] >> http://udk.openoffice.org shows a Java API. I don't know if you need to >> pay for it. Looks like it is free.. > It does sounds sensible to look at integration possibilities using OpenOffice. > > Lordy Thanks in Advance... IchBin, Pocono Lake, Pa, USA http://weconsultants.phpnet.us __________________________________________________________________________ 'If there is one, Knowledge is the "Fountain of Youth"' -William E. Taylor, Regular Guy (1952-) > Hi Everybody! > [quoted text clipped - 7 lines] > Thanks, > John I've used jExcelAPI to write a couple of apps that processed data from Excel 2000 files. It's fairly fast and easy to use, at least on the files that I have to process. I did some experimenting on writing files, and at least for very simple files it was OK. Not tried POI, but I imagine that's had more development seeing as it's part of Apache. HTH SignatureTechBookReport Java http://www.techbookreport.com/JavaIndex.html Hi Everybody! I am using HSSFSerializer - POI for last two years . Its basically XML - xslt--> gnumeric format xml --> HSSFSerializer -- > Excel. Charting capabilities are missing but good thing is macros are preserved while reading Excel using POI and it solves my problem. -neoAshu > > Hi Everybody! > > [quoted text clipped - 17 lines] > > HTH Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.