//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; //use Name property to set font name. worksheet.Range["A1"].Value = "Calibri"; worksheet.Range["A1"].Font.Name = "Calibri"; //use ThemeFont property to set font name. worksheet.Range["A2"].Value = "Major theme font"; worksheet.Range["A2"].Font.ThemeFont = ThemeFont.Major; // Save to an excel file workbook.Save("FontName.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) 'use Name property to set font name. worksheet.Range!A1.Value = "Calibri" worksheet.Range!A1.Font.Name = "Calibri" 'use ThemeFont property to set font name. worksheet.Range!A2.Value = "Major theme font" worksheet.Range!A2.Font.ThemeFont = ThemeFont.Major ' save to an excel file workbook.Save("FontName.xlsx")