I use xml for a few of our fancier reports.  My technique is to built the Excel 
file the way I want it, save it as xls, then pick it apart.  Again, it is a lot 
of work, but they are beautiful.  Multiple worksheets, colors, formulas, pane 
freezing, etc.  This might be the brute force method, but it works.

John

-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Friday, June 01, 2012 3:37 PM
To: U2 Users List
Subject: Re: [U2] Excel Worksheets

If you don't mind switching from csv to xml, you define worksheets that way.

Google excel and xml and worksheets

It's a lot more work, but it works

George

-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis
Sent: Friday, June 01, 2012 3:22 PM
To: U2 Users List
Subject: Re: [U2] Excel Worksheets

That would be nice.

I create separate CSV files and use macros to load each into a separate sheet.

-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jim Koca
Sent: Saturday, June 02, 2012 3:17 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Excel Worksheets

I am sending a CSV file to excel, and would like to divide it into separate 
worksheets. Is there a special value I can insert in the file which would cause 
the following data to create a separate work sheet ?

Thanks,


Jim Koca

Cell Phone: 630.253.0007
Home Office: 630.629.5589
Email: jk...@comcast.net

_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
________________________________


Dave Davis
Team Lead, R&D

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
        [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]<http://www.harriscomputer.com/>
        6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.com<http://www.harris-schoolsolutions.com>

This message is intended exclusively for the individual or entity to which it 
is addressed. This communication may contain information that is proprietary, 
privileged or confidential or otherwise legally exempt from disclosure. If you 
are not the named addressee, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
message in error, please notify the sender immediately by e-mail and delete all 
copies of the message.

_______________________________________________
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

_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to