private void DoThings()
{
ExcelFile xls = new XlsFile(true);
xls.NewFile(1, TExcelFileFormat.v2019);
for (int r = 1; r < 2000; r++)
{
xls.InsertHPageBreak(r); //This won't throw an exception here, since FlexCel allows to have more than 1025 page breaks, but at the moment of saving. (since an xls file can't have more than that)
}
xls.SetCellValue(1, 1, "We have a page break on each row, so this will print/export as one row per page");
xls.SetCellValue(2, 1, "??? ? ? ? ???? ????"); //Since we leave the font at arial, this won't show when exporting to pdf.
TFlxFormat fmt = xls.GetDefaultFormat;
fmt.Font.Name = "Arial Unicode MS";
xls.SetCellValue(3, 1, "??? ? ? ? ???? ????", xls.AddFormat(fmt)); //this will display fine in the pdf.
fmt.Font.Name = "ThisFontDoesntExists";
xls.SetCellValue(4, 1, "This font doesn't exists", xls.AddFormat(fmt));
//Tahoma doesn't have italic variant. See http://help.lockergnome.com/office/Tahoma-italic-ftopict705661.html
//You shouldn't normally use Tahoma italics in a document. If we embedded the fonts in this pdf, the fake italics wouldn't work.
fmt.Font.Name = "Tahoma";
fmt.Font.Style = TFlxFontStyles.Italic;
xls.SetCellValue(5, 1, "This is fake italics", xls.AddFormat(fmt));
if (saveFileDialog1.ShowDialog() != DialogResult.OK)
{
return;
}
using (FlexCelPdfExport pdf = new FlexCelPdfExport(xls, true))
{
pdf.Export(Path.ChangeExtension(saveFileDialog1.FileName, ".pdf"));
}
xls.Save(saveFileDialog1.FileName + ".xls");
}