LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Convert tabular xml - Excel Sheet type

    Employee
    Posted 06-14-2013 04:51

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Wizardous

    Hi,

    I am trying to setup a tabular xml node but couldn't succeed on parameters I think. It is an excel sheet type xml. I thought that you may have tried before this type of convertion. What should the parameters be? Thank you. Here below you can find an example of the xml file.

    Kind Regards,

    �zg�n

    <?xml version="1.0" encoding="UTF-8"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook
  xmlns="urn:schemas-microsoft-com:office:spreadsheet"
  xmlns:o="urn:schemas-microsoft-com:office:office"
  xmlns:x="urn:schemas-microsoft-com:office:excel"
  xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
  xmlns:html="http://www.w3.org/TR/REC-html40"
  xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml"
  xmlns:udc="http://schemas.microsoft.com/data/udc"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema"
  xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile">
  <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  </DocumentProperties>
  <Worksheet ss:Name="Sheet1">
    <Table>
      <Column ss:Width="200"/>
      <Column ss:Width="200"/>
      <Column ss:Width="200"/>
      <Row ss:AutoFitHeight="0">
        <Cell>
          <Data ss:Type="String">SRCSEQ</Data>
          <NamedCell ss:Name="_FilterDatabase"/>
        </Cell>
        <Cell>
          <Data ss:Type="String">SRCDAT</Data>
          <NamedCell ss:Name="_FilterDatabase"/>
        </Cell>
        <Cell>
          <Data ss:Type="String">SRCDTA</Data>
          <NamedCell ss:Name="_FilterDatabase"/>
        </Cell>
      </Row>
      <Row ss:AutoFitHeight="0">
        <Cell>
          <Data ss:Type="Number">1.00</Data>
          <NamedCell ss:Name="_FilterDatabase"/>
        </Cell>
        <Cell>
          <Data ss:Type="Number">12</Data>
          <NamedCell ss:Name="_FilterDatabase"/>
        </Cell>
        <Cell>
          <Data ss:Type="String">Constructs a new String by decoding the specified array</Data>
          <NamedCell ss:Name="_FilterDatabase"/>
        </Cell>
      </Row>
         ......
        </Table>
    </Worksheet>


  • 2.  RE: Convert tabular xml - Excel Sheet type

    Employee
    Posted 06-26-2013 06:40

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Tim Meagher

    Hi,


    Perhaps someone else can comment about trying this using the Tabular XML nodes, however I don't think this is possible using those nodes (Convert Tabular XML, Tabular XML File).
    The Tabular XML nodes are designed to read XML which contain essentially a single "record type", which then contains the fields within the record.
    I think the problem here is that in your example, the "Worksheet" could be considered the record, but the fields within the Worksheet aren't scalar - they are composed, and repeating.
    Table is a composed element, which contains repeating Row entries, which in turn contain repeating Cell entries etc.


    If this is just the contents of an Excel file zip, is there any reason why you can't use the original Excel file (without exploding the contents out of the zip) and read that directly using the Excel File node?


    I know that this doesn't really help much at the moment, but we are working on implementing a much more powerful, and easier to configure XML node which will be able to handle this sort of data without any problem, and with no configuration required (aside from specifying the name of the file that it is to be read).
    Unfortunately, some changes are required to the LAE itself in order to get this node working, so it can't simply be released as part of a LAL release until sometime after the next (4.6.1) version of the LAE is released.


    I'll post here again once this node becomes available.


    Regards,
    Tim.