SpreadSheetML VS POI

Hi,Is there any replacement for POI API for exporting excel sheet . Since it is too memory consuming. Is SpreadSheetML is good option?Regards,Suresh

[176 byte] By [Suresh_in80a] at [2007-11-27 4:38:28]

«« Help!! CC mangling works confusing!!
»» Which is better ListIterator or Simple list.size() in for loop

# 1

3 other options comes to mind:1) (Re)write the POI yourself.2) Use CSV instead of XLS.3) Stream pure HTML table instead of binary data.

BalusCa at 2007-7-12 9:48:57 >

top of Java-index,Enterprise & Remote Computing,Web Tier APIs...

# 2

Thanks for the reply

I already have CSV export if it contains more than 64000 rows;

But i need to have and ExcelApi which is very less memory consuming.

3) Stream pure HTML table instead of binary data. can u give me a code sample for this?

Thanks in advance

Regards,

suresh_in80

Suresh_in80a at 2007-7-12 9:48:57 >

# 3

HTML tables aren't that hard. You should know them.

<table>

<tr>

</tr>

<tr>

</tr>

</table>

Stream it as a .xls file with the right contenttype for excel. This will be opened in the right rows/cols in excel.

BalusCa at 2007-7-12 9:48:57 >

# 4

Thanks again!!But iam exporting my DB resultset to the excel.I think the above concept will not help. Do you have any idea abt SpreadsheetML !Thanks in advance

Suresh_in80a at 2007-7-12 9:48:57 >

# 5

Why will it not help? Or don't you just know how to map ResultSet values into a HTML table?No, I don't know something about SpreadsheetML, but I don't stop you to try it out yourself either :)

BalusCa at 2007-7-12 9:48:57 >

# 6

> Why will it not help? Or don't you just know how to> map ResultSet values into a HTML table?> No, I don't know something about SpreadsheetML, but I> don't stop you to try it out yourself either :)Thanks for the update

Suresh_in80a at 2007-7-12 9:48:57 >

Enterprise & Remote Computing

Web Tier APIs

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

SpreadSheetML VS POI

Enterprise & Remote Computing New Topic

Enterprise & Remote Computing Hot Topic

Enterprise & Remote Computing

All Classified