RE: [sqr-users] CSV To XLS

[Jeff.Steinfeldt@wellsfargo.com]

If you can execute a VB or Java script then you can open an Excel object and
apply pretty-much any formatting you want to your document.  Be aware that
the Excel object model exposed via VB script and Java script differs
slightly from the one exposed via VBA within Excel but recording an Excel
macro will get you very close.

-----Original Message-----
From: sqr-users-bounces+jeff.steinfeldt=wellsfargo.com@sqrug.org
[mailto:sqr-users-bounces+jeff.steinfeldt=wellsfargo.com@sqrug.org] On
Behalf Of Bob Stone
Sent: Tuesday, March 01, 2005 8:30 AM
To: 'This list is for discussion about the SQR database reporting language
from Hyperion Solutions.'
Subject: RE: [sqr-users] CSV To XLS


CSV files open in Excel.  You can name your csv output file '.xls' if you
want, and it will open as Excel opens the CSV file. There are certain
formatting things in Excel which cannot be set when outputting as a CSV,
though.  I believe Jeff Steinfeldt has a snipet of VB code he runs that can
run some formatting, but I believe it needs to be run on a CSV file in order
to do the formatting.  You can run that in your SQR after you're done
outputting to csv.  

In unix we write: 
      call system using $command #unix_status   
      if #unix_status <> 0
        show 'Error sending e-mail to: ' &email_address
      end-if 

where $command is the line that would say 'run the conversion script on the
csv to output the xls' and #unix_status is the output line.

For whatever formatting you need to do, you can figure out the code for it
by starting an excel macro, then doing your formatting.  The code Excel uses
for the macro is VB, and recreateable.  

-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of John F.
Connell Jr.
Sent: Tuesday, March 01, 2005 8:17 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] CSV To XLS


I'm looking to convert a csv output file to xls file in sqr or by using a
command line utility. Does anyone know or have experience using a csv to xls
command line utility that could perform this task?

 

Regards,

 

John

 

John F. Connell Jr.

JFC & Associates

53 Perch Pond Road

Chatham, MA 02633

 

email   - jfc.associates@comcast.net

www    - www.williamsconnell.com

 

Phone - 1 (508) 945-4191

Fax     - 1 (508) 945-1609

Cell     - 1 (508) 542-3342

 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users