Sure. It's a good pointer to me to look into. Sure to do more study on this.
Thank you. Laxmi --- Mike Trotman <[EMAIL PROTECTED]> wrote: > 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] > > Discover Yahoo! Get on-the-go sports scores, stock quotes, news and more. Check it out! http://discover.yahoo.com/mobile.html --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]