Link to home
Start Free TrialLog in
Avatar of Tim
TimFlag for Canada

asked on

What PHP method best to fill information in Excel file and can set font , page break, etc.?

What PHP method best to fill information in Excel file and can set font , page break, etc.?
I did one project which can read the excel file and fill the information to this file.
It use php COM to get the excel report.
Now I transfer to new server, it looks COM object has the running issue.

So I need find good PHP method.
It read the excel template and it can set font size, border weight , font ,,, etc.

like
$temp_rang = "A" . $linem . ":A" . $linem;
                  $cell = $sheet2->Range ( $temp_rang );
                  $cell->activate;
                  $cell->value = "Customer Sample No:";
                  $pot = strlen ( "Customer Sample No:" );
                  $o_Font = $cell->Characters ( 0, $pot )->Font;
                  $o_Font->Bold = True;
                  $cell->BORDERS ( $xlEdgeTop )->Weight = 2;
                  $cell->BORDERS ( $xlEdgeLeft )->Weight = 2;
                  $cell->BORDERS ( $xlEdgeBottom )->Weight = 2;
                  $cell->BORDERS ( $xlEdgeRight )->Weight = 2;

Anyone can help? Thanks
ASKER CERTIFIED SOLUTION
Avatar of Chris Stanyon
Chris Stanyon
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial