Group (I didn't see who the OP was), I have a perl script/unidata program which will do XLS (Excel 2003 and before). It requires that perl be installed and a few *excel.ppms* freely available. The black box unidata driver program handles column heading, formatting, justification, sorting, subtotaling and grouping. I'm working through the OpenXML formats for Office, I've conquered Word 2007 and moving onto Excel 2007 (openxml) next. I will update the group when I finish. If anyone wants the perl/excel2003 scripts and unidata programs let me know. (email: u2ex...@remove-thissoutheast-florida.com) south east (dash) florida dot com
Don Verhagen (Plugging along in SQL and .Net where a simple generic empty validation ain't so simple!) > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King > Sent: Monday, July 06, 2009 12:55 PM > To: U2 Users List > Subject: Re: [U2] Simple Export to Excel > > >On Mon, Jul 6, 2009 at 9:59 AM, Larry Hiscock > <lar...@wcs-corp.com> wrote: > >Or, you can create your export in the Office XML format, and > tell excel > >explicitly what to do with each column of data. > > Absolutely. But what a time-consuming chore that can be... :-) > > -K > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users