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

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 :)

Comment on Re^8: Parsing a .xlsx file with chinese characters Download Code

Replies are listed 'Best First'.
Re^9: Parsing a .xlsx file with chinese characters by anneli (Pilgrim) on Oct 06, 2011 at 22:11 UTC
How curious! I'm glad you got it working. :)	[reply]
Re^10: Parsing a .xlsx file with chinese characters by Anonymous Monk on Dec 17, 2012 at 22:16 UTC
Me too. Saved me a few hours, I'm sure.	[reply]

In Section Seekers of Perl Wisdom