You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Mamatha Kodigehalli Venkatesh <Ma...@ness.com> on 2011/03/04 10:15:28 UTC

Support for HSSF(.xls) in BigGridDemo

Hello,


I was able to use BigGridDemo for creating .xlsx using XSSF

I want HSSF support to get the sheet Ref as the HSSFSheet does not have the support of sheet.getPackagePart().getPartName().getName();

XSSFSheet sheet = wb.createSheet("Repository");
String sheetRef = sheet.getPackagePart().getPartName().getName();

Please suggest me, My requirement is to generate huge files (.xls & .xlsx).


Thanks in advance.

-mamatha

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


RE: Support for HSSF(.xls) in BigGridDemo

Posted by Mamatha Kodigehalli Venkatesh <Ma...@ness.com>.
Thanks Nick for quick feedback.
Also any inputs on how to achieve apply Formula and Data Validation using BigGridDemo. 


-----Original Message-----
From: Nick Burch [mailto:nick.burch@alfresco.com] 
Sent: Monday, March 14, 2011 6:15 PM
To: POI Users List
Subject: RE: Support for HSSF(.xls) in BigGridDemo

On Mon, 14 Mar 2011, Mamatha Kodigehalli Venkatesh wrote:
> I was able to use BigGridDemo for creating .xlsx using XSSF
>
> I want HSSF support to get the sheet Ref as the HSSFSheet does not have 
> the support of sheet.getPackagePart().getPartName().getName();

BigGridDemo is XSSF only. If you want to write code that works for both 
XSSF and HSSF, then you need to use the high level usermodel code.

Also, HSSF doesn't support streaming writing - there are just too many 
links forwards and backwards in the file

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


RE: Support for HSSF(.xls) in BigGridDemo

Posted by Nick Burch <ni...@alfresco.com>.
On Mon, 14 Mar 2011, Mamatha Kodigehalli Venkatesh wrote:
> I was able to use BigGridDemo for creating .xlsx using XSSF
>
> I want HSSF support to get the sheet Ref as the HSSFSheet does not have 
> the support of sheet.getPackagePart().getPartName().getName();

BigGridDemo is XSSF only. If you want to write code that works for both 
XSSF and HSSF, then you need to use the high level usermodel code.

Also, HSSF doesn't support streaming writing - there are just too many 
links forwards and backwards in the file

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


RE: Support for HSSF(.xls) in BigGridDemo

Posted by Mamatha Kodigehalli Venkatesh <Ma...@ness.com>.
Any Comments/suggestion for my question below.

-----Original Message-----
From: Mamatha Kodigehalli Venkatesh [mailto:Mamatha.Venkatesh@ness.com] 
Sent: Friday, March 04, 2011 2:45 PM
To: POI Users List
Subject: Support for HSSF(.xls) in BigGridDemo


Hello,


I was able to use BigGridDemo for creating .xlsx using XSSF

I want HSSF support to get the sheet Ref as the HSSFSheet does not have the support of sheet.getPackagePart().getPartName().getName();

XSSFSheet sheet = wb.createSheet("Repository");
String sheetRef = sheet.getPackagePart().getPartName().getName();

Please suggest me, My requirement is to generate huge files (.xls & .xlsx).


Thanks in advance.

-mamatha

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org