File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

exporting to excel with specif format

 
alsoumahi alBatal
Ranch Hand
Posts: 104
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 99
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 104
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 2501
13
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic