//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; worksheet.Range["A1"].Value = "Single Underline"; worksheet.Range["A1"].Font.Underline = UnderlineType.Single; worksheet.Range["A2"].Value = "Double Underline"; worksheet.Range["A2"].Font.Underline = UnderlineType.Double; worksheet.Range["A3"].Value = "Single Accounting Underline"; worksheet.Range["A3"].Font.Underline = UnderlineType.SingleAccounting; worksheet.Range["A4"].Value = "Double Accounting Underline"; worksheet.Range["A4"].Font.Underline = UnderlineType.DoubleAccounting; worksheet.Range["A5"].Value = "No Underline"; worksheet.Range["A5"].Font.Underline = UnderlineType.None; worksheet.UsedRange.AutoFit(); // Save to an excel file workbook.Save("FontUnderline.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) worksheet.Range!A1.Value = "Single Underline" worksheet.Range!A1.Font.Underline = UnderlineType.Single worksheet.Range!A2.Value = "Double Underline" worksheet.Range!A2.Font.Underline = UnderlineType.Double worksheet.Range!A3.Value = "Single Accounting Underline" worksheet.Range!A3.Font.Underline = UnderlineType.SingleAccounting worksheet.Range!A4.Value = "Double Accounting Underline" worksheet.Range!A4.Font.Underline = UnderlineType.DoubleAccounting worksheet.Range!A5.Value = "No Underline" worksheet.Range!A5.Font.Underline = UnderlineType.None worksheet.UsedRange.AutoFit() ' save to an excel file workbook.Save("FontUnderline.xlsx")