static void Main(string[] args) { try { Book book = new BinBook(); Font font = book.addFont(); font.size = 36; Format format = book.addFormat(); format.alignH = AlignH.ALIGNH_CENTER; format.setBorder(BorderStyle.BORDERSTYLE_MEDIUMDASHDOTDOT); format.setBorderColor(Color.COLOR_RED); format.font = font; Sheet sheet = book.addSheet("Sheet1"); sheet.writeStr(2, 1, "Format", format); sheet.setCol(1, 1, 25); book.save("format.xls"); System.Diagnostics.Process.Start("format.xls"); } catch (System.Exception e) { Console.WriteLine(e.Message); } }
static void Main(string[] args) { try { Book book = new BinBook(); int f1 = book.addCustomNumFormat("0.0"); int f2 = book.addCustomNumFormat("0.00"); int f3 = book.addCustomNumFormat("0.000"); int f4 = book.addCustomNumFormat("0.0000"); int f5 = book.addCustomNumFormat("#,###.00 $"); int f6 = book.addCustomNumFormat("#,###.00 $[Black][<1000];#,###.00 $[Red][>=1000]"); Format format1 = book.addFormat(); format1.setNumFormat(f1); Format format2 = book.addFormat(); format2.setNumFormat(f2); Format format3 = book.addFormat(); format3.setNumFormat(f3); Format format4 = book.addFormat(); format4.setNumFormat(f4); Format format5 = book.addFormat(); format5.setNumFormat(f5); Format format6 = book.addFormat(); format6.setNumFormat(f6); Sheet sheet = book.addSheet("Custom formats"); sheet.setCol(0, 20); sheet.writeNum(2, 0, 25.718, format1); sheet.writeNum(3, 0, 25.718, format2); sheet.writeNum(4, 0, 25.718, format3); sheet.writeNum(5, 0, 25.718, format4); sheet.writeNum(7, 0, 1800.5, format5); sheet.writeNum(9, 0, 500, format6); sheet.writeNum(10, 0, 1600, format6); book.save("custom.xls"); System.Diagnostics.Process.Start("custom.xls"); } catch (System.Exception e) { Console.WriteLine(e.Message); } }
static void Main(string[] args) { try { Book book = new BinBook(); Sheet sheet = book.addSheet("Sheet1"); sheet.writeStr(2, 1, "Hello, World !"); sheet.writeNum(3, 1, 1000); Format dateFormat = book.addFormat(); dateFormat.setNumFormat(NumFormat.NUMFORMAT_DATE); sheet.writeNum(4, 1, book.datePack(2008, 4, 29), dateFormat); sheet.setCol(1, 1, 12); book.save("example.xls"); System.Diagnostics.Process.Start("example.xls"); } catch (System.Exception e) { Console.WriteLine(e.Message); } }
static void Main(string[] args) { try { Book book = new BinBook(); Font boldFont = book.addFont(); boldFont.bold = true; Font titleFont = book.addFont(); titleFont.name = "Arial Black"; titleFont.size = 16; Format titleFormat = book.addFormat(); titleFormat.font = titleFont; Format headerFormat = book.addFormat(); headerFormat.alignH = AlignH.ALIGNH_CENTER; headerFormat.setBorder(BorderStyle.BORDERSTYLE_THIN); headerFormat.font = boldFont; headerFormat.fillPattern = FillPattern.FILLPATTERN_SOLID; headerFormat.patternForegroundColor = Color.COLOR_TAN; Format descriptionFormat = book.addFormat(); descriptionFormat.borderLeft = BorderStyle.BORDERSTYLE_THIN; Format amountFormat = book.addFormat(); amountFormat.setNumFormat(NumFormat.NUMFORMAT_CURRENCY_NEGBRA); amountFormat.borderLeft = BorderStyle.BORDERSTYLE_THIN; amountFormat.borderRight = BorderStyle.BORDERSTYLE_THIN; Format totalLabelFormat = book.addFormat(); totalLabelFormat.borderTop = BorderStyle.BORDERSTYLE_THIN; totalLabelFormat.alignH = AlignH.ALIGNH_RIGHT; totalLabelFormat.font = boldFont; Format totalFormat = book.addFormat(); totalFormat.setNumFormat(NumFormat.NUMFORMAT_CURRENCY_NEGBRA); totalFormat.setBorder(BorderStyle.BORDERSTYLE_THIN); totalFormat.font = boldFont; totalFormat.fillPattern = FillPattern.FILLPATTERN_SOLID; totalFormat.patternForegroundColor = Color.COLOR_YELLOW; Format signatureFormat = book.addFormat(); signatureFormat.alignH = AlignH.ALIGNH_CENTER; signatureFormat.borderTop = BorderStyle.BORDERSTYLE_THIN; Sheet sheet = book.addSheet("Invoice"); sheet.writeStr(2, 1, "Invoice No. 3568", titleFormat); sheet.writeStr(4, 1, "Name: John Smith"); sheet.writeStr(5, 1, "Address: San Ramon, CA 94583 USA"); sheet.writeStr(7, 1, "Description", headerFormat); sheet.writeStr(7, 2, "Amount", headerFormat); sheet.writeStr(8, 1, "Ball-Point Pens", descriptionFormat); sheet.writeNum(8, 2, 85, amountFormat); sheet.writeStr(9, 1, "T-Shirts", descriptionFormat); sheet.writeNum(9, 2, 150, amountFormat); sheet.writeStr(10, 1, "Tea cups", descriptionFormat); sheet.writeNum(10, 2, 45, amountFormat); sheet.writeStr(11, 1, "Total:", totalLabelFormat); sheet.writeNum(11, 2, 280, totalFormat); sheet.writeStr(14, 2, "Signature", signatureFormat); sheet.setCol(1, 1, 40); sheet.setCol(2, 2, 15); book.save("invoice.xls"); System.Diagnostics.Process.Start("invoice.xls"); } catch (System.Exception e) { Console.WriteLine(e.Message); } }