Inside the Read Excel Spreadsheet Utilities plug-in, there is a smart service (a

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
  • @richard.nolan Hi, have you had a chance to take a look at the following point in the documentation of the Plugin?

    *To use: Create a spreadsheet and make the first row a reader row whose names correspond exactly to field names in your CDT (capitalization sensitive.) Header names that don't match CDT fields will be ignored.

    I believe that the above mentioned point is the key constraint that I have observed in the implementation of it. Not sure if that answers your question and if not, I would suggest adding some more information re CDT structure and the Excel Template(with headers) and that leaves space for the community to come up with pointers.

    Just in case, if you would like to overcome the header names limitation,you may opt for using Macro method as discussed at https://forum.appian.com/suite/tempo/entry/e-194503 and separate technical and end-user facing content.
Reply
  • @richard.nolan Hi, have you had a chance to take a look at the following point in the documentation of the Plugin?

    *To use: Create a spreadsheet and make the first row a reader row whose names correspond exactly to field names in your CDT (capitalization sensitive.) Header names that don't match CDT fields will be ignored.

    I believe that the above mentioned point is the key constraint that I have observed in the implementation of it. Not sure if that answers your question and if not, I would suggest adding some more information re CDT structure and the Excel Template(with headers) and that leaves space for the community to come up with pointers.

    Just in case, if you would like to overcome the header names limitation,you may opt for using Macro method as discussed at https://forum.appian.com/suite/tempo/entry/e-194503 and separate technical and end-user facing content.
Children
No Data