• Post Reply Bookmark Topic Watch Topic
  • New Topic

Create Spreadsheet

 
Harsha Jay
Ranch Hand
Posts: 177
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 690
Eclipse IDE Firefox Browser Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The jxcell spreadsheet component has a robust apis to deal with excel spreadsheet,it is also a swing grid component behaved like excel.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!