I have an Excel that I am creating with :
public function sixty765()
{
$this->exec_summary(); //build the array
$title = sprintf("proforma 6765 for %s. warning: this spreadsheet is just a sample and should not be relied upon without expert due diligence", $this->session->userdata('campaign'));
$description = sprintf("Sample of 6765");
$report = new MyExport6765;
$report->run()->exportToExcel(array(
"properties" => array(
"creator" => "Research Study Online",
"title" => $title,
"description" => $description,
"subject" => "sample 6765",
"keywords" => "",
"category" => "",
)
))->toBrowser($this->session->userdata('campaign') . " proforma results.xlsx");
$report->run()->render();
}
The resulting spreadsheet is attached. I'd like to modify the header (c0 and c1) to say something line line# and result. I'd also like to add another blank column and then add another column of data. And also a blank row for row 4 and also a few column headers. How can I do these things?