Assuming that by "template" you mean an XLS file, then the quick guide has plenty of examples on how to work with them. It shows to open a file, how to get a sheet in the file, how to get a row of records in a sheet, how to get a cell in a row, how to read and wrote the values and formulas in a cell, and how to save the file. Maybe not all in one example, but it's all there. What else would you need to know?
Suppose If want to modify the col in the excel sheet automatically through database
Can you please tell us what, "automatically modifying a column in an excel file through database" mean?
Also, while posting the code use the "Code" button in the message editor window to wrap the contents in a code block. I see that you have used <code> tags while posting, but the code tags here, are actually wrapped using [CODE].
when I open and read a xsl file which is a large file(3.324kb). I am getting java out of memory. This xsl file contains charts also.Is there any way I can convert to another format and read it.(including data and graphs)
Please someone help me in this case. [ March 18, 2008: Message edited by: lakshmi manepally ]
If neither POI nor jExcelApi work the options are limited. OpenOffice can open all kinds files -XLS included-, and save them to various other formats, and it does have a Java API. It also has much more of a learning curve than the pure Excel APIs, though.
I don't find anything in the google.Could you please send me some links?
Also one question. How is it possible if I open same excel into (because of the memory issue) htm and data should be added from the database on the htm ? Later I convert into excel inside the code to generate corresponding graphs or charts and open again as a htm page.