Hello, How to set the right font for export to PDF? Meaning different language characters.  Both csv and xlsx are correct. Only happen when export to PDF. Thanks

Thanks for the reply.

Apply the code like following

                       var activeSheet = workbookView.ActiveWorksheet;
                       PdfExporter pdfExporter = new PdfExporter();
                       pdfExporter.AutoDetectEncoding = false;
                       pdfExporter.DefaultEncoding = Encoding.Unicode;
                       pdfExporter.Export(activeSheet, dialog.FileName);




The original data is like :

OrderID      DSID      warehouse      訂單日期      pv      Total Sales
703012674      700187543      20867      2020/5/14 上午 12:00:00      185      2276
703012676      693739      21300      2020/5/14 上午 12:00:00      120      1596


After apply the code the data is not readable and like


P s e f s J E E T J E x b s f i p v t fYª%V5•6Ç q w U p u b m ! T b m f t
8 1 4 1 2 3 7 8 5 8 1 1 2 9 8 6 5 4 3 1 9 7 8 3 1 3 1 0 6 0 2 5 2 9 6 3 3 8 7
8 1 4 1 2 3 7 8 7 7 : 4 8 4 : 3 2 4 1 1 3 1 3 1 0 6 0 2 5 2 3 1 2 6 : 7




This is data export from PDF export

OrderID DSID warehouse� U®eåg pv Total Sales
703012674700187543 20867 2020/5/14 185 2276
703012676 693739 21300 2020/5/14 120 1596


This is the data should shown

OrderID      DSID      warehouse      訂單日期      pv      Total Sales
703012674      700187543      20867      2020/5/14 上午 12:00:00      185      2276
703012676      693739      21300      2020/5/14 上午 12:00:00      120      1596


Thanks for the help

The text shown on the spreadsheet is correct but it not correct when export to PDF. Other export types are OK (XLSX, CSV). I try to display on Chrome, Edge and PDF reader but failed on all of them.   On the PDF reader, it failed to open the file with error message show on the screen.

Open from the Edge

Here is the code


           private void GenerateRandomFont(ref Cell cell)
           {
                 var style = cell.Style;

                 style.FontName = "MingLiU";
                 style.FontBold = false;
                 style.FontItalic = false;
                 //style.FontSize = 14;
           }
           private void menuItemPdf_Click(object sender, RoutedEventArgs e)
           {
                 SaveFileDialog dialog = new SaveFileDialog();

                 dialog.Filter = "PDF Files (*.pdf)|*.pdf|All files (*.*)|*.*||";
                 if (dialog.ShowDialog(this) == true)
                 {
                       var activeSheet = workbookView.ActiveWorksheet;
                       PdfExporter pdfExporter = new PdfExporter();
                       //pdfExporter.AutoDetectEncoding = false;
                       //pdfExporter.DefaultEncoding = Encoding.Unicode;
                       pdfExporter.Export(activeSheet, dialog.FileName);
                 }
           }

What does that message mean in English?

Quote:


You will need to uncomment these to get PDFs working in Reader / Chrome.

It worked for me with only a few strings from your sample data, so I guess something else from all the cells is breaking it. Please attach the spreadsheet file you are exporting and our developer will check.

PDF exported from this file renders correctly for us in Adobe Reader and Chrome.

var imp = new ExcelImporter();
imp.View = wbview;
imp.Import("bbb.xlsx", wbview.Workbook);
...
var activeSheet = wbview.ActiveWorksheet;
PdfExporter pdfExporter = new PdfExporter();
pdfExporter.AutoDetectEncoding = false;
pdfExporter.DefaultEncoding = Encoding.Unicode;
pdfExporter.Export(activeSheet, @"D:\test.pdf"); 

Does the attached PDF work on your side if you open it in Adobe / Chrome? If our file works but yours does not, it might mean PdfExporter's font embedding code fails for some reason when running on your system.