KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

How to add a new column (and fix the header) #2118

Open Richb201 opened this topic on on Jun 1, 2021 - 1 comments

Richb201 commented on Jun 1, 2021

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?

Richb201 commented on Jun 2, 2021

Can you "throw me a bone" and give me a hint of how to fix this?

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
help needed

None