Hello Arunava,
The simplest approach that I feel which will accomplish your goal is to use the pdm_text_cmd.
Please see the following tech doc links that describe the functionality of interest:
https://support.ca.com/us/knowledge-base-articles.TEC476956.html
https://support.ca.com/us/knowledge-base-articles.TEC425521.html
The basic principle that I could imagine would work here, which may be translated into a custom script:
- Obtain a row of data from your spreadsheet
- Format a flat file that contains the content from that row, and has been formatted for reading by pdm_text_cmd
- Run pdm_text_cmd against the given flat file.
- Delete the flat file
Repeat until all rows are expended.