public Worksheet DoExport(RevisionAct act) { _worksheet = new Worksheet("Акт сверки"); _worksheet.Cells.ColumnWidth[0] = (ushort)2.5 * 256; _worksheet.Cells.ColumnWidth[1] = (ushort)23 * 256; _worksheet.Cells.ColumnWidth[2] = (ushort)7 * 256; _worksheet.Cells.ColumnWidth[3] = (ushort)7 * 256; _worksheet.Cells.ColumnWidth[4] = (ushort)2.5 * 256; _worksheet.Cells.ColumnWidth[5] = (ushort)23 * 256; _worksheet.Cells.ColumnWidth[6] = (ushort)7 * 256; _worksheet.Cells.ColumnWidth[7] = (ushort)7 * 256; var h1 = new CellStyle { Font = new Font("Arial", 11) { Bold = true }, HorizontalAlignment = HorizontalAlignment.Center }; var h2 = new CellStyle { Font = new Font("Arial", 10) { Bold = true, }, Warp = true, }; var mark = new CellStyle { HorizontalAlignment = HorizontalAlignment.Center, Warp = true, }; var longWord = new CellStyle { Warp = true }; var underScrore = new CellStyle { Borders = new Borders { Bottom = BorderStyle.Thin } }; var table = new CellStyle { Font = new Font("Arial", 8), Borders = Borders.Box(BorderStyle.Thin), }; Row(h1, "Акт сверки", new Merge(8)); var row = Row(mark, String.Format("взаимных расчетов по состоянию на {0} между {1} и {2} по договору № {3}", act.EndDate.ToShortDateString(), act.Payer.Recipient.FullName, act.Payer.JuridicalName, act.Payer.Id), new Merge(8)); row.Height = 1440 / 72 * 43; row = Row(longWord, String.Format("Мы, нижеподписавшиеся, __________________ {0} _________________________," + "с одной стороны, и ________________________ {1} __________________________, " + "с другой стороны составили настоящий акт сверки в том, что состояние взаимных расчетов по данным учета следующее:", act.Payer.Recipient.FullName, act.Payer.JuridicalName), new Merge(8)); row.Height = 1440 / 72 * 62; Row(table, String.Format("По данным {0}, руб.", act.Payer.Recipient.FullName), new Merge(4), String.Format("По данным {0}, руб.", act.Payer.JuridicalName), new Merge(4)); Row(table, "№ п/п", "Наименование операции, документы", "Дебет", "Кредит", "№ п/п", "Наименование операции, документы", "Дебет", "Кредит"); var index = 1; foreach (var move in act.Movements) { Row(table, index, move.Name, move.Debit.ToString("#.#"), move.Credit.ToString("#.#"), "", "", "", ""); index++; } Skip(); Row(String.Format("По данным {0}", act.Payer.Recipient.FullName), new Merge(4)); row = Row(h2, act.Result, new Merge(4)); row.Height = 1440 / 72 * 29; Skip(); Row(String.Format("От {0}", act.Payer.Recipient.FullName), new Merge(4), String.Format("От {0}", act.Payer.JuridicalName), new Merge(4)); Skip(2); Row("", underScrore, "", underScrore, String.Format("({0})", act.Payer.Recipient.Boss), "", "", underScrore, "", underScrore, "", ""); Skip(); Row("М.П.", "", "", "", "М.П.", "", "", ""); _worksheet.Cells[0, 0] = new Cell("Акт сверки") { Style = h1 }; return(_worksheet); }
public static Worksheet Export(RevisionAct act) { return(new Exporter().DoExport(act)); }