Hello i'm trying export an array to make a dynamic Row/Column Excel.
Here my datas:
(Can have more or less header)
// Line 1 of my table
$header = array(
'header_1' => 'Head 1',
'header_2' => 'Head 3',
'header_3' => 'Head 2'
); |
If i have these 3 headers here my values:
// Line 2 of my table
$value[0] = array(
'value_1' => 'Value 1',
'value_2' => 'Value 3',
'value_3' => 'Value 2'
); |
// Line 3 of my table
$value[1] = array(
'value_1' => 'Value 1',
'value_2' => 'Value 3',
'value_3' => 'Value 2'
);
$TBS->MergeBlock('b1', $header);
$TBS->MergeBlock('b2', $value);
|
Should do in Excel
A B C
1 Header 1 Header 2 Header 3
2 Value 1 Value 2 Value 3
3 Value 1 Value 2 Value 3
How should implement this in Execl?
Tried something like this :
[b1.header;block=c]
[b2.value;block=row]
But doesn't work properly.
Thank's by advance.