Question

1
Replies
372
Views
 kishore chemirthi (kishoreRaju)
virtusa polaris

virtusa polaris
IN
kishoreRaju Member since 2017 7 posts
virtusa polaris
Posted: July 27, 2017
Last activity: July 27, 2017
Posted: 27 Jul 2017 5:51 EDT
Last activity: 27 Jul 2017 11:10 EDT
Closed

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***

Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 4 years ago
Posted: 27 Jul 2017 9:36 EDT
Ashok Kumaresan (ashokk09)
Areteans Tech

Areteans Tech
IN

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.