从excel php [复制]修剪前导0
This question already has an answer here:
I am trying a lot to include the leading 0 in the excel which is getting trimmed from the excel sheet. I used like below for the column value and it is showing the leading 0, but with a single quote at the begining.
The value i am using like "'$value"
Can anyone please help me in this how to remove this single quote from the excel with having the leading 0?
</div>
I would recommend formatting the data range as a 10 digit number instead of inserting an '.
You can find out more about Range.NumberFormat here on MSDN.
Where $value is your value and $worksheet is a Worksheet object:
$value = "0000000001"
$workSheet.Range("A1").Value2 = $value
$workSheet.Range("A1").NumberFormat = "0000000000"
