Esempio n. 1
0
        public override void Execute(GrapeCity.Documents.Excel.Workbook workbook)
        {
            IWorksheet sheet = workbook.Worksheets[0];

            //set style.
            sheet.Range["A1"].Value          = "Sheet1";
            sheet.Range["A1"].Font.Name      = "Wide Latin";
            sheet.Range["A1"].Font.Color     = Color.Red;
            sheet.Range["A1"].Interior.Color = Color.Green;

            //specify font path.
            GrapeCity.Documents.Excel.Workbook.FontsFolderPath = @"D:\Fonts";

            //get the used fonts list in workbook, the list are:"Wide Latin", "Calibri"
            var fonts = workbook.GetUsedFonts();

            //change the path to real export path when save.
            sheet.Save(this.CurrentDirectory + "dest.pdf", SaveFileFormat.Pdf);
        }