Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 kishore chemirthi (kishoreRaju) virtusa polaris
virtusa polaris
IN
kishoreRaju Member since 2017 7 posts
virtusa polaris
Posted: Jul 27, 2017
Last activity: Jul 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***

To see attachments, please log in.
Reporting

Posted: 7 years ago
Posted: 27 Jul 2017 9:36 EDT
Ashok Kumaresan (uashok93) Areteans Tech Associate Architect
Areteans Tech
AU

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.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice