Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Import XML from Excel

Contributor ,
Jun 10, 2020 Jun 10, 2020

Hi all, 

 

I have an Excel sheet with 2500 rows and 4 columns.

I want to import each row as a paragraph in the Primary Text Frame.

 

The columns are : reference, name, date, description.

I have made a xsd file like this:

<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <xsd:element name="Root">
    <xsd:complexType>
      <xsd:sequence>
        <xsd:element minOccurs="0" maxOccurs="unbounded" name="Article">
          <xsd:complexType>
            <xsd:sequence>
              <xsd:element name="reference" type="xsd:string"/>
              <xsd:element name="name" type="xsd:string"/>
              <xsd:element name="date" type="xsd:string" />
              <xsd:element name="description" type="xsd:string" />
            </xsd:sequence>
          </xsd:complexType>
        </xsd:element>
      </xsd:sequence>
    </xsd:complexType>
  </xsd:element>
</xsd:schema>

Then linked each Excel column to the mapping file and exported to XML data.

 

In IndDesign, when I import the XML file, only the first occurence is placed on the page.

 

What am I missing?

TOPICS
Import and export
208
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
no replies

Have something to add?

Join the conversation