If the content of the csv file contains Chinese characters enclosed in double quotes, the data will not be output correctly about phpspreadsheet HOT 4 OPEN

I am not able to duplicate your result - I see the expected result when I execute your code. I know you have shown the contents of test.csv above. Please upload the file instead and I will try to see if there is something about the file that causes your unexpected result.

from phpspreadsheet.

I am not able to duplicate your result - I see the expected result when I execute your code. I know you have shown the contents of test.csv above. Please upload the file instead and I will try to see if there is something about the file that causes your unexpected result.

@oleibman Thank you for taking the time to help me look at this problem.My running environment is: PHP 7.4, Windows Simplified Chinese version, version number 10 22H2
test-false.csv

from phpspreadsheet.

Sorry, still getting the expected result (Php7.4 PhpSpreadsheet 1.0.29 Windows 11 US, and also more recent releases of Php and PhpSpreadsheet):

Array
(
    [0] => test
    [1] => 中文
    [2] => 1
)

I don't have any further ideas on why you are seeing a problem on your system.

from phpspreadsheet.

Sorry, still getting the expected result (Php7.4 PhpSpreadsheet 1.0.29 Windows 11 US, and also more recent releases of Php and PhpSpreadsheet):

Array
(
    [0] => test
    [1] => 中文
    [2] => 1
)

I don't have any further ideas on why you are seeing a problem on your system.

@oleibman Thanks for your reply, I tried to set up a Linux system in VMware, ran the example code in Linux, It did output normally. Now preliminary judgment may be Windows 10 simplified Chinese version of the coding problem. Thank you again for your help.

from phpspreadsheet.