Using java. I need to parse out information, do some modifications, and then add in some more info. This was easy when using csv files but not sure the best way to do it with xls files.

[Edited on September 17, 2007 at 4:24 PM. Reason : stupid title!!!]

9/17/2007 4:05:34 PM

try this: http://jexcelapi.sourceforge.net/

or maybe Apache POI http://poi.apache.org/


we use the MS Office .NET interop assemblies at work to do the same thing via .NET

[Edited on September 17, 2007 at 4:42 PM. Reason : x]

9/17/2007 4:39:46 PM

Ooooh. Those look promising. I'll check them out when I get home later.

9/17/2007 4:47:50 PM

message_topic.aspx?topic=494223#10735158

so are you using excel or java?

[Edited on September 18, 2007 at 12:07 PM. Reason : post ]

9/18/2007 11:50:49 AM

I'm not sure why you posted the thread from which I linked.

I'm using java to parse the excel file.

9/18/2007 12:00:23 PM

i posted the link to let people in this thread know why i was bringing up excel

that makes sense though. i thought maybe you were trying to use excel to parse xml. didn't occur to me that your excel file was the xml format

9/18/2007 12:06:58 PM

I'm not using xml. I mistyped.

9/18/2007 12:11:01 PM

oh, i see now. durr. i read xls as xml

[Edited on September 18, 2007 at 12:13 PM. Reason : no wonder the stupid title edit didn't make sense]

9/18/2007 12:13:04 PM

Yeah, I suck...

9/18/2007 12:14:56 PM

http://jexcelapi.sourceforge.net/ is really easy to use and works great except for updating an existing xls. Thats the only problem that I had when I used it an year ago. I hope it is better now.

9/18/2007 3:48:56 PM

How is it great if it can't update existing excel?

9/18/2007 4:36:36 PM

I had to primarily read/generate big xls files with good formatting (multiple sheets, colors and merged cells). jexcelapi was very quick and simple, hence great.
As for updating the xls, I read the contents and wrote it to another file and then made/added the changes, followed by file rename to original file name. It is a bit difficult if you have too many formula, formatting and merged cells.

9/18/2007 5:04:53 PM