I am using "fn!readexcelspreadsheettocdt(ri!doc,1,ri!CDTArray)" expres

anilkumark over 9 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

Discussion posts and replies are publicly visible

Parents

0 anilkumark over 9 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 9 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