in reply to UTF8 support for CSV, PDF formats

but when i open the CSV file in the excel, i don't see the japanese characters properly

I think you need to tell Excel about the UTF-8 encoding, perhaps in the File-Open-dialog. Why don't you use Spreadsheet::WriteExcel or Excel::Writer::XLSX to generate "real" Excel files?

Alexander

--
Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)

Replies are listed 'Best First'.
Re^2: UTF8 support for CSV, PDF formats
by vishi83 (Pilgrim) on Jan 10, 2012 at 05:08 UTC
    Thanks. I dint have issues with excel using the Spreadsheet::WriteExcel module.
    However, i also want to make sure i can handle a delimited formats like CSV.