This is not a solution - but a recommendation.
If you output your Excel files in the XML format - then you can specify whatever you like (excluding charts).
A simple way to determine what XML you need is to create a test Excel file 1st and then save it as XML and paramterise it.
You can set Page size, document headers, footers, hide gridlines, define styles - anything you want.
There is a Perl module (Spreadsheet::WriteExcelXML) which I use for this - rather than writing the XML myself.
But the Excel XML is reasonably simple.
I'm afraid I don't know if there are any corresponding Java utilities.
HTH
Mike
U K Laxmi wrote:
Thank you for the information.
What i mean by header & footer is, column headers and some information like model number, date and approval signature columns etc.. to appear in every page when they take hard copy of the report. Is such a thing possible? Pls inform.
The end user of the application doesn't want any
manual intervention. When he click on 'Export to
Excel' button in the web application HTML report, he
want the excel file get downloded (file dialog box
appears & he save it to his local disk) which has all
header & footer information set. Currently my
application can provide header once at the top of the
report and footer (approval columns & date) at the
very bottom of the report. THe column headings &
approval columns doesn't appear on every page.
I'm unable to ahcieve this in web (HTML). It i cna do it in web, when i download that in excel, it will show. Do you know any work around for this? Pls inform.
Thank you. Laxmi
--- "Frank W. Zammetti" <[EMAIL PROTECTED]> wrote:
Hi,
-- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 10/05/2005
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
