Question
2
Replies
112
Views
Scotiabank
MX
Posted: August 11, 2022
Last activity: August 12, 2022
Last activity: 12 Aug 2022 15:56 EDT
Export .csv to .xlsx with formats
How could I convert a .csv file to .Xlsx, with the excel connector maintaining column formats. I can already convert it with the SaveAsName property, however it changes the original column formats, how can you give it those formats?
***Edited by Moderator Marissa to change type from Pega Academy to Product; update capability tags***
Posted: 7 months ago
IQZ Systems
US
@FredyArango One of the option could be read the csv , create the page list from the data & then create excel based on the excel template ( which have your formats defined) with the page list clipboard data
Please be mindful of the number of records you are handling if you are choosing this approach.
Posted: 7 months ago
Scotiabank
MX
Thank you, to do what you mention, can you do it through the excel connector? or by script?; I would like to do it with the excel connector