pythonstringcsvintpyexcel

Pyexcel: do not ignore underscores


I an using pyexcel to read a csv file which contains entries like

1234_5678,,,,,,,

This is being read in by pyexcel as 12345678 rather than "1234_5678". Is there a way to force this to be read as a string rather than having the underscores removed.

The way I am using pyexcel is with the get_array function

pyexcel.get_array(file_content=file_content, file_type="csv")

Solution

  • Pyexcel issue 138 stated the same use case. And it has been resolved by pyexcel-io version 0.5.7+. For example, the following command will do:

    pip install pyexcel-io==0.5.7
    

    On the contrary, if you want to keep the feature instead, you can pass on pep_0515_off=False in your function call.