Win a copy of Node.js Design Patterns: Design and implement production-grade Node.js applications using proven patterns and techniques this week in the Server-Side JavaScript and NodeJS forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

exporting to excel with specif format

 
Ranch Hand
Posts: 119
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 99
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 119
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Saloon Keeper
Posts: 7109
165
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic