RE: [sqr-users] SQR to Excel - error in opening the output file.

[James Womeldorf <jwomeldo@fastenal.com>]

Does your sqc produce files in the SYLK format?
If so. the last line of the file must consist of an uppercase E.

-----Original Message-----
From: Bob Stone 
Sent: Friday, June 24, 2005 3:43 PM
To: 'This list is for discussion about the SQR database reporting
language from Hyperion Solutions.'
Subject: RE: [sqr-users] SQR to Excel - error in opening the output
file.


That means the excel file was not closed off correctly, and it expects to
find whatever EOF character(s) at the end...

Check your logic on closing the file.  (different than just open/write/close
sometimes...depending on how complicated your excel printing is).



-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of
Raghvendra Dharwada
Sent: Friday, June 24, 2005 3:37 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] SQR to Excel - error in opening the output file.


Hi,

I have a custom sqc (MM_EXCEL.sqc) which has several functions for 
outputting data from SQR to excel. I am using this SQC in my SQR to print 
the output to excel.The excel file is created successfully and also I get 
the correct output too in the required format.But then, when I try to open 
this excel file I get errors displayed on the Message box saying:

1st Message box:
Cannot read record 7199.
Continue reporting each error?

And when I click 'No' I get the following on the 2nd Message Box:
Microsoft Office Excel cannot convert some of the cells.
The total number of errors found is 1


One of my colleague suggested me to check the cell widths and the numeric 
formats of the cells I am going to print. I verified them too, but still I 
cannot get rid of the error.

Since this is not a general case, I know, it is hard for someone to provide 
a solution, but my hope is that if anyone happened to get similar errors, 
please let me know how you
rectified it.

Thanks.

_______________________________________________
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