Skip to content

Instantly share code, notes, and snippets.

@jbelke

jbelke/gist:a4b36a5bc7eb16f58f6f29b5192f2245

Created June 17, 2021 18:11
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jbelke/a4b36a5bc7eb16f58f6f29b5192f2245 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jbelke/a4b36a5bc7eb16f58f6f29b5192f2245 to your computer and use it in GitHub Desktop.
Download ZIP
test-order
Raw
gistfile1.txt
<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook
xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:html="http://www.w3.org/TR/REC-html40"
xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet">
<OfficeDocumentSettings
xmlns="urn:schemas-microsoft-com:office:office">
</OfficeDocumentSettings>
<ExcelWorkbook
xmlns="urn:schemas-microsoft-com:office:excel">
</ExcelWorkbook>
<Worksheet ss:Name="orders.xml">
<Table>
<Row>
<Cell>
<Data ss:Type="String">Order #</Data>
</Cell>
<Cell>
<Data ss:Type="String">Purchased On</Data>
</Cell>
<Cell>
<Data ss:Type="String">Bill to Name</Data>
</Cell>
<Cell>
<Data ss:Type="String">Ship to Name</Data>
</Cell>
<Cell>
<Data ss:Type="String">G.T. (Base)</Data>
</Cell>
<Cell>
<Data ss:Type="String">G.T. (Purchased)</Data>
</Cell>
<Cell>
<Data ss:Type="String">Status</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="String">ORD100170</Data>
</Cell>
<Cell>
<Data ss:Type="String">Apr 29, 2020 9:12:54 PM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">Different ShipTo</Data>
</Cell>
<Cell>
<Data ss:Type="String">$1,513.98</Data>
</Cell>
<Cell>
<Data ss:Type="String">$1,513.98</Data>
</Cell>
<Cell>
<Data ss:Type="String">Pending</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="String">ORD100160</Data>
</Cell>
<Cell>
<Data ss:Type="String">Oct 11, 2019 5:27:33 PM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">Different ShipTo</Data>
</Cell>
<Cell>
<Data ss:Type="String">$5,126.95</Data>
</Cell>
<Cell>
<Data ss:Type="String">$5,126.95</Data>
</Cell>
<Cell>
<Data ss:Type="String">Pending</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="String">ORD100140</Data>
</Cell>
<Cell>
<Data ss:Type="String">Nov 29, 2018 2:33:15 PM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">Different ShipTo</Data>
</Cell>
<Cell>
<Data ss:Type="String">$5,126.95</Data>
</Cell>
<Cell>
<Data ss:Type="String">$5,126.95</Data>
</Cell>
<Cell>
<Data ss:Type="String">Pending</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="String">ORD100130</Data>
</Cell>
<Cell>
<Data ss:Type="String">Nov 29, 2018 2:32:44 PM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">Different ShipTo</Data>
</Cell>
<Cell>
<Data ss:Type="String">$1,513.98</Data>
</Cell>
<Cell>
<Data ss:Type="String">$1,513.98</Data>
</Cell>
<Cell>
<Data ss:Type="String">Pending</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="String">ORD100120</Data>
</Cell>
<Cell>
<Data ss:Type="String">Feb 27, 2018 9:01:21 PM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">Different ShipTo</Data>
</Cell>
<Cell>
<Data ss:Type="String">$808.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">$808.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">Pending</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="String">ORD100110</Data>
</Cell>
<Cell>
<Data ss:Type="String">Feb 27, 2018 9:01:08 PM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">Different ShipTo</Data>
</Cell>
<Cell>
<Data ss:Type="String">$1,016.97</Data>
</Cell>
<Cell>
<Data ss:Type="String">$1,016.97</Data>
</Cell>
<Cell>
<Data ss:Type="String">Pending</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="String">ORD100100</Data>
</Cell>
<Cell>
<Data ss:Type="String">Feb 27, 2018 9:00:54 PM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">Different ShipTo</Data>
</Cell>
<Cell>
<Data ss:Type="String">$5,126.95</Data>
</Cell>
<Cell>
<Data ss:Type="String">$5,126.95</Data>
</Cell>
<Cell>
<Data ss:Type="String">Pending</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="String">ORD100090</Data>
</Cell>
<Cell>
<Data ss:Type="String">Sep 19, 2017 4:36:46 PM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">Different ShipTo</Data>
</Cell>
<Cell>
<Data ss:Type="String">$3,071.96</Data>
</Cell>
<Cell>
<Data ss:Type="String">$3,071.96</Data>
</Cell>
<Cell>
<Data ss:Type="String">Pending</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="String">ORD100080</Data>
</Cell>
<Cell>
<Data ss:Type="String">Sep 19, 2017 4:36:22 PM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">Different ShipTo</Data>
</Cell>
<Cell>
<Data ss:Type="String">$3,071.96</Data>
</Cell>
<Cell>
<Data ss:Type="String">$3,071.96</Data>
</Cell>
<Cell>
<Data ss:Type="String">Pending</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="String">ORD100070</Data>
</Cell>
<Cell>
<Data ss:Type="String">Sep 19, 2017 4:36:06 PM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">Different ShipTo</Data>
</Cell>
<Cell>
<Data ss:Type="String">$2,967.97</Data>
</Cell>
<Cell>
<Data ss:Type="String">$2,967.97</Data>
</Cell>
<Cell>
<Data ss:Type="String">Pending</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="String">ORD100060</Data>
</Cell>
<Cell>
<Data ss:Type="String">May 17, 2015 9:20:50 PM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">Different ShipTo</Data>
</Cell>
<Cell>
<Data ss:Type="String">$2,967.97</Data>
</Cell>
<Cell>
<Data ss:Type="String">$2,967.97</Data>
</Cell>
<Cell>
<Data ss:Type="String">Pending</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="String">ORD100050</Data>
</Cell>
<Cell>
<Data ss:Type="String">May 17, 2015 9:20:26 PM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">Different ShipTo</Data>
</Cell>
<Cell>
<Data ss:Type="String">$1,112.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">$1,112.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">Pending</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="String">ORD100040</Data>
</Cell>
<Cell>
<Data ss:Type="String">May 17, 2015 9:20:20 PM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">Different ShipTo</Data>
</Cell>
<Cell>
<Data ss:Type="String">$1,112.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">$1,112.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">Pending</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="String">ORD100030</Data>
</Cell>
<Cell>
<Data ss:Type="String">Apr 7, 2014 11:44:20 AM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">Different ShipTo</Data>
</Cell>
<Cell>
<Data ss:Type="String">$1,112.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">$1,112.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">Pending</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="String">ORD100020</Data>
</Cell>
<Cell>
<Data ss:Type="String">Apr 7, 2014 11:32:19 AM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">Different ShipTo</Data>
</Cell>
<Cell>
<Data ss:Type="String">$1,112.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">$1,112.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">Processing</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="String">ORD100010</Data>
</Cell>
<Cell>
<Data ss:Type="String">Apr 7, 2014 11:32:08 AM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">Different ShipTo</Data>
</Cell>
<Cell>
<Data ss:Type="String">$1,112.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">$1,112.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">Pending</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="String">ORD100000</Data>
</Cell>
<Cell>
<Data ss:Type="String">Apr 7, 2014 11:31:56 AM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">Different ShipTo</Data>
</Cell>
<Cell>
<Data ss:Type="String">$1,112.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">$1,112.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">Complete</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="Number">100000007</Data>
</Cell>
<Cell>
<Data ss:Type="String">Dec 11, 2013 3:53:26 PM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">Different ShipTo</Data>
</Cell>
<Cell>
<Data ss:Type="String">$1,112.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">$1,112.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">Pending</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="Number">100000006</Data>
</Cell>
<Cell>
<Data ss:Type="String">Jun 22, 2013 10:40:24 AM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">Different ShipTo</Data>
</Cell>
<Cell>
<Data ss:Type="String">$1,112.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">$1,112.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">Processing</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="Number">100000005</Data>
</Cell>
<Cell>
<Data ss:Type="String">Dec 23, 2012 7:46:29 PM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">$704.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">$704.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">Closed</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="Number">100000004</Data>
</Cell>
<Cell>
<Data ss:Type="String">Dec 23, 2012 7:46:20 PM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">$704.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">$704.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">Pending</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="Number">100000003</Data>
</Cell>
<Cell>
<Data ss:Type="String">Aug 30, 2011 1:01:37 PM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">$704.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">$704.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">Processing</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="Number">100000002</Data>
</Cell>
<Cell>
<Data ss:Type="String">Aug 30, 2011 1:01:15 PM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">Peter Huth</Data>
</Cell>
<Cell>
<Data ss:Type="String">$103.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">$103.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">Processing</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="Number">100000001</Data>
</Cell>
<Cell>
<Data ss:Type="String">Aug 30, 2011 12:59:44 PM</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">John Doe</Data>
</Cell>
<Cell>
<Data ss:Type="String">$704.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">$704.99</Data>
</Cell>
<Cell>
<Data ss:Type="String">Processing</Data>
</Cell>
</Row>
</Table>
</Worksheet>
</Workbook>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment