Pega Robotics - Excel Queries
Please let me know how to do the following:
1) Select a range in the excel (for example column A)
2) Select Format Cells for the above range
3) Select Category as Date, and the type as 3/14/01
***Updated by moderator: Lochan to create new post from reply***
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Accepted Solution
Pegasystems Inc.
US
I don't believe you can select a range with the Excel connector but you can use the set and get cell methods to cycle through the cells you want to work with piecemeal.
Mphasis
IN
An update on the above query, I am able to set the format as Date by using the NumberFormat property available in the Range object.
However I am still not clear on how to select the range ( I do not want to use the UsedRange, I want to select a range of my choice)
Please help
Accepted Solution
Pegasystems Inc.
US
I don't believe you can select a range with the Excel connector but you can use the set and get cell methods to cycle through the cells you want to work with piecemeal.
Cognizant Technology Solutions India PVT Ltd
IN
Hi,
you can go for import data and export data,
For Example
This automation shows how to use the MicrosoftExcel connector to run a macro in an Excel spreadsheet and then return the data from the spreadsheet to a Windows form.
