I know this discussion is old, but it applies directly (and I hope someone sees it.
I import Excel into my PHP app using PHPExcel (1.7.6). There are text cells with leading zero(s).
Upon traversing the imported sheet, getValue() and getFormattedValue() both lose the leading zero(s).
I have tried various formats for the cells prior to importing (General, Text) and in every instance, there is no leading zero(s).
I am really at a loss as previous research has shown that since 1.7.5 the getFormattedValue() should retain this.
Any help is surely appreciated.