in reply to Problems using Spreadsheet::ParseExcel with mySQL binary data

and stored as binary data in a BLOB field using UTF-8 encoding.

UTF-8 encoding is for text data. Binary data doesn't need an extra encoding.

Do I need to read the binary data into a temporary file first with a suitable encoding option and then pass this file to the Parse() method?

No, all encoding steps that an IO layer might perform can also be done without writing to a file (for example with Encode). But you shouldn't need this, because you should never treat binary data as text, and never encode or decoded it with utf-8.

  • Comment on Re: Problems using Spreadsheet::ParseExcel with mySQL binary data