I have the solution export an xls file with rowspan and col

maybe I have the solution to export an Excel file with rowspan and colspan

please test it and tell me what you think
generate.rar (804 Bytes)

I forgot to say that it is for export on the server side
and does not affect the client side

small addition

	if($cnt_cs>1)
	{
		$arr_h[0]->column[$j]->addAttribute('colspan',$cnt_cs);
		[u][b]$cnt_cs=1;[/b][/u]
	}

Hi, good work.
I’ll test it next week.
Thanks :slight_smile:

ok Thanks :stuck_out_tongue:

hi

Suggestion

we can use this code in the convert page as it works well for both export pdf or excel

Do you have any solution for making colspan,rspan in headers work in Java ??
Pls note that I am using something like this so that sensitive data is sent to a local server and not to external server .
onclick=“mygrid2.toExcel(‘generate’);”

This works fine when there is no cspan in headers.

Hi.
The last java version of export processes colspan/rowspan correctly.
Please, try to update export tool from here:
viewtopic.php?f=23&t=20151
or use online export service:
viewtopic.php?f=23&t=18333

Thanks a ton :slight_smile: This works !!