This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes Other Open Source Projects and the fly likes Using HSSFWorkbook to copy excel file Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Using HSSFWorkbook to copy excel file" Watch "Using HSSFWorkbook to copy excel file" New topic

Using HSSFWorkbook to copy excel file

daphna deutsch

Joined: Nov 17, 2005
Posts: 22

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;
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);
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42965
That may be a limitation of POIFS (the document access routines POI uses).

Have you tried copying the file first by other means, and then using POI to change the fresh copy?
I agree. Here's the link:
subject: Using HSSFWorkbook to copy excel file
It's not a secret anymore!