exporting to excel with specif format

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

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

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

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.