Java and MSExcel

How to do it? It is urgent.....

[Jaya]

How to communicate from java to Excel?

I need to pass data from java to Excel such that it'll create a report. It should be able to handle images also. ie. I have a form which contains some data. I need to read the data from the form and export the data - in the same format in the form - to MSExcel. I should be able to put the data in specific cells of MSExcel.

Please help.

[DaveAtIFG]

I did some digging and can't find any scripts written in any language that can take HTML forms data into Excel. If this is what you need to do, you'll probably need to put on your programmer's hat or hire it done. There's an M$ article here [support.microsoft.com] that introduces what a Java to COM object (such as Excel) interface requires. It may provide you some ideas.

[txbakers]

there is a product available from Actuate which is a java rendering of Excel. The product is called e.Spreadsheet and is designed to use Excel sheets as input and output from a datasource.
You can get more information from www.actuate.com

We use it in my office, as well as all the other Actuate products.

[john316]

Could you just write the data to a csv file and import it from Excel?

Could be as easy as Excel>file>open>whatever.csv

[Crazy_Fool]

i dont know about doing it in java, but i'm positive you can create excel tables from html forms by using ASP. cant give you any more info that that as i've never actually had a need to do it myself so not looked into it any further

[Jaya]

Thanks for the info...

How about doing it using VC++? Using VC++ we can handle the cells in an Excel sheet and we can call the VC++ method from the java program.

[frogg]

There's an Apache Jakarta project called POI for munging around in Excel files from Java. It can be found here:-
[jakarta.apache.org...]