Question
1
Replies
352
Views
virtusa polaris
Posted: July 27, 2017
Last activity: July 27, 2017
How to read Excel then Delete first 2 Rows then save it as .csv file.
Hi All,
could someone help me on reading excel then need to remove first 2 rows from excel then i need to save it as .csv file.
the above process need to be happen in sheet wise.
currently i am able to open the excel and save the excel as .csv, but i am not able to delete first 2 rows.
Thanks in Advance!
Regards,
Kishore
***Edited by Moderator Marissa to update categories***
Posted: 3 years ago
if we are importing the values from excel to pega , then the values are stored in a pagelist. you can run an activity to remove the top 2 pages by using page-remove method
ImportPage.pxResults(1)
ImportPage.pxResults(2)
and then again generate excel using MSOGenerateExcel activity.