Data Type is converting to text when exporting pagelist results to Excel.
Hi,
i have a requirement to export a PageList results into an Excel sheet. I have achieved this using "MSOGenerateExcelFile" activity. But, the problem is all the values are being converted to text format. I want their data type to be same without being converted to text. Is their any work around to achieve this scenario.
please help me with this.
Thanks,
Bhargav
**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
Pegasystems Inc.
US
Hi Bhargav,
You can have a look into this use case where you can specify your CSV Property types in pxConvertResultsToCSV activity as explained in attachment.
Hope it might help you.
Regards
Mahesh
Evoke Technologies
IN
Hi Mahesh,
It is working as expected. It was really helpful :)
Thanks,
Bhargav
Incessant Technologies
IN
Hi Bhargav,
what are the parameters u have given to the activity MSOGenerateExcelFile. Please let me know.
Thanks,
sravani