Question
Farmers Insurance group federal credit union
Farmers Insurance group federal credit union
US
Posted: May 7, 2025
Last activity: 3 weeks 4 days ago
Last activity: 12 May 2025 21:39 EDT
How to change the entire column format in excel - Pega RPA
Hi,
I need to change the date format in Excel from DateTime to Date. Is there a way to change the entire column instead of looping through each row? I tried Setcellformat but it only works for one cell and if I set it to "A:A" gives an invalid address error.
Thank you
***Edited by Moderator Marije to add Capability tags***
Posted: 3 weeks ago
MOD
Pegasystems Inc.
US
@Rupam9024Here is a way to do this using the ExcelConnector. If you are using the MicrosoftExcelConnector, then it appears you'll need a script. Which connector are you using?
