Excel Export including span-title in header

Questions › Excel Export including span-title in header

Mike Sheppard asked 9 years ago

When I set-up a custom title like the following:

$col["title"] = "Line 1 Line 2";

The actual text gets exported as the Excel Column Header.

Is there a way to export a proper title? Or strip-out the HTML portion?

Thanks

Mike

1 Answers

Mike Sheppard answered 9 years ago

I'm hoping there is an alternative – but I used the following approach (based on a similar response to another thread).

This allows you to specify both options at the column level but only add one function.

Thanks

Mike

—————8< —————–
$col["title"] = export_title($opt1="EXPORT_HEADING", $opt2="REPORT HEADING");

function export_title($opt1,$opt2)
{
if (isset($_GET["export"]))
return $opt1;
else
return $opt2;
}

Your Answer