[suggestion] detect character encoding for CSVs

[andy-educake]

This is:

- [ ] a bug report
- [*] a feature request
- [*] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet)

What is the expected behavior?

When loading a CSV file, it assumes UTF-8. However if you don't know the encoding, you need to open the file to try and detect what encoding is used. It would be good to have a "detect" option as the openFileOrMemory() method on the CSV reader already opens the file and converts to UTF-8.

What is the current behavior?

Either the reader assumes the data is UTF-8 (in which case fgetcsv can corrupt the data if it's not UTF-8) or you need to open the file manually beforehand to supply the correct encoding.

Possible API to provide this functionality

<?php

require __DIR__ . '/vendor/autoload.php';

// Create new Spreadsheet object
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Csv();
$reader->setInputEncoding('detect');
//or 
$reader->setAutoDetectInputEncoding(true);

$spreadsheet = $reader->load($pathToFile);

Which versions of PhpSpreadsheet and PHP are affected?

We are using 1.14.1 and that is definitely affected.

I'm happy to have a go at creating a PR if you think this is a valuable addition?

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.
If this is still an issue for you, please try to help by debugging it further and sharing your results.
Thank you for your contributions.

[oleibman]

Solved with PR 1717.