How can i format exported data in excel file using Php pack function?

Question

I have no idea how to use Excel Extended Format. I'm trying to add '%' or red color(when data is belong zero).

Using those scripts :

    function xlsBOF() {
        echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0);  
        return;
    }

    function xlsEOF() {
        echo pack("ss", 0x0A, 0x00);
        return;
    }

    function xlsWriteNumber($Row, $Col, $Value) {
        echo pack("sssss", 0x203, 14, $Row, $Col, 0x0);
        echo pack("d", $Value);
        return;
    }

    function xlsWriteLabel($Row, $Col, $Value ) {
        $L = strlen($Value);
        echo pack("ssssss", 0x204, 8 + $L, $Row, $Col, 0x0, $L);
        echo $Value;
    return;
    }


    xlsBOF();
      xlsWriteLabel(1,1,'Smth');


    $val = -12,23;
    /* This number should be exported red with %,
       i think i have to use this '0,00%;[RED]-0,00%' but no idea how
    */
    xlsWriteNumber(2,1,$val);

    xlsEOF();
    exit();

Thanks in advance.

Community · Accepted Answer · 2017-05-23 11:48:07Z

1

You need to write the style information as a style (xf) entry, then setting the 0x0 value in your xlsWriteLabel to identify using the style xf index:

See PHP to Excel, bold font for a more detailed description of how to do this (it does identify the colour settings as well as bold, despite the title of the thread), then look at better libraries for writing Excel files.

You can find a list of libraries in the responses to this question

edited May 23, 2017 at 11:48

CommunityBot

11 silver badge

answered Jan 6, 2012 at 16:04

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can i format exported data in excel file using Php pack function?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related