aspose file tools*
The moose likes Other Open Source Projects and the fly likes exporting to excel with specif format Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "exporting to excel with specif format" Watch "exporting to excel with specif format" New topic
Author

exporting to excel with specif format

alsoumahi alBatal
Ranch Hand

Joined: Nov 22, 2009
Posts: 94
Hi experts , I know that this question has been asked before me by many people , I have already searched and read their questions regarding exporting to excel
my question is not about how to export data as excel type , I know how to export and I already export some files , but how about if I want to add logo in excel , or to be in proper format or make
merging , or wrap text , so I want to add this features to my excel , how can I do that

my way to export in excel , is this :

I create excel file in server , then send it to client as excl type

here in this way , it is difficult to design excel to specific format and fill it with information then send it to client

is there any other way !!!

for example filling ready excel made by hand , let the servlet to fill cells in excel , then send it to client , is it possible

thanks a lot
Philip Thamaravelil
Ranch Hand

Joined: Feb 09, 2006
Posts: 99
alsoumahi alBatal wrote:Hi experts , I know that this question has been asked before me by many people , I have already searched and read their questions regarding exporting to excel
my question is not about how to export data as excel type , I know how to export and I already export some files , but how about if I want to add logo in excel , or to be in proper format or make
merging , or wrap text , so I want to add this features to my excel , how can I do that

my way to export in excel , is this :

I create excel file in server , then send it to client as excl type

here in this way , it is difficult to design excel to specific format and fill it with information then send it to client

is there any other way !!!

for example filling ready excel made by hand , let the servlet to fill cells in excel , then send it to client , is it possible

thanks a lot




Google "Java Excel API".. This can easily be done with a Java-Excel library.


Cheers,
Philip
alsoumahi alBatal
Ranch Hand

Joined: Nov 22, 2009
Posts: 94
Java Excel API


thanks for reply , I already searched about that , but I don't want to code excel with specific format because format is changing I have a lot of format to export
so in that case I have to code and create each servlet special for one excel format

is it possible to make an excel with proper format made manually , so the remaining is to fill the cells with information

thanks a lot
Tim Moores
Rancher

Joined: Sep 21, 2011
Posts: 2408
alsoumahi alBatal wrote:is it possible to make an excel with proper format made manually , so the remaining is to fill the cells with information

Sure. Just prepare the spreadsheet by hand how it should look like, and then you can use POI to fill in the data and save it.
 
 
subject: exporting to excel with specif format