Thanks for the info. I will read on this. --- Mike Curwen <[EMAIL PROTECTED]> wrote:
> 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. > === message truncated === __________________________________ 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]