RE: [sqr-users] Controlling Printing Properties in Excel

[Bob Stone <bstone@fastenal.com>]

I've dealt a bit with making Excel reports using SQR, and I've found that a
lot of those settings cannot be set programmatically.  I recently tried to,
and couldn't figure out how, what, or where they were being set.

What we did was create the formatted excel file just the way we wanted and
looked at it as text.  Then when we create the csv file from SQR we recreate
that text formatting, and the output opens in Excel.  However, when we made
changes of headings, paper view, paper size, force to fit one page, etc the
csv text version of the file was the exact same as before the change.  We
couldn't recreate those settings.  I'm not sure what excel does with those
settings or where they are.

I think the problem is that the excel spreadsheet we can actually recreate
is a simple version in excel.  And all those other settings are more
complicated properties that only show up in the more complex files handled
by excel (such as excel v.2000, excel v.XP, etc).  Once the file is opened
you can set the settings because it will open the simple file in a complex
file format.  I could be slightly off-base here, but I think it cannot
currently be done in the SQR itself.

Our solution was that if a user wanted to actually print the report out,
they would need to mess with some of those settings themselves.  If it's a
big deal, you might make up a document suggesting all the settings they'd
need to tinker with to get the report to print out well.  We think that most
of our users will just view the electronic copy of those reports, so it's
not a big deal.




-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of
Ilko, Holli
Sent: Tuesday, January 18, 2005 10:48 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Controlling Printing Properties in Excel


Hello.

Using SQR, we have created a .csv file.  Does anyone know if it is possible
to then control the printing properties of the spreadsheet using SQR?  We'd
like to force it to be set to landscape and we would also like to force it
to fit to one page rather than having the users change these settings
manually once they have opened the spreadsheet.  Any suggestions???

Thanks,
Holli

_______________________________________________
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