simplexls

simplexls copied to clipboard

Wrong reading of special characters for a Excel95 (BIFF7)

2

Cell B1 of first sheet : [test_pv_95.xls](https://github.com/shuchkin/simplexls/files/7202828/test_pv_95.xls) I get : &�?���?????? Instead of : &é?¥®™?????? (Excel 2003 to 95 lost arabic and hebrew characters, I shoud have had &é₤¥®™≠بةائӨ) I...

pvalin

encode sheetnames and cells maybe more good

1

public function encode($txt){ $arr=array('EUC-CN' => 'GB2312','CP936' => 'GBK','SJIS-mac'=>'MacJapanese','SJIS-Mobile#DOCOMO'=>'SJIS-DOCOMO','SJIS-Mobile#KDDI'=>'SJIS-KDDI','SJIS-Mobile#SOFTBANK'=>'SJIS-SOFTBANK','UTF-8-Mobile#DOCOMO'=>'UTF-8-DOCOMO','UTF-8-Mobile#KDDI-B'=>'UTF-8-KDDI','UTF-8-Mobile#SOFTBANK'=>'UTF-8-SOFTBANK','ISO-2022-JP-MOBILE#KDDI'=>'ISO-2022-JP-KDDI'); $encode = mb_detect_encoding($txt, ['ASCII', 'UTF-8', 'GB2312', 'GBK', 'BIG5']); if(array_key_exists($encode, $arr)) $encode = $arr[$encode]; return mb_convert_encoding($txt, 'UTF-8', $encode); } //sheetnames and cells //sheetnames:...

yujianyue

Any chance rowEX() could be added to simplexls?

1

I was working an XLS file that has cell formulas which return as zeros when I use $xls->rows(). It would be helpful to have a slimmed down version of SimpleXLSX's...

vce-wabbott

Can't define the datetime format

1

Hey! I'm using your library to import data from XLS document and it seems that the setDateTimeFormat() method have no effect on the output of the row() method. The problem...

ceininger

How can I find the cell?

1

I want to just take the specific cell like $rowcount = count($excel -> rows(1)); for( $i=1; $i

dhlyy

I’ve noticed that when using named ranges in formulas, the simplexls does not recognise them. e.g. if this is in the spreadsheet =IF(named_range_1="No","Some Value No","Some Value Yes") It will just...

amd-123