Aspose.Cells with International Characters

Aspose.Cells Product Family
1

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

2

Hi Jason,

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

Licensing.

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.