Comments (5)
try set page charset before output
header('Content-Type: text/html; charset=utf-8');
$xls = SimpleXLSX::parse....
from simplexls.
I have the same issue. Some of the some türkish charachters "Ü,ü,Ö,ö" sometimes are read wrong. In the same cell when I change cell context it is read one time wrong one time right. interesting issue.
from simplexls.
class works good with unicode, just don't forget set output charset:
header('Content-Type: text/html; charset=utf-8');
one time wrong one time right --- so browser charset autodetection not perfect without this header
from simplexls.
Thanks for your reply. I expressed myself wrong. sorry about my english. I'm trying to import excel file which includes turkhish characters. I read excel file and record them to the database with code shown below.
If you think it is appropriate I can send you my excel file which I made my trials
header('Content-Type: text/html; charset=utf-8');
$xls = new SimpleXLS($excelFilePath);
$headers = $rows = [];
//echo "<pre>";
if ($xls->success()) {
print_r($xls->rows());
foreach ($xls->rows() as $k => $r) {
if ($k === 0) {
$headers = $r;
continue;
}else{
if($r[0]!=""){
$katilimci_bulk = new FuarKatilimci();
$katilimci_bulk->setFirmaAdi($r[0]);
$katilimci_bulk->setHolNo($r[1]);
$katilimci_bulk->setStantNo($r[2]);
$katilimci_bulk->setYetkili($r[3]);
$katilimci_bulk->setMail($r[4]);
$katilimci_bulk->setTelefon($r[5]);
$katilimci_bulk->setFax($r[6]);
$katilimci_bulk->setAdres($r[7]);
$katilimci_bulk->setSehir($r[8]);
$katilimci_bulk->setUrunGrubu($r[9]);
$katilimci_bulk->setFuar($entity->getFuar());
$em->persist($katilimci_bulk);
$em->flush();
}
}
}
from simplexls.
If you think it is appropriate I can send you my excel file which I made my trials
no, thx, have nice day )
from simplexls.
Related Issues (20)
- Error in parsing UTF-8 HOT 25
- XLS not recognized HOT 8
- example should be SimpleXLS not SimpleXLSX HOT 1
- Document reading bug HOT 3
- Improvement: get state of a sheet HOT 3
- Wrong reading of special characters for a Excel95 (BIFF7) HOT 2
- Find Active sheet? HOT 2
- Please add support for file.xlsb [ Binary Excel document ] HOT 2
- Number is transformed into an exponential number HOT 4
- Any chance rowEX() could be added to simplexls? HOT 1
- Problem with the maximum range of the 64k loop - warning HOT 5
- encode sheetnames and cells maybe more good HOT 1
- Formula evaluation - incorrect percent result HOT 2
- How can I find the cell? HOT 1
- Can't define the datetime format HOT 1
- Different number of columns. HOT 1
- Not working HOT 2
- XLS with 65535 rows causes 'numRows' to return 0 HOT 5
- Library breaks when user uploads file with Norwegian characters HOT 2
- datetime field not parsed correctly HOT 7
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from simplexls.