copy to Excel not working

[Buckeye]

I have occationally had trouble using copy to Excel from the SQL window results. It creates an xls file in the temp folder but does not open it. When I try to open it myself, Excel says "unable to open file" and "Errors were detected in 'tmp001.xls,' but Excel was able to open the file my making the repairs listed below" then below it says "damage to the file was so extensive that repairs where not possible". I have reinstalled PL/SQL Dev. and Office 2003 and PL/SQL Dev. again. Using the latest release.

 

[Marco Kalter]

I am not sure what could cause this, and we have not had any similar problem reports before. Does the "Copy to Excel" function end normally, or does it give an error message or hang-up?

 

[Buckeye]

The "copy to excel" function seems to end normally.

Do you think it might help to uninstall PL/SQL Dev. and do a clean install? Are there any folders, files, registry entries I should make sure are removed before installing again?

 

[Buckeye]

I figured something out...this SQL used to work. Now it seems to be having trouble with the xNEW_FIN_CELL column in which I am building a formula. fin_cell contains a cell reference in the RxxCxx format (ie: R10C3 which is the same as cell C10) The output of this column looks like: ="R"&c10&"C"&d10 which makes Excel display something like R10C3.

I downloaded 6.0.5 on 03/15/2005 which is probably when I started having problems?

select
FIN_REPORT_ID
, FIN_CELL
, substr(fin_cell,2,instr(fin_cell,'C')-2) as xCELL_ROW
, substr(fin_cell,instr(fin_cell,'C')+1,2) as xCELL_COL
,'="R"&&c' || to_char(ROWNUM + 1) || '&&"C"&&d' || to_char(ROWNUM + 1) as xNEW_FIN_CELL
, FIN_FIELD
, FIN_COLUMN
, ACCOUNT_MASK
, OLE_DETAIL_PER_ACCOUNT
, OLE_ACCOUNT_NUMBER
, OLE_ACCOUNT_DESCRIPTION
, nvl(CURRENCY_ID,1) CURRENCY_ID
from lrpettit.cell_definition d
where d.fin_report_id = 95
;

 

[Buckeye]

I found a backup I had of the 6.0.4 setup so I went back to that version. Now the SQL results for the SQL in the previous post copy to Excel just fine.

 

[Marco Kalter]

Thanks for the info, we'll check it out.

 

[cjlemmon]

Just so you know it is not an isolated incident. I, along with others at my company using 6.0.5. am experiencing the same problem copying to excel.

 

[Marco Kalter]

Can you give this version a try? Let me know how this turns out.

 

[Buckeye]

Marco, I tried it and it sent data to Excel but didn't do the formula cell the same way 6.0.4 does. It only put ="R" for the formula.

Randy

 

[Marco Kalter]

How did this in 6.0.4? Did you get the formula results or the formula text?

 

[Buckeye]

In the SQL results grid it shows everything between the :

6.0.4.906 put the same in Excel. The cell has "text" format. For the formula to evaluate in Excel, I have to change the Excel format to "general".

6.0.5.942 just puts in Excel.

 

[Marco Kalter]

Okay, can you give this version a try? This should behave like version 6.0.4. Let me know how this turns out.

 

[Buckeye]

It (6.0.5.943) is working great! Thanks.