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
10 replies
Subscribers
8 subscribers
Views
3010 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
I am using "fn!readexcelspreadsheettocdt(ri!doc,1,ri!CDTArray)" expres
anilkumark
over 8 years ago
I am using "fn!readexcelspreadsheettocdt(ri!doc,1,ri!CDTArray)" expression in interface, but data is not fetching from spreadsheet.
doc: Document (Type)
CDTArray: TestTemplate (CDT)
XSD:
<xsd:schema
targetNamespace="
https://xyz.com/suite/types/"
xmlns:tns="
https://xyz.com/suite/types/"
xmlns:xsd="
www.w3.org/.../XMLSchema">
<xsd:complexType name="TestTemlate">
<xsd:sequence>
<xsd:element name="Name" nillable="true" type="xsd:string"/>
<xsd:element name="Number" nillable="true" type="xsd:int"/>
</xsd:sequence>
</xsd:complexType>
</xsd:schema>
Thanks in advance.
Test_Template.xlsx
OriginalPostID-169111
OriginalPostID-169111
Discussion posts and replies are publicly visible
Parents
0
anilkumark
over 8 years ago
Thanks Tom. Done as per your comments. Spreadsheet data is displaying in the grid. But wrong display, in spreadsheet having two rows and two columns but in the grid displaying only one row(with second row in second column). Please find the attachments.
Thanks.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
anilkumark
over 8 years ago
Thanks Tom. Done as per your comments. Spreadsheet data is displaying in the grid. But wrong display, in spreadsheet having two rows and two columns but in the grid displaying only one row(with second row in second column). Please find the attachments.
Thanks.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data