Article:		Reading and Writing Excel Files with POI
Subject:		File increase size problem
Date:		2007-05-29 06:43:17
From:		jagjit
Hi ,m writing in excel sheet using POI as well as jexcelfile..........everytime the file size doubles..if the template i use to write is of 2 mb.then the output file size becomes 4 mb.........can sm1 help me on this?

Showing messages 1 through 7 of 7.

• File increase size problem
  2007-08-31 00:11:30  Subhash1027 [View]
  
  
  Hi Jagjit,
  I am also facing the same problem. Also when the open the file(double sized file), it is getting opened in repaired mode. Did you find any fix for this? If so, please let me know.
  Thanks in advance.
  
  Thanks & Regards,
  Subhash

• File increase size problem
  2007-08-17 04:59:15  raj7711 [View]
  
  
  Hi,
  
  Greetings!! I am using Apache POI package for a Java application to read and write excel files. I am facing one specific problem.
  
  I have a excel template which contains complex macros, images and complex formatting. I used HSSFWorkbook to read the input template file and filled in data in the template, and created the output file using FileOutputStream. The output file is created with all the required data and the formatting remains same and the output file looks just like the template file with all formatting and the required data. But the problem is, my input template file size is 831KB. But the output file size is 1919KB. The output file size is getting doubled. Is there any solution to fix this issue?
  
  Another thing I tried is, If I open the bigger output file (1919KB) in MS-Excel and saved the file manually, then the file size reduces to normal size (850KB). I couldn't understand why the size increased tremendously if the file contains macros.
  
  I have given the code below:
  
  
  
  HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream(templateFileName), true);
  
  HSSFSheet sheet = wb.getSheet("Adjustment Request");
  
  HSSFRow row = sheet.getRow(10);
  HSSFCell cell = row.getCell((short)3);
  
  if (cell == null) {
  cell = row.createCell((short)3);
  }
  
  cell.setCellType(HSSFCell.CELL_TYPE_STRING);
  cell.setCellValue("This is test");
  // Write the output to a file
  FileOutputStream fileOut = new FileOutputStream(destFileName);
  wb.write(fileOut);
  fileOut.close();
  
  Thanks and Regards,
  Raj
  
• How to read images and macros from excel sheet by using poi
  2008-06-13 05:22:06  anil47 [View]
  
  
  Hi,
  can you please tell me how to read images and macros from excel sheet by using poi. Please,send me the program to my mail id.
  
  Thanks in Advance
• File increase size problem
  2008-06-11 07:16:59  anil47 [View]
  
  
  Hi Raj,
  I am able to read and write general values from excel file by using POI But i am unable to read macros in excel file. So,please tell me the code to read macros in excel values
  Thanks in Advance,
  
  anil
• File increase size problem
  2008-01-14 07:05:54  Hifzur [View]
  
  
  Hi Raj,
  We have a similar project requirement in which I have to use an existing template & write the data into excel file.
  But I am new to POI Api.
  Could you share the code snippet.
  
  Regards
  Hifzur
• File increase size problem
  2008-02-25 22:47:29  VJeba [View]
  
  
  Hi,
  
  I am new to POI, and in my current project I need to export a SWT Table data into an .xls template.
  
  Please give me a sample code.
  
  Regards
  Jeba
• File increase size problem
  2007-08-31 00:06:37  Subhash1027 [View]
  
  
  Hi Raj,
  I am also facing the same problem. Also when the open the file(double sized file), it is getting opened in repaired mode. Did you find any fix for this? If so, please let me know.
  Thanks in advance.
  
  Thanks & Regards,
  Subhash