Re^8: Parsing a .xlsx file with chinese characters

[Sithiris]

in reply to Re^7: Parsing a .xlsx file with chinese characters
in thread Parsing a .xlsx file with chinese characters

Well I solved my problem using

pack "U0C*", unpack "C*", ($cell->{val});

I'm not entirely sure what that does, but I'm guessing it unpacks the characters into its octets and then repackages it up as a Unicode character... Anyway whatever it does it worked so now all the characters are displayed correctly.

Thank you for your help :)

[anneli]

How curious! I'm glad you got it working. :)

[Anonymous Monk]

Me too. Saved me a few hours, I'm sure.