PHPExcel

PHPexcel: Error loading file “uploaded_order.xls”: Unknown codepage: 10002

Error loading file "uploaded_order.xls": Unknown codepage: 10002 Reason: This file could made on Mac and cause some identify issue. Solution:

function download_tpl(){ //$this->check_permission('orders', 'update', array('download', 'download_m')); $sep = DIRECTORY_SEPARATOR; $fil

if($columnN == 1){ $worksheet->setCellValueExplicit( 'B' . $rowN, $value, PHPExcel_Cell_DataType::TYPE_STRING ); }else{ $

$value = $sheet->getCellByColumnAndRow($i, $row_index)->getValue(); if(is_object($value) == true){ $value = $value->getPlainText(); }

private function excel_handler($file){ //Start to read require(APPPATH.'libraries/PHPExcel.php'); include APPPATH.'libraries/PHPExcel/IOFactory.

require(APPPATH.'libraries/PHPExcel.php'); $file_name = 'Statement_' . compact_date($from) . '-' . compact_date($to) . '_' . $partner_id . '.xls'; $

public function excel_get(){ $this->check_login(); $file = FCPATH . 'uploads' . DIRECTORY_SEPARATOR . 'Members.xls'; $file_url = base_u

//Enhance cache of phpexcel $cacheMethod = PHPExcel_CachedObjectStorageFactory:: cache_to_phpTemp; $cacheSettings = array( ' memoryCacheSize &

$sheet -> getCell('A1') -> getValue() If the value is a "date", then this statement will get a "number". To convert this number for PHP to

$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimen