JEXCEL copy a File , cannot able to open ?

[vicky ece]

Hi all,

   public static void main(String args[]) throws Exception{
		File sourceFile = new File("/home/Downloads/R&D/JEXCEL/Sample/Sample_WordMasterTemplate.xls"); // This File is Downloaded from My Inbox
		File destFile = new File("/home/Downloads/R&D/JEXCEL/Sample/CopyFile.xls");
		Workbook workbook = Workbook.getWorkbook(sourceFile);
		WritableWorkbook writableWorkbook = Workbook.createWorkbook(destFile, workbook); // Coping the source file to destination file
		writableWorkbook.write();
		writableWorkbook.close();
	}
   

When i try the above program most of the time its giving null pointer exception or some times copied xls file is not in the proper format to open (I am using Ubuntu Linux OS)but if i open the "Sample_WordMasterTemplate.xls" and do so editing and save and close it then every thing works fine .. only when i download a file from network and try to process through JExcel this problem arises otherwise everything is working fine .

[Tim Moores]

Any particular reason you're not simply using FileInputStream/FileOutputStreamm for copying the file? Seems like there would be less chance for problems.

[vicky ece]

Tim Moores wrote:Any particular reason you're not simply using FileInputStream/FileOutputStreamm for copying the file? Seems like there would be less chance for problems.

Thanks for you reply ....

I have tried with FileInputStream/FileOutputStreamm the same problem arises.

And also i find that, if i have a cell with formula then every things works fine[Actually NullPointer Exception is caused by some method in Jexcel Api class i found that by Debugging , so i tried with adding a formula in a cell then uploaded to my mail and then downloaded from my Mail every thing works fine but without that one the same problem arises] ...................