Writing to EXCEL -- Workbook.write() not working

[Priya Sri]

Hi all,

I am trying to write some data to an excel using the below code. The data in MyExcel1 can be found in the variable "copy". But is not getting written to MyExcel2.xls
Please help !!

try {
           excelFile = File.createTempFile("C:/MyExcel1.xls");
           File excelTemplate = new File("C:/MyExcel2.xls");
           Workbook workbook = Workbook.getWorkbook(excelTemplate);
           WritableWorkbook copy = Workbook.createWorkbook(excelFile, workbook);
           copy.write();  
           copy.close();
        } catch (Exception e) {
                    JOptionPane.showMessageDialog(parent, "Error in Report Generation", "Report Error", JOptionPane.ERROR_MESSAGE);
        }

Regards,
Priya Sri

[Ulf Dittmer]

It doesn't look like the code writes to MyExcel2.xls. It writes to whatever is returned in line 2. I'm not sure what that would be - java.util.File has no method called createTempFile(String).

[Priya Sri]

Very sorry...the code there is actually like this:
excelFile = File.createTempFile("MyExcel1", ".xls",new File("C:\"));

[Ulf Dittmer]

OK, so that confirms it - nothing would get written to MyExcel2.xls.

Why are you using createTempFile instead of "new File"?