I've made a file browser in java that opens and read already been made excel files. (using Apache poi 3.9 library)
program read those files perfectly but i want to update some of those files. how can i be able to update those files through my program.
is there is any library or function/class that might be helpful, or also any other language that can support that feature (among c/c++, python)..???

AFAIK Apache POI supports changing Excel files as well as reading, so where is your problem?
–
Doc BrownAug 19 '13 at 11:10

right now i've to first open a file then read cells then creat another workbook, copy data from first file to that workbook then write 2nd workbook into the first one.... (is this an efficient way..??? I don't think so)
–
Haseeb AkhtarAug 19 '13 at 11:28

2

This question appears to be off-topic because it is about an implementation issue with Apache POI.
–
GlenH7Aug 19 '13 at 12:28

Thanks for response Spoike but i don't want to creat extra workbooks i just want to open one show that one to the user and let the user to change it. just like we did in Ms Excel.
–
Haseeb AkhtarAug 19 '13 at 11:30

@haseebAkhtar Wouldn't it be better to open the file in Excel from your Java program?
–
SpoikeAug 19 '13 at 11:34

@haseebAkhtar You can use Desktop to open files with appropriate program. I.e. it assumes that Excel is installed in the user's computer and that the extension is correctly associated with Excel.
–
SpoikeAug 19 '13 at 11:54

If POI is not sufficient for any kind of reasons, you may have to utilize Excel by using COM Automation for such a task. Read this SO post for more information how to do this in Java. But beware, this will have some drawbacks: