Creating Excel Program Documents

Question

Has anyone used a Java based library to generate excel documents? Preferred support in 2003?

Answer 1

I am currently working with Apache POI, ( http://poi.apache.org/index.html ), which is very complete. The 2003 file format version is still in beta, but seems to work quite well. I don't use it very much, I just read and write from Excel, but it seems reliable.

Answer 2

Whenever I have to do this, I ask myself if one large html table is enough.

. html- .xls . Excel

Answer 3

, CSV.

Answer 4

JExcelApi

, . .

, , . , , . FAQ. , .

Answer 5

HTML , Excel XML Excel 2003 XML Toolbox . ( , ..).

Answer 6

SmartXLS java, , poi jexcelapi, .

http://www.smartxls.com/indexj.htm

Answer 7

Jacob java COM. (, ), . .

(LGPL), , .

Excel COM Excel api . , VBS (VBScript Language Reference), java.

Answer 8

excel VBS, script java :

String script = "your_VBS_Name.vbs"
String cmd = "D:\\YourPath" + script;
Runtime.getRuntime().exec(cmd);

script

:

Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True

Set objWorkbook = objExcel.Workbooks.Add()
objWorkbook.SaveAs("D:\yourExcel.xls")

objExcel.Quit

your_VBS_Name.vbs

!