now TMM generates an xml output file but Excel doesnt like it:
XML ERROR in Table
REASON: Bad Value
FILE: G:\images\movielist.xml
GROUP: Cell
TAG: Data
ATTRIB: Type
VALUE: int
dont know how to attach files in here so:
<?xml version="1.0" encoding="UTF-8"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn
chemas-microsoft-com:office
preadsheet"
xmlns:o="urn
chemas-microsoft-com:office:office"
xmlns:x="urn
chemas-microsoft-com:office:excel"
xmlns
s="urn
chemas-microsoft-com:office
preadsheet"
xmlns:html="
http://www.w3.org/TR/REC-html40">
<Styles>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Bottom"/>
<Borders/>
<Font/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
<Style ss:ID="s22">
<Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
</Style>
<Style ss:ID="s23">
<Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
<NumberFormat ss:Format="Short Date"/>
</Style>
</Styles>
<Worksheet ss:Name="movielist">
<Table x:FullColumns="1" x:FullRows="1" ss
efaultColumnWidth="60"> <Column ss:Width="200.00"/>
<Column ss:Width="33.00" ss:StyleID="s22" />
<Column ss:Width="70.00" ss:StyleID="s23" />
<Column ss:Width="300.00"/>
<Row>
<Cell><Data ss:Type="String">Absolutely Anything</Data></Cell>
<Cell><Data ss:Type="Number">2015</Data></Cell>
<Cell><Data ss:Type="DateTime">2015-12-02T00:00:00.000</Data></Cell>
<Cell><Data ss:Type="String">6.0</Data></Cell>
<Cell><Data ss:Type="int">30765</Data></Cell>
<Cell><Data ss:Type="String">J:\MOVIES_COMEDY\Absolutely.Anything.2015.BluRay.1080p.x264-RARBG</Data></Cell>
</Row> <Row>
<Cell><Data ss:Type="String">The Disaster Artist</Data></Cell>
<Cell><Data ss:Type="Number">2017</Data></Cell>
<Cell><Data ss:Type="DateTime">2018-02-28T00:00:00.000</Data></Cell>
<Cell><Data ss:Type="String">7.6</Data></Cell>
<Cell><Data ss:Type="int">70843</Data></Cell>
<Cell><Data ss:Type="String">J:\MOVIES_COMEDY\The.Disaster.Artist.2017.BluRay.1080p.x264-RARBG</Data></Cell>
</Row> <Row>
<Cell><Data ss:Type="String">El Camino Christmas</Data></Cell>
<Cell><Data ss:Type="Number">2017</Data></Cell>
<Cell><Data ss:Type="DateTime">2017-12-08T00:00:00.000</Data></Cell>
<Cell><Data ss:Type="String">5.6</Data></Cell>
<Cell><Data ss:Type="int">4541</Data></Cell>
<Cell><Data ss:Type="String">J:\MOVIES_COMEDY\__El.Camino.Christmas.2017.1080p.NF.WEBRip.DD5.1.x264-SB</Data></Cell>
</Row> <Row>
<Cell><Data ss:Type="String">Going in Style</Data></Cell>
<Cell><Data ss:Type="Number">2017</Data></Cell>
<Cell><Data ss:Type="DateTime">2017-07-11T00:00:00.000</Data></Cell>
<Cell><Data ss:Type="String">6.6</Data></Cell>
<Cell><Data ss:Type="int">54641</Data></Cell>
<Cell><Data ss:Type="String">J:\MOVIES_COMEDY\__Going.In.Style.2017.1080p.WEB-DL.DD5.1.H264-FGT</Data></Cell>
</Row> <Row>
<Cell><Data ss:Type="String">Hail, Caesar!</Data></Cell>
<Cell><Data ss:Type="Number">2016</Data></Cell>
<Cell><Data ss:Type="DateTime">2016-05-25T00:00:00.000</Data></Cell>
<Cell><Data ss:Type="String">6.3</Data></Cell>
<Cell><Data ss:Type="int">101248</Data></Cell>
<Cell><Data ss:Type="String">J:\MOVIES_COMEDY\Hail.Caesar.2016.BluRay.1080p.x264-RARBG</Data></Cell>
</Row> <Row>
<Cell><Data ss:Type="String">The House</Data></Cell>
<Cell><Data ss:Type="Number">2017</Data></Cell>
<Cell><Data ss:Type="DateTime">2017-09-26T00:00:00.000</Data></Cell>
<Cell><Data ss:Type="String">5.6</Data></Cell>
<Cell><Data ss:Type="int">23117</Data></Cell>
<Cell><Data ss:Type="String">J:\MOVIES_COMEDY\The.House.2017.BluRay.1080p.x264-RARBG</Data></Cell>
</Row> <Row>
<Cell><Data ss:Type="String">I, Tonya</Data></Cell>
<Cell><Data ss:Type="Number">2017</Data></Cell>
<Cell><Data ss:Type="DateTime">2018-02-28T00:00:00.000</Data></Cell>
<Cell><Data ss:Type="String">7.6</Data></Cell>
<Cell><Data ss:Type="int">78413</Data></Cell>
<Cell><Data ss:Type="String">J:\MOVIES_COMEDY\I.Tonya.2017.BluRay.1080p.x264-RARBG</Data></Cell>
</Row> <Row>
<Cell><Data ss:Type="String">Keanu</Data></Cell>
<Cell><Data ss:Type="Number">2016</Data></Cell>
<Cell><Data ss:Type="DateTime">2016-07-22T00:00:00.000</Data></Cell>
<Cell><Data ss:Type="String">6.3</Data></Cell>
<Cell><Data ss:Type="int">37285</Data></Cell>
<Cell><Data ss:Type="String">J:\MOVIES_COMEDY\Keanu.2016.BluRay.1080p.x264-RARBG</Data></Cell>
</Row> <Row>
<Cell><Data ss:Type="String">Lady Bird</Data></Cell>
<Cell><Data ss:Type="Number">2017</Data></Cell>
<Cell><Data ss:Type="DateTime">2018-02-23T00:00:00.000</Data></Cell>
<Cell><Data ss:Type="String">7.6</Data></Cell>
<Cell><Data ss:Type="int">110013</Data></Cell>
<Cell><Data ss:Type="String">J:\MOVIES_COMEDY\Lady.Bird.2017.BluRay.1080p.x264-RARBG</Data></Cell>
</Row> <Row>
<Cell><Data ss:Type="String">Masterminds</Data></Cell>
<Cell><Data ss:Type="Number">2016</Data></Cell>
<Cell><Data ss:Type="DateTime">2017-01-06T00:00:00.000</Data></Cell>
<Cell><Data ss:Type="String">5.8</Data></Cell>
<Cell><Data ss:Type="int">38838</Data></Cell>
<Cell><Data ss:Type="String">J:\MOVIES_COMEDY\Masterminds.2016.BluRay.1080p.x264-RARBG</Data></Cell>
</Row> <Row>
<Cell><Data ss:Type="String">Mayhem</Data></Cell>
<Cell><Data ss:Type="Number">2017</Data></Cell>
<Cell><Data ss:Type="DateTime">2017-11-10T00:00:00.000</Data></Cell>
<Cell><Data ss:Type="String">6.3</Data></Cell>
<Cell><Data ss:Type="int">8004</Data></Cell>
<Cell><Data ss:Type="String">J:\MOVIES_COMEDY\__Mayhem.2017.1080p.WEB-DL.DD5.1.H264-FGT</Data></Cell>
</Row> <Row>
<Cell><Data ss:Type="String">The Meyerowitz Stories (New and Selected)</Data></Cell>
<Cell><Data ss:Type="Number">2017</Data></Cell>
<Cell><Data ss:Type="DateTime">2017-10-14T00:00:00.000</Data></Cell>
<Cell><Data ss:Type="String">7.0</Data></Cell>
<Cell><Data ss:Type="int">22329</Data></Cell>
<Cell><Data ss:Type="String">J:\MOVIES_COMEDY\__The.Meyerowitz.Stories.New.and.Selected.2017.1080p.WEBRip.x264-STRiFE</Data></Cell>
</Row> <Row>
<Cell><Data ss:Type="String">Mindhorn</Data></Cell>
<Cell><Data ss:Type="Number">2016</Data></Cell>
<Cell><Data ss:Type="DateTime">2017-05-14T00:00:00.000</Data></Cell>
<Cell><Data ss:Type="String">6.3</Data></Cell>
<Cell><Data ss:Type="int">7692</Data></Cell>
<Cell><Data ss:Type="String">J:\MOVIES_COMEDY\__Mindhorn.2017.1080p.WEBRip.DD5.1.x264-FGT</Data></Cell>
</Row> <Row>
<Cell><Data ss:Type="String">Our Brand Is Crisis</Data></Cell>
<Cell><Data ss:Type="Number">2015</Data></Cell>
<Cell><Data ss:Type="DateTime">2016-01-20T00:00:00.000</Data></Cell>
<Cell><Data ss:Type="String">6.1</Data></Cell>
<Cell><Data ss:Type="int">17257</Data></Cell>
<Cell><Data ss:Type="String">J:\MOVIES_COMEDY\Our.Brand.Is.Crisis.2015.BluRay.1080p.x264-RARBG</Data></Cell>
</Row> <Row>
<Cell><Data ss:Type="String">Paddington 2</Data></Cell>
<Cell><Data ss:Type="Number">2017</Data></Cell>
<Cell><Data ss:Type="DateTime">2018-03-08T00:00:00.000</Data></Cell>
<Cell><Data ss:Type="String">8.0</Data></Cell>
<Cell><Data ss:Type="int">24191</Data></Cell>
<Cell><Data ss:Type="String">J:\MOVIES_COMEDY\Paddington.2.2017.BluRay.1080p.x264-RARBG</Data></Cell>
</Row> <Row>
<Cell><Data ss:Type="String">The Party</Data></Cell>
<Cell><Data ss:Type="Number">2017</Data></Cell>
<Cell><Data ss:Type="DateTime">2017-11-30T00:00:00.000</Data></Cell>
<Cell><Data ss:Type="String">6.7</Data></Cell>
<Cell><Data ss:Type="int">8461</Data></Cell>
<Cell><Data ss:Type="String">J:\MOVIES_COMEDY\The.Party.2017.BluRay.1080p.x264-RARBG</Data></Cell>
</Row> <Row>
<Cell><Data ss:Type="String">Pitch Perfect 3</Data></Cell>
<Cell><Data ss:Type="Number">2017</Data></Cell>
<Cell><Data ss:Type="DateTime">2018-03-07T00:00:00.000</Data></Cell>
<Cell><Data ss:Type="String">6.0</Data></Cell>
<Cell><Data ss:Type="int">24254</Data></Cell>
<Cell><Data ss:Type="String">J:\MOVIES_COMEDY\Pitch.Perfect.3.2017.BluRay.1080p.BluRay.x264-RARBG</Data></Cell>
</Row> <Row>
<Cell><Data ss:Type="String">The Square</Data></Cell>
<Cell><Data ss:Type="Number">2017</Data></Cell>
<Cell><Data ss:Type="DateTime">2018-02-23T00:00:00.000</Data></Cell>
<Cell><Data ss:Type="String">7.4</Data></Cell>
<Cell><Data ss:Type="int">28991</Data></Cell>
<Cell><Data ss:Type="String">J:\MOVIES_COMEDY\The.Square.2017.BluRay.1080p.x264-RARBG</Data></Cell>
</Row>
</Table>
</Worksheet>
</Workbook>