Member Avatar for eReBoS
eReBoS 0 Newbie Poster

Hi,

I have an application that converts the ascii characters within the excel file into hexa conversion ie. à to & #x00E0;

but my application has one strict requirement and that is the excel file must be properly encoded in UTF-8. I have noticed that simply saving the excel file in windows will have CP1251 encoding causing some characters to be unreadable in python. So, the work around is open the excel file in OpenOffice Scal and save it as .csv, edit the setting and set to UTF-8 and save again as .xls.

Problem is, i need to make sure that the input excel file is encoded in UTF-8. So, is there a way to detect the encoding of the input excel file?

Edited by eReBoS because: hexa conversion didn't show properly
  • 1 Contributor
  • 0 Replies
  • 117 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.