Meaningless Drivel is fun!
The moose likes BEA/Weblogic 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
JavaRanch » Java Forums » Products » BEA/Weblogic
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);
I agree. Here's the link:
subject: Using HSSFWorkbook to copy excel file
It's not a secret anymore!