Kodi Community Forum

Full Version: Export excel showing mediafilesize
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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>
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