Sub-blocks in Excel

It there a tutor for Sub-block in excel?

In php, I used

$TBS->MergeBlock('blk1',$cnx_id, $sql_query1  ) ;
$TBS->MergeBlock('sub',$cnx_id," SELECT  * FROM td_child WHERE (id=%p1%)    ") ;

In excel, ROW 1,
[blk1.id;block=table;ope=xlNum]
ROW 2,
[sub.childname;block=Row;p1=[blk1.id]]

It only loop for 1 row. Any idea?

Hi,

It should not be "block=table" but "block=Table".

But anyway, using Tables is dangerous. The doc says:<Tables> elements should not be repeated by merging TBS block because their first <Row> and <Cell> elements may contain absolute indexes for positioning.

can you try:

Perfect. I love TBS. It is really a good solution for PHP export Excel. And support UTF-8 coding as well. Perfect.