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)..???
3
-
AFAIK Apache POI supports changing Excel files as well as reading, so where is your problem?– Doc BrownCommented Aug 19, 2013 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 AkhtarCommented Aug 19, 2013 at 11:28
-
2This question appears to be off-topic because it is about an implementation issue with Apache POI.– user53019Commented Aug 19, 2013 at 12:28
Add a comment
|
2 Answers
There are a bunch of examples on the Apachi POI library site on how to change and save Excel files. Here are a couple of pages to get you started:
- Apache POI Spreadsheet HOWTO - The New Halloween Document
- Apache POI Spreadsheet Quick Guide - Busy Developers' Guide to HSSF and XSSF Features
E.g. workbook objects in the library have a write(…) method if you want to save the contents of it to a file using an appropriate OutputStream:
// Save a workbook (wb)
FileOutputStream out = new FileOutputStream("my_workbook.xls");
wb.write(out);
out.close();
If you want to open the files in Excel you can, according to this answer, try using Desktop which is available in JDK6.
Desktop.getDesktop().open(new File("c:\\file.xls"));
-
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. Commented Aug 19, 2013 at 11:30
-
@haseebAkhtar Wouldn't it be better to open the file in Excel from your Java program?– SpoikeCommented Aug 19, 2013 at 11:34
-
-
@haseebAkhtar You can use
Desktopto 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.– SpoikeCommented Aug 19, 2013 at 11:54 -
Thats cool, thanks for giving me SucH a HelPfuL information.. :) Commented Aug 19, 2013 at 12:00
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:
- platform-dependent (will only work on Windows)
- won't work well for a server-side application
- slow (compared to direct access by POI)
answered Aug 19, 2013 at 11:22
