While exporting using Aspose.Cells- foreign language characters are not displaying properly in the excel sheet

Aspose.Cells Product Family
1

While exporting using Aspose.Cells, foreign language characters are not displaying properly in the excel sheet.

Here is the code which I used to convert to pdf.

Sub XLS2PDF()

Dim designerFile As String = "C:\temp\Files\239489.xls"

Dim xmlFile As String = "C:\temp\Files\239489.xml"

Dim pdfFile As String = "C:\temp\Files\239489.xls.pdf"

Dim wb As Aspose.Cells.Workbook = New Aspose.Cells.Workbook

wb.Open(designerFile)

wb.Save(xmlFile, FileFormatType.AsposePdf)

Dim pdf As Aspose.Pdf.Pdf = New Aspose.Pdf.Pdf

pdf.BindXML(xmlFile, Nothing)

pdf.Save(pdfFile)

Try

File.Delete(xmlFile)

Catch ex As System.Exception

End Try

End Sub

Please find the attached document, which I used for conversion. Is there any option to set in excel for supporting the foreign language.

2

Hi,

If the characters are Chinese characters ,Aspose.Pdf only supports the font "黑体"，宋体","Arial Unicode MS".

Please change your font setting in your file.

3

Could you send me the code snippet, I dont see any properties to set font.

4

Hi,

Please check the following documentation topic that defines how to set fonts to worksheet cells.

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/dealing-with-font-settings.html

Thank you.