PowerKiKi on 1.8
Permanently archive the project… (compare)
Hi Can you guys help me?
I am having trouble saving the excel file in mysql database, It contains enter(new line) inside a cell and symbols & superscripts as well. But it stores as plain text only.
$objReader = new PHPExcel_Reader_Excel5();
$objPHPExcel = $objReader->load($inputFileName);
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);
then i read some data and use
to reset the pointer.
and again use foreach loop, to add the data into an array and insert that array to mysql table. Does any of these steps remove pre-formatting?(superscript/subscript/new line inside a cell and bold/italics) and How can I put the data in the table exactly as in the excel?
Edit: I am using v1.8 of PHPExcel, v5.4 of PHP and MySQL v5.6
I am using PHPExcel as part of a platform that takes in xlsx and csv files and uploads them to our system. We are having trouble with
It is throwing
Scale must be greater than or equal to 1.
From what I can see there is no way to set the zoom scale other than in excel, however we cannot guarantee our clients will all do this properly. Is there a way around this short of forking PHPExcel (which we'd rather not do...)?
Unfortunately the only solutions I have found on stack overflow are people forking and writing their own fix.