How can I get data from an Excel spread sheet?
Article # 3039615 - Page views: 40
Issue
How can I get data from an Excel spread sheet?
Solution
One suggestion is to do the following:
- Import the Excel spreadsheet.
- Convert to Tif.
- Use Extraction to create a table.
- Use the GetDocumentFieldProperties API to walk the rows in the table to get the data.
- Another possibility is to use the API and place it in a Dynamic Complex variable.
Level of Complexity
Moderate
Applies to
| Product | Version | Build | Environment | Hardware |
|---|---|---|---|---|
| KTA | All |
References
Add any references to other internal or external articles
Article # 3039615