Free Support Forum - aspose.com

Aspose.Cells with International Characters

Hi,

How can I use Aspose.Cells to retrieve the value of a cell that has Japanese characters inside of it?

For example, I have a cell that contains the Japanese text 制作費無料名刺. When I retrieve the value using the .StringValue function it comes back as giberish. Does any one know what I can do either in Excel or programatically to retrieve the information correctly?

Thanks,

Jason

Hi Jason,

Are you using an Evaluation copy of Aspose.Cells? This may be caused by evaluation limitation:

http://www.aspose.com/wiki/default.aspx/Aspose.Cells/Licensing.html .

I used the following code to open and retrieve the value and it worked fine.

Excel excel = new Excel();

excel.Open("d:\\test\\book1.xls");

Console.WriteLine(excel.Worksheets[0].Cells["A1"].StringValue);

Please check the attached Excel file and screenshot.