Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Two Index's on the same row

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:

enter image description here

And this is what I'm trying to achieve if possible without putting both loops in the same row:

enter image description here

like image 393
DollarChills Avatar asked Oct 17 '22 02:10

DollarChills


1 Answers

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>
like image 77
Tomasz Giba Avatar answered Oct 21 '22 07:10

Tomasz Giba