Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Using HSSFWorkbook to copy excel file

 
daphna deutsch
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

The program bellow creates a copy of an excel file.
I am using the HSSFWorkbook object because i need to change information on the new file.
The problem is that an object that was created in the original file lost its focus on the copied file.
For example, I add a power point object in the original file, and in the copied file i can see the object, but clicking on it reveals the error message "cannot start the source application for this object"

Does anyone know this problem?



FileInputStream fileIn = null;
FileOutputStream fileOut = null;
try{
String xlsFileName = "D:/i3/32_100006.xls";
String xlsFileNameCopy = "D:/i3/Copy32_100006.xls";
fileIn = new FileInputStream(xlsFileName);
POIFSFileSystem fs = new POIFSFileSystem(fileIn);
HSSFWorkbook wb = new HSSFWorkbook(fs);

/* change the file*/

fileOut = new FileOutputStream(xlsFileNameCopy);
wb.write(fileOut);
fileOut.close();
}
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic