[loungebob]

oh duh. I thought the default value at the beginning of the table in the export file (ssefaultColumnWidth="60") catches this and assumes that value for all non-defined variables.

anyhow, this works:

xml:


<Worksheet ss:Name="movielist">

  <Table x:FullColumns="1" x:FullRows="1" ssefaultColumnWidth="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="100.00"/>

   <Column ss:Width="100.00"/>

   <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="Number">${movie.ratings.imdb.rating}</Data></Cell>

    <Cell><Data ss:Type="Number">${movie.ratings.imdb.votes}</Data></Cell>

    <Cell><Data ss:Type="String">${movie.path}</Data></Cell>

   </Row>

${end}

and yay! :-)

now that this works, is there a way I can get metacritic values and rottentomatos values too? thanks so far!