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.

Question

 Bhargav Putumbaka (BhargavP2852)
Putumbaka
Bhargav
Putumbaka
US
BhargavP2852 Member since 2016 39 posts
Putumbaka
Posted: May 4, 2020
Last activity: May 6, 2020
Posted: 4 May 2020 10:25 EDT
Last activity: 6 May 2020 7:12 EDT
Closed

Excel file generated from Send email with attachment Activity

Hello,

 

I have created an activity which sends email with an excel file attachment. Data is perfectly populated as expected.

But whole first row and first column left as blank as shown below. 

How to remove the blank spaces and start excel from row 1 and column 1?

 

I have used repeating grid layout and source as Report definition 

Excel

To see attachments, please log in.
Pega Platform 7.2.1
Reporting
User Experience

Posted: 4 years ago
Posted: 6 May 2020 7:12 EDT
Priyanka Boga (Priyanka Boga)
PEGA
Principal Engineer, Technical Support , User and Product Experience
Pegasystems Inc.
IN

Hi Bhargav,

Can you try the steps included in the below link.Using MSOGenerateExcelFile to generate excel file.

https://krishnapega.blogspot.com/2016/05/how-to-generate-excel-and-send-mail.html?m=1

To see attachments, please log in.

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