Hi,
I'm trying to export an Excel file to PDF but utf8 characters doesn't show up properly.
Those ½, ñ are being shown with different symbols.
This is the code I'm using:
using ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;
application.DefaultVersion = Syncfusion.XlsIO.ExcelVersion.Xlsx;
IWorkbook workbook = application.Workbooks.Open(excelStream);
//Initialize XlsIO renderer
XlsIORenderer renderer = new XlsIORenderer();
//Initialize XlsIORendererSettings
XlsIORendererSettings settings = new XlsIORendererSettings();
settings.LayoutOptions = LayoutOptions.FitSheetOnOnePage;
//Convert Excel document into PDF document
PdfDocument pdfDocument = renderer.ConvertToPDF(workbook, settings);
//Save the document into a stream
using MemoryStream outputStream = new MemoryStream();
pdfDocument.Save(outputStream);
excelStream variable is the content I get from my existing Excel and it doesn't have this issue.
Thanks!
