Hi all.
I am using SQL Server 2000 and Java and will want to retrieve data from the database and create MS Word and MS Excel report, so can please any one assist in this regard, maybe by specific sudes with tutorials or some sample codes. I have tried to google it around without any success.
Thanks in advance
Cheers.
MS Excel reports may be created with Apache POI.
http://wldj.sys-con.com/read/185302.htm
Hi,
Take one working jsp files. simple only one work
remove this line -<%@ page contentType="application/html"%>.
Use this line -<%@ page contentType="application/vnd.ms-excel"%>.
And execute the jsp files
let me know working or not.
thanks
Thanks for your comment
If you know -how to create excel means then you explain here or please shut-up .....
This solution is working fine.
The Apache POI and the JExcel are already mentioned.
Excel can parse plain HTML tables, but that's just bad use of it. How about saving and editing?
