jxl + writing into an existing excelsheet

[bootsy]

Hi,

I want to manipulate Datas in an existing Excelsheet. First is writing a Value into a Formula-Field (ig. C5 = C4+1000). Then I want to read out the new Value. The Problem is to write into an existing Sheet. Maybe I'm just to silly to find the solution but it can't be to dificult...?

First I have to open the Workbook:

// no good because this way I get an simple Workbook...
WritableWorkbook wrWb = Workbook.openWorkbook("MyWorkbook");

// here I create a new WritableWorkbook
WritableWorkbook wrWb = Workbook.createWorkbook("MyWorkbook");

Can you please say me how that works?

Kind regards,
Ulli

 

[Guest]

that does not work... You do only can edit a copy of a excelsheet!

 

[thE_29]

You work with POI or?