Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
18 replies
Subscribers
6 subscribers
Views
10742 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
Inside the Read Excel Spreadsheet Utilities plug-in, there is a smart service (a
Richard
over 8 years ago
Inside the Read Excel Spreadsheet Utilities plug-in, there is a smart service (and an expression) that imply some control over the header list. Specifically the Parse Excel Spreadsheet to CDT with Header List Smart Service.
The documentation is not clear on how this works. I have a CDT that contains a definition for some data I care about and a spreadsheet that contains the data I want to put into that CDT. The data is, unfortunately contained in columns that are interspersed with other columns that I don't care about.
Is there a good way to use the Header List parameter to pull the data I want?
Do I need to manually manipulate the spreadsheet to conform to the plugin?
Is there a better way?
OriginalPostID-215679
OriginalPostID-215679
Discussion posts and replies are publicly visible
Parents
0
ankitab918
over 8 years ago
Hi, i read the above comments and accordingly, i have kept the header list of the excel document and the cdt exactly same. Also, the header list in the input parameters of the smart service matches with that of the cdt and the excel header row. Even then, the document is not getting parsed. Is there something else to configure?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
ankitab918
over 8 years ago
Hi, i read the above comments and accordingly, i have kept the header list of the excel document and the cdt exactly same. Also, the header list in the input parameters of the smart service matches with that of the cdt and the excel header row. Even then, the document is not getting parsed. Is there something else to configure?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data