Free Support Forum - aspose.com

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

While exporting using Aspose.Cells, foreign language characters are not displaying properly in the excel sheet. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

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.

Hi,

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

Please change your font setting in your file.

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

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.