jasonrogena / jasonrogena/php-excel-reader

iconv detected an illegal character in input string in xls column when using email as input

Open
#203 0 comments 0 reactions 0 assignees View on GitHub
auto-migrated Priority-Medium Type-Defect
Dominant language
PHP
Stars
1
Forks
0
PR merge metrics
No merged PRs in 30d

Description

```
When parsing a excel column that contain data as like, some@mail.com.

then it shows 500 error with summary output.

but it solved using ,

function
Spreadsheet_Excel_Reader($file='',$store_extended_info=true,$outputEncoding='')
{
$this->_ole =& new OLERead();
$this->setUTFEncoder('UTF-8'); // newly added line

```

Original issue reported on code.google.com by `sivanth...@gmail.com` on 30 May 2015 at 7:01

Contributor guide

No contributing guide indexed for this repository

Research direction

Start in the Spreadsheet_Excel_Reader constructor and inspect how setUTFEncoder and OLERead handle XLS cell input. Reproduce the failure with an XLS column containing an email address and check the summary output. Done means the column parses without the iconv error or resulting 500 response.

Written by the indexing model from the issue text.

Assessment

Tech stack
php
Domain
backend
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.