You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by felixesanchez <fe...@sanchezit.com> on 2011/07/27 21:34:28 UTC
Re: the maximum number of sheets can create in one workbook?
I having the same problem with POI 3.6. Does anybody know how can I pass this
problem?
thanks,
Felix Sanchez
felix@sanchezit.com
java_lee wrote:
>
> Dear All
>
> I use the lastest version of POI(3.1) to create 1400 sheets in a
> workbook. And when I open the XLS file generated by the programe, the MS
> excel 2003 pops the error like bellow.
>
> "Damage to the file was so extensive that repairs were not possible.
> Excel
> attempted to recover your formulas and values, but some data may have been
> lost or corrupted."
>
> code :
>
> import java.io.File;
> import java.io.FileNotFoundException;
> import java.io.FileOutputStream;
> import java.io.FileWriter;
> import java.io.IOException;
> import java.io.OutputStream;
>
> import org.apache.poi.hssf.usermodel.HSSFSheet;
> import org.apache.poi.hssf.usermodel.HSSFWorkbook;
>
>
>
> public class Test {
>
> public static void main(String[] args) {
> FileOutputStream fs = null;
> try {
> fs = new FileOutputStream("test.xls");
> } catch (FileNotFoundException e) {
> e.printStackTrace();
> }
>
> HSSFWorkbook wb = new HSSFWorkbook();
> String sheetName = "s";
>
> for(int i=0;i<2000;i++){
> sheetName = sheetName + i;
> wb.createSheet(sheetName);
> sheetName = "s";
>
> System.out.println("sheet of number " + i + "finish!!!");
>
> }
>
> try {
> wb.write(fs);
> fs.close();
> } catch (IOException e) {
> e.printStackTrace();
> }
>
> System.out.println("finish!!");
>
> }
> }
>
>
> And if the number of sheet is under 1370 or open it with EIOffice(a
> office programe like ms office) even it more than 1400 sheets, it can be
> opened normally. Can anyone of you tell me why?
>
> Thanks in advance for your help!
> Andy
>
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/the-maximum-number-of-sheets-can-create-in-one-workbook-tp2299700p4640053.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: the maximum number of sheets can create in one workbook?
Posted by Neil Benn <ne...@gmail.com>.
Hello,
Ah, OK. I got that number from the MS website so I limited the
workbook to 255 sheets as I don't know the Excel version the customer uses
(they can crested a workbook with n sheets from our product). I never
actually tried it however!
Cheers,
Neil
On 27 Jul 2011 20:58, "felixesanchez" <fe...@sanchezit.com> wrote:
> Thanks Neil! But Excel can handle much more that that. I am having problem
> when POI generates more than 1370 sheets. Excel will complaint about it.
>
> Thanks,
>
>
> Neil Benn wrote:
>>
>> Excel 2003 can only have 255 worksheets in a workbook - the limit goes
>> away with later verions
>>
>> On Wed, Jul 27, 2011 at 8:34 PM, felixesanchez <felix@sanchezit.com
>
>> wrote:
>>> I having the same problem with POI 3.6. Does anybody know how can I pass
>>> this
>>> problem?
>>>
>>> thanks,
>>>
>>> Felix Sanchez
>>> felix@sanchezit.com
>>>
>>>
>>> java_lee wrote:
>>>>
>>>> Dear All
>>>>
>>>> I use the lastest version of POI(3.1) to create 1400 sheets in a
>>>> workbook. And when I open the XLS file generated by the programe, the
MS
>>>> excel 2003 pops the error like bellow.
>>>>
>>>> "Damage to the file was so extensive that repairs were not possible.
>>>> Excel
>>>> attempted to recover your formulas and values, but some data may have
>>>> been
>>>> lost or corrupted."
>>>>
>>>> code :
>>>>
>>>> import java.io.File;
>>>> import java.io.FileNotFoundException;
>>>> import java.io.FileOutputStream;
>>>> import java.io.FileWriter;
>>>> import java.io.IOException;
>>>> import java.io.OutputStream;
>>>>
>>>> import org.apache.poi.hssf.usermodel.HSSFSheet;
>>>> import org.apache.poi.hssf.usermodel.HSSFWorkbook;
>>>>
>>>>
>>>>
>>>> public class Test {
>>>>
>>>> public static void main(String[] args) {
>>>> FileOutputStream fs = null;
>>>> try {
>>>> fs = new FileOutputStream("test.xls");
>>>> } catch (FileNotFoundException e) {
>>>> e.printStackTrace();
>>>> }
>>>>
>>>> HSSFWorkbook wb = new HSSFWorkbook();
>>>> String sheetName = "s";
>>>>
>>>> for(int i=0;i<2000;i++){
>>>> sheetName = sheetName + i;
>>>> wb.createSheet(sheetName);
>>>> sheetName = "s";
>>>>
>>>> System.out.println("sheet of number " + i +
>>>> "finish!!!");
>>>>
>>>> }
>>>>
>>>> try {
>>>> wb.write(fs);
>>>> fs.close();
>>>> } catch (IOException e) {
>>>> e.printStackTrace();
>>>> }
>>>>
>>>> System.out.println("finish!!");
>>>>
>>>> }
>>>> }
>>>>
>>>>
>>>> And if the number of sheet is under 1370 or open it with EIOffice(a
>>>> office programe like ms office) even it more than 1400 sheets, it can
>>>> be
>>>> opened normally. Can anyone of you tell me why?
>>>>
>>>> Thanks in advance for your help!
>>>> Andy
>>>>
>>>
>>>
>>> --
>>> View this message in context:
>>>
http://apache-poi.1045710.n5.nabble.com/the-maximum-number-of-sheets-can-create-in-one-workbook-tp2299700p4640053.html
>>> Sent from the POI - User mailing list archive at Nabble.com.
>>>
>>> ---------------------------------------------------------------------
>>> 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
>>
>
>
> --
> View this message in context:
http://apache-poi.1045710.n5.nabble.com/the-maximum-number-of-sheets-can-create-in-one-workbook-tp2299700p4640115.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
Re: the maximum number of sheets can create in one workbook?
Posted by felixesanchez <fe...@sanchezit.com>.
Thanks Neil! But Excel can handle much more that that. I am having problem
when POI generates more than 1370 sheets. Excel will complaint about it.
Thanks,
Neil Benn wrote:
>
> Excel 2003 can only have 255 worksheets in a workbook - the limit goes
> away with later verions
>
> On Wed, Jul 27, 2011 at 8:34 PM, felixesanchez <felix@sanchezit.com>
> wrote:
>> I having the same problem with POI 3.6. Does anybody know how can I pass
>> this
>> problem?
>>
>> thanks,
>>
>> Felix Sanchez
>> felix@sanchezit.com
>>
>>
>> java_lee wrote:
>>>
>>> Dear All
>>>
>>> I use the lastest version of POI(3.1) to create 1400 sheets in a
>>> workbook. And when I open the XLS file generated by the programe, the MS
>>> excel 2003 pops the error like bellow.
>>>
>>> "Damage to the file was so extensive that repairs were not possible.
>>> Excel
>>> attempted to recover your formulas and values, but some data may have
>>> been
>>> lost or corrupted."
>>>
>>> code :
>>>
>>> import java.io.File;
>>> import java.io.FileNotFoundException;
>>> import java.io.FileOutputStream;
>>> import java.io.FileWriter;
>>> import java.io.IOException;
>>> import java.io.OutputStream;
>>>
>>> import org.apache.poi.hssf.usermodel.HSSFSheet;
>>> import org.apache.poi.hssf.usermodel.HSSFWorkbook;
>>>
>>>
>>>
>>> public class Test {
>>>
>>> public static void main(String[] args) {
>>> FileOutputStream fs = null;
>>> try {
>>> fs = new FileOutputStream("test.xls");
>>> } catch (FileNotFoundException e) {
>>> e.printStackTrace();
>>> }
>>>
>>> HSSFWorkbook wb = new HSSFWorkbook();
>>> String sheetName = "s";
>>>
>>> for(int i=0;i<2000;i++){
>>> sheetName = sheetName + i;
>>> wb.createSheet(sheetName);
>>> sheetName = "s";
>>>
>>> System.out.println("sheet of number " + i +
>>> "finish!!!");
>>>
>>> }
>>>
>>> try {
>>> wb.write(fs);
>>> fs.close();
>>> } catch (IOException e) {
>>> e.printStackTrace();
>>> }
>>>
>>> System.out.println("finish!!");
>>>
>>> }
>>> }
>>>
>>>
>>> And if the number of sheet is under 1370 or open it with EIOffice(a
>>> office programe like ms office) even it more than 1400 sheets, it can
>>> be
>>> opened normally. Can anyone of you tell me why?
>>>
>>> Thanks in advance for your help!
>>> Andy
>>>
>>
>>
>> --
>> View this message in context:
>> http://apache-poi.1045710.n5.nabble.com/the-maximum-number-of-sheets-can-create-in-one-workbook-tp2299700p4640053.html
>> Sent from the POI - User mailing list archive at Nabble.com.
>>
>> ---------------------------------------------------------------------
>> 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
>
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/the-maximum-number-of-sheets-can-create-in-one-workbook-tp2299700p4640115.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: the maximum number of sheets can create in one workbook?
Posted by Neil Benn <ne...@gmail.com>.
Excel 2003 can only have 255 worksheets in a workbook - the limit goes
away with later verions
On Wed, Jul 27, 2011 at 8:34 PM, felixesanchez <fe...@sanchezit.com> wrote:
> I having the same problem with POI 3.6. Does anybody know how can I pass this
> problem?
>
> thanks,
>
> Felix Sanchez
> felix@sanchezit.com
>
>
> java_lee wrote:
>>
>> Dear All
>>
>> I use the lastest version of POI(3.1) to create 1400 sheets in a
>> workbook. And when I open the XLS file generated by the programe, the MS
>> excel 2003 pops the error like bellow.
>>
>> "Damage to the file was so extensive that repairs were not possible.
>> Excel
>> attempted to recover your formulas and values, but some data may have been
>> lost or corrupted."
>>
>> code :
>>
>> import java.io.File;
>> import java.io.FileNotFoundException;
>> import java.io.FileOutputStream;
>> import java.io.FileWriter;
>> import java.io.IOException;
>> import java.io.OutputStream;
>>
>> import org.apache.poi.hssf.usermodel.HSSFSheet;
>> import org.apache.poi.hssf.usermodel.HSSFWorkbook;
>>
>>
>>
>> public class Test {
>>
>> public static void main(String[] args) {
>> FileOutputStream fs = null;
>> try {
>> fs = new FileOutputStream("test.xls");
>> } catch (FileNotFoundException e) {
>> e.printStackTrace();
>> }
>>
>> HSSFWorkbook wb = new HSSFWorkbook();
>> String sheetName = "s";
>>
>> for(int i=0;i<2000;i++){
>> sheetName = sheetName + i;
>> wb.createSheet(sheetName);
>> sheetName = "s";
>>
>> System.out.println("sheet of number " + i + "finish!!!");
>>
>> }
>>
>> try {
>> wb.write(fs);
>> fs.close();
>> } catch (IOException e) {
>> e.printStackTrace();
>> }
>>
>> System.out.println("finish!!");
>>
>> }
>> }
>>
>>
>> And if the number of sheet is under 1370 or open it with EIOffice(a
>> office programe like ms office) even it more than 1400 sheets, it can be
>> opened normally. Can anyone of you tell me why?
>>
>> Thanks in advance for your help!
>> Andy
>>
>
>
> --
> View this message in context: http://apache-poi.1045710.n5.nabble.com/the-maximum-number-of-sheets-can-create-in-one-workbook-tp2299700p4640053.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> 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