Create Spreadsheet

[Harsha Jay]

Hello,

I need to create multiple worksheets in a spreadsheet/xls/excel file. I am using the jakarta POI/HSSF stuff, I am able to create the worksheets. But the size of the excel file for 10,000 rows is over 7MB. Where as if I create a single excel file with out using jakarta POI it is under 1MB.

My question is are there any other tools I can use to create worksheets from csv file directly without having to deal at cell level?

If you feel this question is not supposed to be listed here, feel free to bounce it to appropriate forum or might as well delete?

-Thanks
[ May 17, 2007: Message edited by: Harsha Jay ]

[Kaydell Leavitt]

Are you reading xls files, or writing them, or both?

Since this is a forum on Swing, which deals with user-interface, I should mention that you can display tabular data, similiar to a spread-sheet. The user-interface Component that does this is called a JTable. The data that a JTable displays is very flexible. You specify the data displayed in a JTable by using a TableModel interface or a class that implements the TableModel interface such as AbstractTableModel or DefaultTableModel or ResultSetTableModel.

So, you can use POI to read an xls file, put the data into any form that you wish and display it in a JTable. You could then save the data in your own file format.

I'm not sure if that answers your question or not.

Kaydell

[li qd]

The jxcell spreadsheet component has a robust apis to deal with excel spreadsheet,it is also a swing grid component behaved like excel.