I have a rails application that exports content from my database in an xls format.
I'm looking to create two separate tables without putting them in the same row. Is there anyway to have two index's on the same row?
<?xml version="1.0"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<ss:Worksheet ss:Name="Sheet">
<Table>
<% @data.each do |data| %>
<Row ss:Index="1">
<Cell ss:Index="1"><Data ss:Type="String"><%= data.name %></Data></Cell>
</Row>
<% end %>
<% @moreData.each do |moreData| %>
<Row ss:Index="1">
<Cell ss:Index="2"><Data ss:Type="String"><%= moreData.name %></Data></Cell>
</Row>
<% end %>
</Table>
</ss:Worksheet>
</Workbook>
This is what I have with the above code:
And this is what I'm trying to achieve if possible without putting both loops in the same row:
Maybe use .zip
on the data?
ex.
<Row ss:Index="1">
<% @data.zip(@moreData).each do |d, md| %>
<Cell ss:Index="1"><Data ss:Type="String"><%= d.name %></Data></Cell>
<Cell ss:Index="2"><Data ss:Type="String"><%= md.name %></Data></Cell>
<% end %>
</Row>
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With