Export excel showing mediafilesize
#1
Can someone tell me what I'm doing wrong? I'm trying to export an excel sheet of all my movies showing the filesize of the movie.

<?xml version="1.0" encoding="UTF-8"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urnConfusedchemas-microsoft-com:officeConfusedpreadsheet"
 xmlns:o="urnConfusedchemas-microsoft-com:office:office"
 xmlns:x="urnConfusedchemas-microsoft-com:office:excel"
 xmlnsConfuseds="urnConfusedchemas-microsoft-com:officeConfusedpreadsheet"
 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" ssBig GrinefaultColumnWidth="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"/>

${foreach movies movie}
   <Row>
    <Cell><Data ss:Type="String">${movie.title}</Data></Cell>
    <Cell><Data ss:Type="Number">${movie.year}</Data></Cell>
    <Cell><Data ss:Type="DateTime">${movie.dateAdded;date(yyyy-MM-dd)}T00:00:00.000</Data></Cell>
    <Cell><Data ss:Type="String">${movie.path}</Data></Cell>
    <Cell><Data ss:Type="Long">${mediafile.filesizeInMegabytes}</Data></Cell>
    <Cell><Data ss:Type="String">${mediafile.filesize}</Data></Cell>
   </Row>
${end}

  </Table>
 </Worksheet>
</Workbook>
#2
I'd like to figure this out myself. I was looking at jhoyos post since they did an awesome job with the movie excel export: https://forum.kodi.tv/showthread.php?tid=344486
I've been looking to see if someone already figured out making a working excel/CSV export for TV Shows because that is a large project for a newb like myself. There are good options already for movies at least.

I found this: https://forum.kodi.tv/showthread.php?tid...+Excel+CSV
For exporting the info from the NFOs

Logout Mark Read Team Forum Stats Members Help
Export excel showing mediafilesize1