you should consider using POI, if you need Excel-only features like "footer repeated on every page". Specifically: http://jakarta.apache.org/poi/hssf/quick-guide.html#HeaderFooter
> -----Original Message----- > From: U K Laxmi [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 10, 2005 9:53 AM > To: Tomcat Users List; [EMAIL PROTECTED] > Subject: Re: Free reporting s/w that works with apache+tomcat > > > 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, > > > > CSV files don't generally contain header and footer > information... you > > can get column headers in the first row, that's > > about it. I don't > > believe DataVision will export to Excel natively, > > but check the docs in > > case I'm wrong. > > > > Do you really mean header and footer in the sense of > > a Word document? > > It's a bit unusual to have such a thing in an Excel > > document (although > > not at all unheard of), so I'm wondering if maybe > > you mean something a > > little different, i.e., maybe just column headers > > and some sort of totals? > > > > Frank > > > > U K Laxmi wrote: > > > Thank you for the information. I read your report > > and > > > it looks interesting. I went to DataVision web > > site > > > and found that it can export comma separated files > > ie. > > > CSV file. Will it be possible to retain header and > > > footer information with a .CSV file? I basically > > want > > > excel files as the report output. B'coz the end > > user > > > needs to send to those reports to it's vendors. > > Excel > > > is the most desired format for them. Pls give your > > > feedback on this before i start implementing on > > this. > > > Thank you. > > > > > > --- "Frank W. Zammetti" <[EMAIL PROTECTED]> > > wrote: > > > > > >>Take a look at DataVision. I think you'll like > > it. > > >>I wrote an article > > >>a while back specifically dealing with using it in > > >>web applications. > > >>Although the article uses servlets and you say > > your > > >>using JSPs (just > > >>JSP's?) it should still be applicable. > > >> > > >>http://www.omnytex.com/articles > > >> > > >>Feel free to ping me if you decide to use it and > > >>need some help getting > > >>going beyond the article and included > > documentation. > > >> > > >>-- > > >>Frank W. Zammetti > > >>Founder and Chief Software Architect > > >>Omnytex Technologies > > >>http://www.omnytex.com > > >> > > >>U K Laxmi wrote: > > >> > > >>>I'm developing a web application using > > >> > > >>apache+tomcat > > >> > > >>>on windows 2000 machine. I'm using Ms Access 2003 > > >> > > >>as > > >> > > >>>the backend. I'm using JSP for developing web > > >>>application. I'm developing some web based > > reports > > >> > > >>in > > >> > > >>>HTML. But when i export them to Excel, it doesn't > > >> > > >>look > > >> > > >>>exactly same as that of HTML report. Moreover i > > >> > > >>need > > >> > > >>>some header and footer information appear in the > > >>>report. That i'm unable to achieve using JSP and > > >> > > >>HTML. > > >> > > >>> > > >>>So, i'm looking for a free reporting software > > that > > >> > > >>can > > >> > > >>>meet above functionality and can work with > > >>>apache+tomcat. If anyone know any work worunds > > for > > >> > > >>my > > >> > > >>>problem, pls inform me. It will be a great help > > to > > >> > > >>me. > > >> > > >>>Thank you. > > >>> > > >>> > > >>> > > >>>__________________________________ > > >>>Yahoo! Mail Mobile > > >>>Take Yahoo! Mail with you! Check email on your > > >> > > >>mobile phone. > > >> > > >>>http://mobile.yahoo.com/learn/mail > > >>> > > >>> > > >> > > > > > > --------------------------------------------------------------------- > > > > > >>>To unsubscribe, e-mail: > > >> > > >>[EMAIL PROTECTED] > > >> > > >>>For additional commands, e-mail: > > >> > > >>[EMAIL PROTECTED] > > >> > > >>> > > >>> > > >>> > > >>>. > > >>> > > >> > > >> > > >> > > >> > > >> > > > > > > --------------------------------------------------------------------- > > > > > >>To unsubscribe, e-mail: [EMAIL PROTECTED] > > >>For additional commands, e-mail: > > >>[EMAIL PROTECTED] > > >> > > >> > > > > > > > > > > > > > > > Discover Yahoo! > > > Have fun online with music videos, cool games, IM > > and more. Check it out! > > > http://discover.yahoo.com/online.html > > > > > > > > > > > > > > > > -- > > Frank W. Zammetti > > Founder and Chief Software Architect > > Omnytex Technologies > > http://www.omnytex.com > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: > > [EMAIL PROTECTED] > > > > > > > > > Discover Yahoo! > Find restaurants, movies, travel and more fun for the > weekend. Check it out! > http://discover.yahoo.com/weekend.html > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
