Nov 18, 2010 at 3:17 PM
Edited Nov 18, 2010 at 3:19 PM
I have a client that is looking to export some figures from their database into an Excel sheet. This involves the pound symbol (£) as their business is in the UK. I've tried using the following code:
$currencyFormat = '[$£-809]#.##0,00;[Red]-[$£-809]#.##0,00';
However this pulls up errors and won't create the sheet correctly. When I open the sheet, I get the error:
"Excel ha encontrado contenido que no se puede leer en 'text.xlsx'. ¿Desea recuperar el contenido del libro? Si confia en el origen de este libro, haga clic en Si."
or in English;
"Excel has found content that can not be read in 'text.xlsx'.
Do you want to retrieve the contents of the book? If you trust the source of this workbook, click Yes."
If I click Si/Yes, then it opens the workbook but with no formatting at all.
Does anyone have any ideas or suggestions?
My version numbers are:
PHPExcel: Version 1.7.4, 2010-08-26
PHP Version: 5.2.14
Running on Linux.