Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: kvchow on 26 Mar 2015 09:12:51 AM

Title: Not able to open the excel file for scheduled report in 10.1.1
Post by: kvchow on 26 Mar 2015 09:12:51 AM
Hi ,

i am facing some strange issue with the report,i ran the report in HTML and am able to export it to excel,but the same report i scheduledwith the excel format,but i am not able to open the excel

getting error when i am trying to open the xecl...Excel cannot open the file because file foramt or file extension is not valid

I am using excel 2007,cognos:10.1 version

Report is having 188000 records

Thanks,
Title: Re: Not able to open the excel file for scheduled report in 10.1.1
Post by: MFGF on 27 Mar 2015 05:16:01 AM
Quote from: kvchow on 26 Mar 2015 09:12:51 AM
Hi ,

i am facing some strange issue with the report,i ran the report in HTML and am able to export it to excel,but the same report i scheduledwith the excel format,but i am not able to open the excel

getting error when i am trying to open the xecl...Excel cannot open the file because file foramt or file extension is not valid

I am using excel 2007,cognos:10.1 version

Report is having 188000 records

Thanks,

What file extension does the saved output have? Do you get the error if you open Excel and use the "Import external data from text" option?

MF.
Title: Re: Not able to open the excel file for scheduled report in 10.1.1
Post by: kvchow on 27 Mar 2015 06:49:47 AM
Hi MFGF

Thanks for your reply

The file extension for saved output s".xlsx",i am not able to open that..
Title: Re: Not able to open the excel file for scheduled report in 10.1.1
Post by: MFGF on 27 Mar 2015 07:09:50 AM
Quote from: kvchow on 27 Mar 2015 06:49:47 AM
Hi MFGF

Thanks for your reply

The file extension for saved output s".xlsx",i am not able to open that..

Do you get the error if you open Excel and use the "Import external data from text" option?

MF.
Title: Re: Not able to open the excel file for scheduled report in 10.1.1
Post by: kvchow on 27 Mar 2015 08:36:28 AM
Hi MFGF,

I am getting the error when i am trying to open the Excel...

Thanks,
Title: Re: Not able to open the excel file for scheduled report in 10.1.1
Post by: MFGF on 27 Mar 2015 09:07:15 AM
Quote from: kvchow on 27 Mar 2015 08:36:28 AM
Hi MFGF,

I am getting the error when i am trying to open the Excel...

Thanks,

I think we are misunderstanding each other. What happens if you launch Excel from the Start Menu, then use Excel's "Import external data from text" option and point it at the xlsx file produced by Cognos - does it import?

MF.
Title: Re: Not able to open the excel file for scheduled report in 10.1.1
Post by: kvchow on 27 Mar 2015 09:30:45 AM
Hi MFGF,

I am not able to import....But the size is showing 0 KB..I am wondering
Title: Re: Not able to open the excel file for scheduled report in 10.1.1
Post by: MFGF on 27 Mar 2015 09:32:44 AM
Quote from: kvchow on 27 Mar 2015 09:30:45 AM
Hi MFGF,

I am not able to import....But the size is showing 0 KB..I am wondering

Hmmm. That definitely doesn't sound right. Is it possible a virus scanner or popup blocker is interfering?

MF.
Text only | Text with Images