Question
Schwab
IN
Last activity: 16 Oct 2018 12:03 EDT
Showing numeric values in excel which is exported using MSOGenerateExcelFile activity
Hi,
We are using MSOGenerateExcelFile activity to export page list content to excel. As mentioned in below support article numeric values are exported as text.
Is there any work around to achive this. We want to export a field which will have values like 50,000$
***Moderator Edit: Vidyaranjan | Updated Categories***
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Accepted Solution
Schwab
IN
Thanks for solution.
We were able to achieve desired functionality using excel macro. We have uploaded macro enabled excel to binary file.
Pegasystems Inc.
IN
Hi There,
The most likely solution is to rewrite the MSOGenerateExcelFile activity to try to get Excel to format the values as numbers. Just try below.
1) Create a new function called getScalarPropertyType to inspect the data type of the property being exported. If the datatype is integer it returns true, otherwise false.
2) Create a copy of the DCOXLGenerateZipEntryMap function, called XLGenerateZipEntryMap. There are two main areas within the function where the above check needs to be inserted
2.1 When the numeric property is used by itself: Row 134 to 164 of DCOXLGenerateZipEntryMap. The new logic commences at line 112 to 155 in the new XLGenerateZipEntryMap function.
2.2 When the numeric property appears within an array (pagelist) property: Row 194 to 276 of DCOXLGenerateZipEntryMap. The new logic commences at line 180 to 225 in the new XLGenerateZipEntryMap function.
3) Create a copy of the @baseclass.MSOGenerateExcelFile activity. Reference the new function, XLGenerateZipEntryMap, instead of the DCOXLGenerateZipEntryMap in step 4's Java logic.
~Naresh
Pegasystems Inc.
PL
Hi,
Could you please send an exemplary file with the macro, that you uploaded?
I'm just trying to upload a XLS file with marco (*.XLSM), but Pega does not allow *.XLSM files to be uploaded, we must have *.XLSX