//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; //Set range values. worksheet.Range["A2:B2"].Value = -15.50; worksheet.Range["A3:B3"].Value = 555; worksheet.Range["A4:B4"].Value = 0; worksheet.Range["A5:B5"].Value = "Name"; //Apply custom number format. worksheet.Range["B2:B5"].NumberFormat = "[Green]#.00;[Red]#.00;[Blue]0.00;[Cyan]\"product: \"@"; // Save to an excel file workbook.Save("CustomNumberFormat.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) 'Set range values. worksheet.Range("A2:B2").Value = -15.5 worksheet.Range("A3:B3").Value = 555 worksheet.Range("A4:B4").Value = 0 worksheet.Range("A5:B5").Value = "Name" 'Apply custom number format. worksheet.Range("B2:B5").NumberFormat = "[Green]#.00;[Red]#.00;[Blue]0.00;[Cyan]""product: ""@" ' save to an excel file workbook.Save("CustomNumberFormat.xlsx")