This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan 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 Android Security Essentials Live Lessons this week in the Android 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
Author

Using HSSFWorkbook to copy excel file

daphna deutsch
Greenhorn

Joined: Nov 17, 2005
Posts: 17
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();
}
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41124
    
  45
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?


Ping & DNS - my free Android networking tools app
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Using HSSFWorkbook to copy excel file
 
Similar Threads
Updating excel spreadsheet
java program for pdf file to excel file conversion
excel
jsp with POI FILE System concept.
Using HSSFWorkbook to copy excel file