Parse Excel To CDT - Need a guide on how to use the plugin and it's functions

Hi Anusha ,

As "Parse Excel to CDT" parses the data for which the CDT fields are matched with the column name in the excel.

( forum.appian.com/.../summary )


Thanks

That link takes to place where we can download its files, but they don't clearly mention how to use particular smart service with syntax or example

There are three things that I would like to point out that I have discovered while using the Parse Excel to CDT smart service :

1. Where it says row number to read from in data tab inputs, the row should be the first row with data that actually matches the CDT
fields, not the one with the titles of the CDT fields .
2. With any dates or numbers that may have been calculated using a formula, it will not parse this information, so you need to make
sure that it has an actual number or date not a formula as its value .
3. I'm not sure how well the errorOccurred variable is working, because it wasn't able to see any of the issues I mentioned above .

Thanks

There are three things that I would like to point out that I have discovered while using the Parse Excel to CDT smart service :

1. Where it says row number to read from in data tab inputs, the row should be the first row with data that actually matches the CDT
fields, not the one with the titles of the CDT fields .
2. With any dates or numbers that may have been calculated using a formula, it will not parse this information, so you need to make
sure that it has an actual number or date not a formula as its value .
3. I'm not sure how well the errorOccurred variable is working, because it wasn't able to see any of the issues I mentioned above .

Thanks