Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Discussion

 Sumeet Gangaprasad Mandhana (sumeetgm)
init AG
Sumeet Gangaprasad Mandhana
init AG
DE
sumeetgm Member since 2011 3 posts
init AG
Posted: May 21, 2015
Last activity: Dec 28, 2015
Posted: 21 May 2015 3:13 EDT
Last activity: 28 Dec 2015 6:01 EST
Closed

Unable to Edit in Excel for List View in Pega 7

I have a data table and when I open the records in the data table using the developer portal in Pega 6.3 SP1, I see an "Edit in Excel" button and when I click on it and Excel opens and I can add,update or delete records in the same. I am upgrading the application to Pega 7.1.7 but in this case when I open the records in the data table and click on "Edit In Excel" button then nothing happens. When I am trying to debug then I am getting the below error  "Line: 1
Error: Object doesn't support this property or method". Please reply.

To see attachments, please log in.
Reporting

Posted: 9 years ago
Posted: 21 May 2015 10:46 EDT
Emilio Gaudette (gaude)
PEGA
Fellow, Software Engineer, Internal Development Experience
Pegasystems Inc.
US

Are you on IE11 or IE10?  If so you may be running accross a known issue that was fixed in subsequent MLs.  One way to check is to open developer tools (F12) and check the document mode of the page.  It should be using IE9 emulation.  If it is not, then you are likely running accross the known issue.


Regards

Emilio

To see attachments, please log in.
Posted: 9 years ago
Posted: 21 May 2015 10:52 EDT
Emilio Gaudette (gaude)
PEGA
Fellow, Software Engineer, Internal Development Experience
Pegasystems Inc.
US

In witch case, try running IE in compatibility mode for the site.

 

Regards

Emilio

To see attachments, please log in.
Posted: 9 years ago
Posted: 22 May 2015 5:18 EDT
Sumeet Gangaprasad Mandhana (sumeetgm)
init AG
Sumeet Gangaprasad Mandhana
init AG
DE
Hi , When I try running in compatibility view enabled then Pega 7 does not work properly in Internet Explorer. I tried using the developer tools using F12 but was not able to find the resolution.
To see attachments, please log in.
Posted: 9 years ago
Posted: 22 May 2015 7:38 EDT
Emilio Gaudette (gaude)
PEGA
Fellow, Software Engineer, Internal Development Experience
Pegasystems Inc.
US

Do you happen to have an older version of IE you can try it on?  Just to confirm it is an issue with this feature in the IE 10/11 browsers?

 

Regards

Emilio

To see attachments, please log in.
Posted: 9 years ago
Posted: 14 Oct 2015 11:54 EDT
Duttprasad Jagdish Patel (DUTTPRASAD)
Cognizant
US

this is working fo me, start >> All Program >> Internet explorer >> right click" run with adminstrator" >> login to Pega 7>> data table >> edit Excel .. enjoy...

To see attachments, please log in.
Posted: 9 years ago
Posted: 28 Dec 2015 6:01 EST
Piotr Ostrowski (PiotrO03)
Billennium S.A.
Pega Development
Billennium S.A.
PL

Thank you very much DUTTPRASAD for a solution, that worked also in our case.

For one of the projects, my team have encountered similar issues between PEGA application view and Excel program (2010 version in our case) and when we are clicking on the "Edit in Excel" button, we are presented with an opened blank excell document with no white background, but the grayed out.

It turns out, that in fact by enabling the IE in Administrator mode allowed the Excel program to open requested data properly now. Still curiously we have one window opened with grayed out background as PEGA application is still trying to run this integration with normal user which must have insufficient privileges.

Hope that this solution will also work for any future cases of you all.

To see attachments, please log in.

Related content:

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice