to open an excel file and write

prithaa

Hello Is there an article to open an excel file and write through jxl files. Every time I try to write into excel file a new file is created instead of opening the old file. Pritha

Lost User

prithaa wrote:

Is there an article to open an excel file

Quite possibly, have you tried a Google search?

prithaa wrote:

a new file is created instead of opening the old file.

Without seeing your code I don't think we can guess what you may be doing wrong. [edit] This method[^] is probably what you are looking for. [/edit]

speaking as ...

prithaa

thanks but the above link is not opening my problem was the following

InputStream inp = new FileInputStream("d:/Writefile.xls");
WorkbookSettings ws = new WorkbookSettings();
Workbook wb = Workbook.getWorkbook(inp, ws);
Sheet sheet = wb.getSheet(0);
//Cell cells[] = sheet.getRow(0);
//Cell cell = cells[0];
//String cellContents = cell.getContents();
//Modify the cellContents here
//Write the output to a file
Number number;
number = new Number(0, 0, 453.25, times);
((WritableSheet) sheet).addCell(number);
wb.close();

The above code doesnt add the cell to the given file just opens the file.I get DispatchUnCaughtException for the line

((WritableSheet) sheet).addCell(number);

Thanks for the reply Pritha

Lost User

Looking at the documentation (this link works for me[^]) it would suggest that you need to create a WritableWorkbook[^] and within that create a WritableSheet[^]. Casting a Sheet to a WritableSheet will not change the underlying object; it is still a (read-only) Sheet.

speaking as ...

prithaa

thanks Richard but a

WritableWorkbook creates a new workbook and has no method which opens a workbook

Pritha

Lost User

This method[^] creates one. May I suggest you go through all the documentation to check which methods are required to create the objects you are trying to work with.

speaking as ...

prithaa

thanks for the article but i cant still open a writableworkbook .i can write on a new

workbook

but cant write on an existing workbook I didnt find any method doing that either in writableworkbook regards Pritha

Anil Kumar 23

Check this article ... may be of some help for your purpose Read and write to excel files in java

Lost User

prithaa wrote:

thanks for the article

I did not provide one, I wonder what you have been looking at.

prithaa wrote:

but i cant still open a writableworkbook

Did you follow my advice and read all the documentation in the link I gave you? It clearly shows how to create a writeable workbook from an existing file.

speaking as ...

prithaa

yes i did read the link u sent and looked at the class writablework but there is no method which opens an existing .xls file Regards Pritha

Lost User

Sorry, previous link was not correct owing to HTML frame. However, I think [this one](http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/Workbook.html#createWorkbook\(java.io.File, jxl.Workbook, jxl.WorkbookSettings))[[^](http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/Workbook.html#createWorkbook\(java.io.File, jxl.Workbook, jxl.WorkbookSettings))] is the best you will get.

speaking as ...

prithaa

thanks for replying

Workbook workbook = Workbook.getWorkbook(new File("d:/Writefile.xls"));
WritableWorkbook copy = Workbook.createWorkbook(new File("d:/Writefile1.xls"), workbook);
copy.write();
WritableSheet sheet = copy.getSheet("Report2");
Number number;
number = new Number(0, 0, 453.25, times);
sheet.addCell(number);
copy.write();
copy.close();

I want to open an existing file and add a cell to an existing sheet. The above code opens the file but the cell editing doesnt happen. Regards pritha

Lost User

Sorry, no idea why that's happening; I think you may need to re-check the documentation and work with your debugger.

speaking as ...

prithaa

Thankyou Richard for your help

Lost User

Just for the record, I have never used these packages[^]; all the information I gave you I found by using Google and reading the Javadocs.

speaking as ...