从excel php [复制]修剪前导0

Question

This question already has an answer here:

• Correct format for strings / numbers beginning with zero? 5 answers

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>

Answer 1

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"