Tim
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.