/// <summary> /// 创建表,用来展示平面图(Plan)的表。 /// </summary> /// <returns></returns> public static Table PlanTable(DocX document, int CompanyID, int parcelId, int buildingId, List <string> lstStr) { Table t = null; int i = 0; try { if (lstStr.Count == 0) { t = document.AddTable(1, 1); } else { t = document.AddTable(lstStr.Count, 1); foreach (string s in lstStr) { Picture p = picture.picHelper.getPic(document, PathManager.getSingleton().GetPlanpicPath(buildingId, s, false), 287, 670); if (p == null) { continue; } t.Rows[i].Cells[0].Paragraphs.First().AppendPicture(p).AppendLine(s).FontSize(16).Bold().Alignment = Alignment.center; t.Rows[i].Cells[0].VerticalAlignment = VerticalAlignment.Center; t.Rows[i++].Cells[0].Width = 23.27; } } } catch (System.Exception ex) { LogHelper.WriteLog(typeof(tableHelper), ex); } return(t); }
public static void CreateTestReport(Patient patient, MedicalTest test, string file_path) { if (file_path == null) { return; } Type test_type = test.GetType(); using (DocX document = DocX.Create(file_path)) { Novacode.Paragraph header = document.InsertParagraph( //selected_procedure.ProcedureType.First().ToString().ToUpper() + String.Join("", selected_procedure.ProcedureType.Skip(1)).ToLower(), test_type.GetCustomAttribute <DisplayNameAttribute>().DisplayName, false, new Formatting() { FontFamily = new System.Drawing.FontFamily("Times New Roman"), Size = 16D } ); header.Alignment = Alignment.center; header.Bold(); document.InsertParagraph(" "); Novacode.Table patient_info = document.AddTable(5, 2); patient_info.Rows[0].Cells[0].Paragraphs.First().Append("ФИО пациента").Bold(); patient_info.Rows[0].Cells[1].Paragraphs.First().Append(patient.LastName + " " + patient.FirstName + " " + patient.Patronym); patient_info.Rows[1].Cells[0].Paragraphs.First().Append("Пол").Bold(); patient_info.Rows[1].Cells[1].Paragraphs.First().Append(patient.Sex == Sex.мужской ? "мужской" : "женский"); patient_info.Rows[2].Cells[0].Paragraphs.First().Append("Дата рождения").Bold(); patient_info.Rows[2].Cells[1].Paragraphs.First().Append(patient.Birthdate.ToShortDateString()); patient_info.Rows[3].Cells[0].Paragraphs.First().Append("Адрес проживания").Bold(); patient_info.Rows[3].Cells[1].Paragraphs.First().Append( patient.PostIndex + ", " + patient.Country + ", " + patient.Region + ", " + patient.City + ", " + patient.Address ); patient_info.Rows[4].Cells[0].Paragraphs.First().Append("Номер карты").Bold(); patient_info.Rows[4].Cells[1].Paragraphs.First().Append(patient.CardNumber.ToString()); patient_info.Alignment = Alignment.left; patient_info.AutoFit = AutoFit.Window; PropertyInfo[] indicators = test_type.GetProperties().Where(x => x.IsDefined(typeof(TestInfo))).ToArray(); Novacode.Table test_info = document.AddTable(indicators.Count(), 2); int k = 0; foreach (var indicator in indicators) { test_info.Rows[k].Cells[0].Paragraphs.First().Append(indicator.GetCustomAttribute <TestInfo>().DisplayName); object property_value = indicator.GetValue(test); test_info.Rows[k].Cells[1].Paragraphs.First().Append(property_value != null ? property_value.ToString() : ""); k++; } test_info.Alignment = Alignment.left; test_info.AutoFit = AutoFit.Window; document.InsertTable(patient_info); document.InsertParagraph(" "); document.InsertTable(test_info); document.Save(); } }
/// <summary> /// Initialize Word Report --> Support Method /// </summary> public static void InsertSummaryResults() { try { Table table = resultSummarydocument.AddTable(1, 4); // Specify some properties for this Table. table.Alignment = Alignment.left; table.AutoFit = AutoFit.Contents; table.Design = TableDesign.TableGrid; table.SetColumnWidth(0, 667.87); table.SetColumnWidth(1, 5347.87); table.SetColumnWidth(2, 1255.87); table.SetColumnWidth(3, 1825.82); table.Rows[0].Cells[0].Paragraphs.First().Append(smrw.ToString() + "."); smrw += 1; table.Rows[0].Cells[1].Paragraphs.First().Append(BaseUtilities.scenarioName); switch (BaseUtilities.scenarioStatus.ToLower()) { case "pass": table.Rows[0].Cells[2].Paragraphs.First().Append("Pass").Color(System.Drawing.Color.FromArgb(52, 168, 83)); break; case "fail": table.Rows[0].Cells[2].Paragraphs.First().Append("Fail").Color(System.Drawing.Color.FromArgb(234, 67, 53)); break; case "skip": table.Rows[0].Cells[2].Paragraphs.First().Append("Skip").Color(System.Drawing.Color.FromArgb(234, 67, 53)); break; } Hyperlink link = resultSummarydocument.AddHyperlink("Click here", new Uri(reportpath)); table.Rows[0].Cells[3].Paragraphs.First().AppendHyperlink(link).Color(System.Drawing.Color.FromArgb(1, 91, 168)); resultSummarydocument.InsertTable(table); resultSummarydocument.Save(); } catch (Exception e) { Reports.SetupErrorLog(e); } }
private void FillPurchases(DocX doc) { IEnumerable <LBCFUBL_WCF.DBO.Purchase> purchases = Helper .GetPurchaseClient() .GetPurchases() .OrderBy(x => x.date) .OrderBy(x => x.login) .ThenBy(x => x.Product.name) .Where(x => x.date >= from && x.date <= to); Novacode.Table table = doc.AddTable(purchases.Count() + 1, 4); setTableStyle(table); table.Rows[0].Cells[0].InsertParagraph().Append("Login").Bold(); table.Rows[0].Cells[1].InsertParagraph().Append("Date").Bold(); table.Rows[0].Cells[2].InsertParagraph().Append("Produit").Bold(); table.Rows[0].Cells[3].InsertParagraph().Append("Prix").Bold(); int i = 1; foreach (LBCFUBL_WCF.DBO.Purchase purchase in purchases) { table.Rows[i].Cells[0].InsertParagraph().Append(purchase.login); table.Rows[i].Cells[1].InsertParagraph().Append(purchase.date.ToString("dd-MM-yyyy hh:mm")); table.Rows[i].Cells[2].InsertParagraph().Append(purchase.Product.name); table.Rows[i].Cells[3].InsertParagraph().Append(currency(purchase.Product.cost_with_margin)); i++; } doc.InsertTable(table); }
private void FillAccounts(DocX doc) { IEnumerable <LBCFUBL_WCF.DBO.Account> accounts = Helper .GetAccountClient() .GetAccounts() .OrderBy(x => x.login) .Where(x => x.date >= from && x.date <= to); Novacode.Table table = doc.AddTable(accounts.Count() + 1, 3); setTableStyle(table); table.Rows[0].Cells[0].InsertParagraph().Append("Login").Bold(); table.Rows[0].Cells[1].InsertParagraph().Append("Date").Bold(); table.Rows[0].Cells[2].InsertParagraph().Append("Argent").Bold(); int i = 1; foreach (LBCFUBL_WCF.DBO.Account account in accounts) { table.Rows[i].Cells[0].InsertParagraph().Append(account.login); table.Rows[i].Cells[1].InsertParagraph().Append(account.date.ToString("dd-MM-yyyy hh:mm")); table.Rows[i].Cells[2].InsertParagraph().Append(currency(account.argent)); i++; } doc.InsertTable(table); }
public void TableWithMultipleMergeRight() { using (var doc = new DocX()) { doc.Create(); var table = doc.AddTable(9); var row = table.AddRow(); row.HeaderRow = true; for (int i = 0; i < 9; i++) { row.Cells[i].SetBoldText((i + 1).ToString()); } row = table.AddRow(); row.HeaderRow = true; // this should merge cells 2, 3 and 4 row.Cells[1].MergeRight = 2; // this should merge cells 5 and 6 row.Cells[4].MergeRight = 1; row.SetBoldText(1, "Test1", Align.Center); row.SetBoldText(4, "Test2", Align.Center); row.Underline(1, 4); Validate(doc); doc.Close(); } }
public void TableWithHeaderRow() { using (var doc = new DocX()) { doc.Create(); var table = doc.AddTable(5); for (int i = 0; i < 50; i++) { var row = table.AddRow(); row.SetBorders(Units.HalfPt, BorderValue.Single); if (i == 0) { // shade the first row and set as a header row.SetShading("E7E6E6"); row.HeaderRow = true; } for (int j = 0; j < 5; j++) { row.Cells[j].Paragraphs[0].Append($"Cell {(j + 1)}"); } } Validate(doc); doc.Close(); } }
public void TableWidthsTwips() { using (var doc = new DocX()) { doc.Create(); var col1 = Units.InchToTwips(3.9).ToString(); var col2 = Units.InchToTwips(1.3).ToString(); var table = doc.AddTable(3, col1, col2, col2); for (int i = 0; i < 3; i++) { var row = table.AddRow(); row.SetBorders(Units.HalfPt, BorderValue.Single); if (i == 0) { row.SetShading(ShadingPattern.Clear, "E7E6E6"); row.HeaderRow = true; } for (int j = 0; j < 3; j++) { row.Cells[j].Paragraphs[0].Append($"Cell {(j + 1)}"); } } Validate(doc); doc.Close(); } }
public void TableWidthsCM() { using (var doc = new DocX()) { doc.Create(); var table = doc.AddTable(3, "9.906cm", "3.302cm", "3.302cm"); for (int i = 0; i < 3; i++) { var row = table.AddRow(); row.SetBorders(Units.HalfPt, BorderValue.Single); if (i == 0) { row.SetShading(ShadingPattern.Clear, "E7E6E6"); row.HeaderRow = true; } for (int j = 0; j < 3; j++) { row.Cells[j].Paragraphs[0].Append($"Cell {(j + 1)}"); } } Validate(doc); doc.Close(); } }
private void ExportarDgvAWord(DataGridView dgv, string filename) { //Creamos el Word DocX miWord = DocX.Create(filename); //Creamos la tabla //Le sumo + 1 para adicionarle el encabezado Table miTabla = miWord.AddTable(dgv.RowCount + 1, dgv.ColumnCount); miWord.InsertParagraph("Hello Word"); for (int fila = -1; fila < dgv.RowCount; fila++) { for (int col = 0; col < dgv.ColumnCount; col++) { if (fila == -1) //Es encabezado { //Mediante Bold() cambio a negrita toda la fila miTabla.Rows[0].Cells[col].Paragraphs.First().Append(dgv.Columns[col].HeaderText).Bold(); } else //Es otra fila { miTabla.Rows[fila + 1].Cells[col].Paragraphs.First().Append(dgv.Rows[fila].Cells[col].Value.ToString()); } } } miWord.InsertTable(miTabla); miWord.Save(); }
private void AddTable(CalculationResult calculationResult) { PageBreak(); var value = $@"Расчетный состав для {MainWindowViewModel.Instance.Calculation.CountConcrete} м³"; AddTitle(value); var table = _document.AddTable(5, 2); table.Design = TableDesign.TableGrid; table.Alignment = Alignment.center; table.SetColumnWidth(0, 5024); table.SetColumnWidth(1, 5024); table.Rows[0].Cells[0].Paragraphs[0].Append("Цемент").Font(_fontFamily.Source).FontSize(_fontSizeText); table.Rows[0].Cells[1].Paragraphs[0].Append($@"{calculationResult.CorrectedCementConsumption * MainWindowViewModel.Instance.Calculation.CountConcrete: .##} кг.").Font(_fontFamily.Source).FontSize(_fontSizeText); table.Rows[1].Cells[0].Paragraphs[0].Append("Вода").Font(_fontFamily.Source).FontSize(_fontSizeText); table.Rows[1].Cells[1].Paragraphs[0].Append($@"{calculationResult.WaterFlowWithRegardToAirContent * MainWindowViewModel.Instance.Calculation.CountConcrete: .##} л.").Font(_fontFamily.Source).FontSize(_fontSizeText); table.Rows[2].Cells[0].Paragraphs[0].Append("Песок").Font(_fontFamily.Source).FontSize(_fontSizeText); table.Rows[2].Cells[1].Paragraphs[0].Append($@"{calculationResult.TheAmountOfSandDry * MainWindowViewModel.Instance.Calculation.CountConcrete: .##} кг.").Font(_fontFamily.Source).FontSize(_fontSizeText); table.Rows[3].Cells[0].Paragraphs[0].Append("Крупный заполнитель").Font(_fontFamily.Source).FontSize(_fontSizeText); table.Rows[3].Cells[1].Paragraphs[0].Append($@"{calculationResult.NumberOfCoarseAggregate * MainWindowViewModel.Instance.Calculation.CountConcrete: .##} кг.").Font(_fontFamily.Source).FontSize(_fontSizeText); table.Rows[4].Cells[0].Paragraphs[0].Append($@"Химическая добавка { MainWindowViewModel.Instance.Calculation.Admixtures.Name}").Font(_fontFamily.Source).FontSize(_fontSizeText); table.Rows[4].Cells[1].Paragraphs[0].Append($@"{calculationResult.ChemicalAdditive * MainWindowViewModel.Instance.Calculation.CountConcrete: .##} кг.").Font(_fontFamily.Source).FontSize(_fontSizeText); _document.InsertTable(table); }
private Table GenerateWordsTable(DocX document, IEnumerable <string> selectedWords) { var rowCount = (int)Math.Ceiling(selectedWords.Count() / 5.0); var table = document.AddTable(rowCount, 5); table.SetDirection(Direction.RightToLeft); int row = 0; int col = 0; foreach (var word in GetEncodedWords(selectedWords)) { table.Rows[row].Cells[col].Paragraphs[0].Append(word); col++; if (col == 5) { col = 0; row++; } } return(table); }
public ActionResult Aircrafts() { if (!User.Identity.IsAuthenticated) { return(Redirect("/Account/Login")); } IEnumerable <Base> bases = db.Bases; using (MemoryStream ms = new MemoryStream()) { DocX document = DocX.Create(ms); document.SetDefaultFont(new Xceed.Document.NET.Font("Times New Roman"), 12); document.MarginLeft = 85; document.MarginTop = 56.7f; document.MarginBottom = 56.7f; document.MarginRight = 42.5f; document.InsertParagraph("Розподілення яхт за портами\n").Bold().Alignment = Alignment.center; foreach (Base airbase in bases) { IEnumerable <Aircraft> aircrafts = db.Aircrafts.Include(m => m.Base).Where(m => m.BaseId == airbase.Id); if (aircrafts.Count() == 0) { continue; } document.InsertParagraph($"Індекс: {airbase.PostIndex}").Alignment = Alignment.center; document.InsertParagraph($"Місто: {airbase.City}").Alignment = Alignment.center; document.InsertParagraph($"Адреса: {airbase.Adress}").Alignment = Alignment.center; Table table = document.AddTable(aircrafts.Count() + 1, 6); table.Alignment = Alignment.center; table.Design = TableDesign.TableGrid; string[] names = { "Реєстраційний номер", "Виробник", "Модель", "Клас", "Рік виробництва", "Статус" }; for (int k = 0; k < names.Length; ++k) { table.Rows[0].Cells[k].Paragraphs[0].Append(names[k]).Bold().Alignment = Alignment.center; } int j = 0; foreach (Aircraft aircraft in aircrafts) { table.Rows[j + 1].Cells[0].Paragraphs[0].Append(aircraft.RegistrationNumber).Alignment = Alignment.center; table.Rows[j + 1].Cells[1].Paragraphs[0].Append(aircraft.Manufacturer).Alignment = Alignment.center; table.Rows[j + 1].Cells[2].Paragraphs[0].Append(aircraft.Model).Alignment = Alignment.center; table.Rows[j + 1].Cells[3].Paragraphs[0].Append(aircraft.Class).Alignment = Alignment.center; table.Rows[j + 1].Cells[4].Paragraphs[0].Append(aircraft.YearOfProduction.ToString()).Alignment = Alignment.center; table.Rows[j + 1].Cells[5].Paragraphs[0].Append(aircraft.Status).Alignment = Alignment.center; j++; } document.InsertParagraph().InsertTableAfterSelf(table); document.InsertParagraph(); } document.InsertParagraph($"\n\n\n Дата формування: {DateTime.Now}").Alignment = Alignment.right; document.Save(); Response.ContentType = "application/vnd.openxmlformats-officedocument.wordprocessingml.document"; Response.AddHeader("content-disposition", "attachment;filename=Aircrafts.docx"); Response.OutputStream.Write(ms.GetBuffer(), 0, ms.GetBuffer().Length); } return(null); }
private static Table CreateMainData(DocX doc, string documentType, Vendor vendor, Customer customer, Consumer consumer, DocumentData documentData, PaymentData paymentData) { var t = doc.AddTable(1, 2); t.SetWidthsPercentage(new[] { 50f, 50f }, doc.PageWidth); var border = new Border(); border.Tcbs = BorderStyle.Tcbs_none; for (int i = 0; i < 2; i++) { t.Rows[0].Cells[i].SetBorder(TableCellBorderType.Left, border); t.Rows[0].Cells[i].SetBorder(TableCellBorderType.Top, border); t.Rows[0].Cells[i].SetBorder(TableCellBorderType.Right, border); t.Rows[0].Cells[i].SetBorder(TableCellBorderType.Bottom, border); } GenerateVendorText(t.Rows[0].Cells[0], vendor); GenerateCustomerText(t.Rows[0].Cells[0], customer); if (consumer != null) { GenerateConsumerText(t.Rows[0].Cells[0], consumer); } GenerateDocumentDataText(t.Rows[0].Cells[1], documentData, documentType); GeneratePaymentDataText(t.Rows[0].Cells[1], paymentData); doc.InsertTable(t); return(t); }
private void экспортВWordToolStripMenuItem_Click(object sender, EventArgs e) { SaveFileDialog sfd = new SaveFileDialog(); sfd.AddExtension = true; sfd.Filter = "Word file (*.docx)|*.docx"; if (sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK && sfd.FileName != "") { if (Path.GetExtension(sfd.FileName) == ".docx") { DocX doc = DocX.Create(sfd.FileName); Paragraph p1 = doc.InsertParagraph(); p1.AppendLine("Подробный тепловой расчет ступеней паровой турбины").FontSize(14); p1.AppendLine(); Table t = doc.AddTable(j, 3); t.Alignment = Alignment.center; t.SetColumnWidth(0, 200); t.Rows[0].Cells[0].Paragraphs.First().Append("Величина").FontSize(12); t.Rows[0].Cells[1].Paragraphs.First().Append("Единица измерения").FontSize(12); t.Rows[0].Cells[2].Paragraphs.First().Append("Значение").FontSize(12); for (int i = 1; i < j; i++) { for (int k = 0; k < 3; k++) { t.Rows[i].Cells[k].Paragraphs.First().Append("" + (String)DB.Rows[i].Cells[k].Value); } } doc.InsertTable(t); doc.Save(); } } }
private void InsertExperiences(Resume resume, DocX doc) { // 3 experience doc.InsertParagraph().AppendLine(); doc.InsertParagraph(_localizationService.GetResource("Resume.Fields.Experiences", _workContext.Current.WorkingLanguage.Id), false, H2); //.AppendLine(line); foreach (var exp in resume.Experiences.OrderBy(x => x.DisplayOrder)) { // doc.InsertParagraph().AppendLine(); var table = doc.AddTable(5, 2); table.Design = TableDesign.TableNormal; table.AutoFit = AutoFit.Contents; InsertExperienceRow(doc, table, 0, "Resume.Fields.Experiences.Name", exp.GetLocalized(x => x.Name), H4); InsertExperienceRow(doc, table, 1, "Resume.Fields.Experiences.Period", exp.GetLocalized(x => x.Period)); InsertExperienceRow(doc, table, 2, "Resume.Fields.Experiences.Function", exp.GetLocalized(x => x.Function)); InsertExperienceRow(doc, table, 3, "Resume.Fields.Experiences.City", exp.GetLocalized(x => x.City)); InsertExperienceRow(doc, table, 4, "Resume.Fields.Experiences.Tasks", exp.GetLocalized(x => x.Tasks)); doc.InsertTable(table); //foreach (var p in exp.Projects) //{ // doc.InsertParagraph().AppendLine(); // doc.InsertParagraph(p.GetLocalized(x => x.Name), false, H4); // doc.InsertParagraph(p.GetLocalized(x => x.Description), false, Normal); // doc.InsertParagraph(p.GetLocalized(x => x.Technology), false, Normal); //} } }
private static Table CreateSignTable(DocX doc) { var t = doc.AddTable(1, 2); t.SetWidthsPercentage(new[] { 50f, 50f }, doc.PageWidth); var border = new Border(); border.Tcbs = BorderStyle.Tcbs_none; var formattingBold = new Formatting { Bold = true, Size = DefaultSize, FontFamily = Font }; var formattingWithoutBold = new Formatting { Bold = false, Size = DefaultSize, FontFamily = Font }; for (int i = 0; i < 2; i++) { t.Rows[0].Cells[i].SetBorder(TableCellBorderType.Left, border); t.Rows[0].Cells[i].SetBorder(TableCellBorderType.Top, border); t.Rows[0].Cells[i].SetBorder(TableCellBorderType.Right, border); t.Rows[0].Cells[i].SetBorder(TableCellBorderType.Bottom, border); } var p = t.Rows[0].Cells[0].Paragraphs.First().Append($"........................................................................\r\n{Resource.customerSign}", formattingWithoutBold); p.Alignment = Alignment.center; p = t.Rows[0].Cells[1].Paragraphs.First().Append($"........................................................................\r\n{Resource.vendorSign}", formattingWithoutBold); p.Alignment = Alignment.center; doc.InsertTable(t); return(t); }
/// <summary> /// Crea la tabla de recursos valiosos /// </summary> /// <param name="doc"></param> /// <param name="empresa"></param> private void insertarRecursosValiosos(DocX doc, Empresa empresa) { List <RecursoValioso> listadoRecursoValioso = MatrizBO.ConsultarRecursosValiosos(empresa.IdEmpresa); int cantidadRecursos = listadoRecursoValioso.Count; var RVParrafo = new Novacode.Formatting(); RVParrafo.FontFamily = new System.Drawing.FontFamily("Calibri"); RVParrafo.Size = 12D; RVParrafo.Position = 3; Paragraph pParr = doc.InsertParagraph("En este sentido se identifican " + cantidadRecursos + " recursos por encima del promedio, los cuales se convierten en valiosos y se listan a continuación", false, RVParrafo); pParr.Alignment = Alignment.left; Table tab = doc.AddTable(cantidadRecursos + 1, 2); tab.AutoFit = AutoFit.Contents; tab.Alignment = Alignment.center; tab.Design = TableDesign.ColorfulGridAccent1; tab.Rows[0].Cells[0].Paragraphs.First().Append("Recurso Valioso"); tab.Rows[0].Cells[0].Paragraphs.First().Alignment = Alignment.center; tab.Rows[0].Cells[0].Paragraphs.First().Bold(); tab.Rows[0].Cells[1].Paragraphs.First().Append("Observaciones"); tab.Rows[0].Cells[1].Paragraphs.First().Alignment = Alignment.center; tab.Rows[0].Cells[1].Paragraphs.First().Bold(); for (int i = 0; i < cantidadRecursos; i++) { RecursoValioso recursoValioso = listadoRecursoValioso[i]; tab.Rows[i + 1].Cells[0].Paragraphs.First().Append(recursoValioso.NombreRecurso); } doc.InsertTable(tab); }
private DocX outputDoc(string nowBalance, string nowSum, string nowBalanceAfterBuy, string nowBonus) { string pathDocument = "C:\\Users\\oobit\\Desktop\\first.docx"; DocX document = DocX.Create(pathDocument); document.MarginLeft = 60.0f; document.MarginRight = 60.0f; document.MarginTop = 60.0f; document.MarginBottom = 60.0f; document.InsertParagraph("Чек покупки").Bold().Font("Times New Roman").FontSize(14); Table table = document.AddTable(4, 2); table.Alignment = Alignment.center; table.Design = TableDesign.TableGrid; table.SetWidths(new float[] { 180.0f, 600.0f }); table.Rows[0].Cells[0].Paragraphs[0].Append("Баланс до покупки").Font("Times New Roman").FontSize(12).Bold(); table.Rows[0].Cells[1].Paragraphs[0].Append(nowBalance).Font("Times New Roman").FontSize(12); table.Rows[1].Cells[0].Paragraphs[0].Append("Сумма").Font("Times New Roman").FontSize(12).Bold(); table.Rows[1].Cells[1].Paragraphs[0].Append(nowSum).Font("Times New Roman").FontSize(12); table.Rows[2].Cells[0].Paragraphs[0].Append("Баланс после покупки").Font("Times New Roman").FontSize(12).Bold(); table.Rows[2].Cells[1].Paragraphs[0].Append(nowBalanceAfterBuy).Font("Times New Roman").FontSize(12); table.Rows[3].Cells[0].Paragraphs[0].Append("Текущее количество бонусов").Font("Times New Roman").FontSize(12).Bold(); table.Rows[3].Cells[1].Paragraphs[0].Append(nowBonus).Font("Times New Roman").FontSize(12); document.InsertParagraph().InsertTableAfterSelf(table); document.Save(); return(document); }
/// <summary> /// 创建市公司的组织结构表 /// </summary> /// <param name="document"></param> /// <param name="childCompanies"></param> /// <param name="picPath"></param> /// <returns></returns> public static Table organizationTable(DocX document, List <Companymodel> childCompanies, string picPath) { if (childCompanies.Count == 0) { return(null); } Table t = document.AddTable(childCompanies.Count + 1, 2); int i = 0; foreach (Companymodel cm in childCompanies) { if (i % 2 == 0) { t.Rows[i].Cells[0].FillColor = Color.Blue; } else { t.Rows[i].Cells[0].FillColor = Color.LightBlue; } t.Rows[i].Cells[0].Paragraphs.First().Append(cm.name).FontSize(15).Bold().Alignment = Alignment.center; t.Rows[i++].Cells[0].VerticalAlignment = VerticalAlignment.Center; } t.MergeCellsInColumn(1, 0, childCompanies.Count); Picture p = picture.picHelper.getPic(document, picPath, 728, 525); if (p != null) { t.Rows[0].Cells[1].Paragraphs.First().AppendPicture(p).Alignment = Alignment.center;//插入组织结构图 t.Rows[0].Cells[1].VerticalAlignment = VerticalAlignment.Center; } return(t); }
/// <summary> /// 添加用于放置鸟瞰图的表格 /// </summary> /// <param name="document"></param> /// <param name="p_Orth"></param> /// <param name="p_front"></param> /// <param name="p_rear"></param> /// <param name="p_left"></param> /// <param name="p_right"></param> /// <returns></returns> public static Table AerialviewpicTable(DocX document, Picture p_Orth, Picture p_front, Picture p_rear, Picture p_left, Picture p_right) { Table t = null; try { t = document.AddTable(3, 2); t.Rows[0].Cells[0].Paragraphs.First().AppendPicture(p_Orth).Alignment = Alignment.center; //正射 t.Rows[0].Cells[1].Paragraphs.First().AppendPicture(p_front).Alignment = Alignment.center; //前 t.Rows[1].Cells[0].Paragraphs.First().AppendPicture(p_rear).Alignment = Alignment.center; //后 t.Rows[1].Cells[1].Paragraphs.First().AppendPicture(p_left).Alignment = Alignment.center; //左 t.Rows[2].Cells[0].Paragraphs.First().AppendPicture(p_right).Alignment = Alignment.center; //右 t.Rows[0].Cells[0].VerticalAlignment = VerticalAlignment.Center; t.Rows[0].Cells[1].VerticalAlignment = VerticalAlignment.Center; t.Rows[1].Cells[0].VerticalAlignment = VerticalAlignment.Center; t.Rows[1].Cells[1].VerticalAlignment = VerticalAlignment.Center; t.Rows[2].Cells[0].VerticalAlignment = VerticalAlignment.Center; } catch (System.Exception ex) { LogHelper.WriteLog(typeof(tableHelper), ex); } return(t); }
/// <summary> /// 创建“省公司”的企业用房分析表(前两行) /// </summary> /// <param name="document"></param> /// <returns></returns> public static Table Template_province_analysis(DocX document) { Table t = null; try { t = document.AddTable(2, 4); #region "前两行" t.Rows[0].Cells[0].Paragraphs.First().Append("序号").Bold().Alignment = Alignment.center; t.Rows[0].Cells[1].Paragraphs.First().Append("单位").Bold().Alignment = Alignment.center; t.Rows[0].Cells[2].Paragraphs.First().Append("统计项目名称").Bold().Alignment = Alignment.center; t.Rows[0].Cells[3].Paragraphs.First().Append("建筑面积(m2)").Bold().Alignment = Alignment.center; t.Rows[0].Cells[0].VerticalAlignment = VerticalAlignment.Center; t.Rows[0].Cells[1].VerticalAlignment = VerticalAlignment.Center; t.Rows[0].Cells[2].VerticalAlignment = VerticalAlignment.Center; t.Rows[0].Cells[3].VerticalAlignment = VerticalAlignment.Center; #endregion } catch (System.Exception ex) { LogHelper.WriteLog(typeof(tableHelper), ex); } return(t); }
public static void GerarTabelaAreaDeEstagio(this DocX document, List <AreaEstagioCurso> areas, int IdArea) { int rows = areas.Count(); Table t = document.AddTable(rows, 2); Formatting format = new Formatting(); format.Bold = true; t.Paragraphs.ForEach(x => x.FontSize(12)); t.Paragraphs.ForEach(x => x.Font("Arial")); t.Alignment = Alignment.center; t.AutoFit = AutoFit.ColumnWidth; for (int i = 0; i <= (int)TableBorderType.InsideV; i++) { t.SetBorder((TableBorderType)i, new Border()); } for (int i = 1; i <= rows; i++) { int pos = i - 1; if (i % 7 == 0) { document.InsertSectionPageBreak(); } t.Rows[pos].Cells[1].Paragraphs[0].InsertText(areas[pos].Nome); if (areas[pos].Identificador == IdArea) { t.Rows[pos].Cells[0].Paragraphs[0].InsertText("X", false, format); } } document.InsertTable(t); }
private void button13_Click(object sender, EventArgs e) { SaveFileDialog sfd = new SaveFileDialog(); sfd.AddExtension = true; sfd.Filter = "Word file (*.docx)|*.docx"; if (sfd.ShowDialog() == DialogResult.OK && sfd.FileName != "") { if (Path.GetExtension(sfd.FileName) == ".docx") { DocX doc = DocX.Create(sfd.FileName); Paragraph p1 = doc.InsertParagraph(); p1.AppendLine("Итоговые результаты расчета").FontSize(14); p1.AppendLine(); Table t = doc.AddTable(P.Z + 2, 5); t.Alignment = Alignment.center; t.Rows[0].Cells[0].Paragraphs.First().Append("№ ступени:").FontSize(12); t.Rows[0].Cells[1].Paragraphs.First().Append("H0, кДж / кг").FontSize(12); t.Rows[0].Cells[2].Paragraphs.First().Append("G, кг/с").FontSize(12); t.Rows[0].Cells[3].Paragraphs.First().Append("\u03b7oi").FontSize(12); t.Rows[0].Cells[4].Paragraphs.First().Append("N, МВт").FontSize(12); for (int i = 0; i <= P.Z; i++) { for (int k = 0; k < 5; k++) { t.Rows[i + 1].Cells[k].Paragraphs.First().Append("" + (String)dataGridView1.Rows[i].Cells[k].Value); } } doc.InsertTable(t); doc.Save(); } } }
// Create Issue Description doc for Evidence (SIT) public void CreateXLSX() { string fp = filepath; fp += release + " – Evidence.docx"; using (DocX document = DocX.Create(@fp)) { // Add document info string title = release + " – Evidence"; document.InsertParagraph(title).FontSize(15d).Bold().SpacingAfter(50d).Alignment = Alignment.center; // Add a Table into the document and sets its values var t1 = document.AddTable(test_names.Count, 2); t1.Design = TableDesign.TableGrid; t1.Alignment = Alignment.center; t1.Rows[0].Cells[0].FillColor = Color.LightGray; t1.Rows[0].Cells[1].FillColor = Color.LightGray; for (int i = 0; i < test_names.Count; i++) { if (i == 0) { t1.Rows[i].Cells[0].Paragraphs[0].Append(test_names[i]).FontSize(10d).Bold().SpacingBefore(5d).SpacingAfter(5d).Alignment = Alignment.center; t1.Rows[i].Cells[1].Paragraphs[0].Append(test_descriptions[i]).FontSize(10d).Bold().SpacingBefore(5d).SpacingAfter(5d).Alignment = Alignment.center; } else { t1.Rows[i].Cells[0].Paragraphs[0].Append(test_names[i]).FontSize(8d).KeepLinesTogether(true); t1.Rows[i].Cells[1].Paragraphs[0].Append(test_descriptions[i]).FontSize(8d).KeepLinesTogether(true); } } t1.AutoFit = AutoFit.Contents; document.InsertTable(t1); Paragraph p = document.InsertParagraph("\n"); // Create new table where .zip is embedded var t2 = document.AddTable(2, 1); t2.Design = TableDesign.TableGrid; t2.Alignment = Alignment.center; t2.Rows[0].Cells[0].FillColor = Color.LightGray; t2.Rows[0].Cells[0].Paragraphs[0].Append("Before/After Evidence").FontSize(10d).Bold().SpacingBefore(5d).SpacingAfter(5d).Alignment = Alignment.center; t2.Rows[1].Cells[0].Paragraphs[0].FontSize(8d).Alignment = Alignment.center; document.InsertTable(t2); document.Save(); } }
private void toolStripMenuItem3_Click(object sender, EventArgs e) { saveFileDialog1.FileName = "report"; if (saveFileDialog1.ShowDialog() == DialogResult.Cancel) { return; } var conn = new MySqlConnection(Data.connString); conn.Open(); var currentDate = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); var monthAgoDate = DateTime.Now.AddMonths(-1).ToString("yyyy-MM-dd hh:mm:ss"); DocX document = DocX.Create(saveFileDialog1.FileName); document.InsertParagraph("Отчет").Font("Times New Roman").FontSize(18) .Alignment = Alignment.center; document.InsertParagraph(); var countSuccesses = conn.QueryFirst <string> ( $"select count(*) from link_archive where created between '{monthAgoDate}' and '{currentDate}'"); document.InsertParagraph($"За последний месяц было создано {countSuccesses} пар"); document.InsertParagraph(); var couplesList = conn.Query <forMeeting> ( $"select concat_ws(' ', A.firstname, A.lastname) as first_person, concat_ws(' ', B.firstname, B.lastname) as second_person from link_archive\njoin archive_person as A on A.id = link_archive.firstP_id\njoin archive_person as B on B.id = link_archive.secondP_id\nwhere created between '{monthAgoDate}' and '{currentDate}'").ToList(); Table couplesTable = document.AddTable(couplesList.Count + 1, 2); couplesTable.Alignment = Alignment.both; couplesTable.AutoFit = AutoFit.ColumnWidth; couplesTable.SetWidthsPercentage(new[] { 50.0f, 50.0f }); couplesTable.Design = TableDesign.TableGrid; couplesTable.Rows[0].Cells[0].Paragraphs[0].Append("Первый партнер"); couplesTable.Rows[0].Cells[1].Paragraphs[0].Append("Второй партнер"); for (int i = 0; i < couplesList.Count; i++) { couplesTable.Rows[i + 1].Cells[0].Paragraphs[0].Append(couplesList[i].first_person); couplesTable.Rows[i + 1].Cells[1].Paragraphs[0].Append(couplesList[i].second_person); } document.InsertTable(couplesTable); document.InsertParagraph(); var declinedCount = conn.QueryFirst <string> ($"select count(*) from archive_person\nwhere archive_person.id not in (select id from person) and archive_person.id not in (select firstP_id from link_archive where created between '{monthAgoDate}' and '{currentDate}') and archive_person.id not in (select secondP_id from link_archive where created between '{monthAgoDate}' and '{currentDate}')"); document.InsertParagraph($"От услуг отказалось {declinedCount} клиентов"); document.Save(); conn.Close(); Process.Start(saveFileDialog1.FileName); }
private void button1_Click(object sender, EventArgs e) { //创建文档 using (DocX document = DocX.Create(@"HelloWorld.docx")) { //插入段落 Paragraph p = document.InsertParagraph(); //段落加入文本,定义格式 p.Append("Hello World!") //内容 .Font(new Xceed.Words.NET.Font("宋体")) //字体格式 .FontSize(20) //字体大小 .Color(Color.Blue) //字体颜色 .Bold() .Alignment = Alignment.center; //字体对其方式 p = document.InsertParagraph(); //创建段落 p.Append("CHINA") .Font(new Xceed.Words.NET.Font("微软雅黑")) .FontSize(18) .Color(Color.Red); //插入表格4x4,使用addtable后再inserttable var table1 = document.AddTable(9, 4); table1.Design = TableDesign.TableGrid; for (int i = 0; i < 9; i++) { for (int k = 0; k < 4; k++) { table1.Rows[i].Cells[k].Paragraphs.First().InsertText(string.Format("第{0}行,第{1}列", i, k)); } } //合并单元格 table1.MergeCellsInColumn(0, 0, 1); //////水平合并(合并第1行的第1、2个单元格) //table1.ApplyHorizontalMerge(0, 0, 1); //table1.Rows[0].Cells[0].Paragraphs[0].ChildObjects.Add(table.Rows[0].Cells[1].Paragraphs[0].ChildObjects[0]); ////垂直合并(合并第1列的第3、4个单元格) //table.ApplyVerticalMerge(0,2, 3); //table.Rows[2].Cells[0].Paragraphs[0].ChildObjects.Add(table.Rows[3].Cells[0].Paragraphs[0].ChildObjects[0]); document.InsertTable(table1); //追加行 document.Tables[0].InsertRow().Cells[1].Paragraphs.First().InsertText("新添11加的行"); //插入图片 p = document.InsertParagraph(); Xceed.Words.NET.Image image = document.AddImage(@"1.jpg"); Picture pic = image.CreatePicture(); p.InsertPicture(pic); p.Alignment = Alignment.right; //保存文档 document.Save(); } MessageBox.Show("Done!"); }
public static void AppendTabelaCarimbo(this DocX document) { Table t = document.AddTable(1, 1); t.Design = TableDesign.TableNormal; t.Alignment = Alignment.center; t.Rows[0].Cells[0].InsertParagraph("Carimbo do CNPJ").SpacingBefore(10d).SpacingAfter(25d); }
public void ThreeByThreeTable() { using (var doc = new DocX()) { doc.Create(); var table = doc.AddTable(3); var row = table.AddRow(); row.HeaderRow = true; row.Cells[0].Paragraphs[0].Append("Cell 1"); row.Cells[1].Paragraphs[0].Append("Cell 2").SetAlignment(Align.Center); row.Cells[2].Paragraphs[0].Append("Cell 3").SetAlignment(Align.Right); row.Cells[0].Borders.Set(Units.HalfPt, BorderValue.Single); row.SetShading(ShadingPattern.Clear, "E7E6E6"); row = table.AddRow(); row.SetBorders(Units.HalfPt, BorderValue.Single); row.Cells[0].Paragraphs[0].Append("Cell 1"); row.Cells[1].Paragraphs[0].Append("Cell 2").SetAlignment(Align.Center); row.Cells[2].Paragraphs[0].Append("Cell 3").SetAlignment(Align.Right); row = table.AddRow(); row.Cells[0].Paragraphs[0].Append("Cell 1"); row.Cells[1].Paragraphs[0].Append("Cell 2").SetAlignment(Align.Center); row.Cells[2].Paragraphs[0].Append("Cell 3").SetAlignment(Align.Right); row.Cells[1].Shading.Set(ShadingPattern.Clear, "F2F2F2"); row.Cells[2].Shading.Set(ShadingPattern.Clear, "auto"); var rows = table.Rows.ToList(); for (int i = 0; i < rows.Count(); i++) { row = rows[i]; row.Height = Units.UHalfInch; row.BreakAcrossPages = true; for (int j = 0; j < row.Cells.Count(); j++) { var cell = row.Cells[j]; cell.SetVerticalAlignment(TableVerticalAlignment.Center); } } Validate(doc); doc.Close(); } }
private void toolStripMenuItem2_Click(object sender, EventArgs e) { var companybik = Interaction.InputBox("Введите БИК компании: "); if (companybik == "") { return; } saveFileDialog1.FileName = "list"; saveFileDialog1.ShowDialog(); var path = saveFileDialog1.FileName; var conn = new MySqlConnection(Information.connString); conn.Open(); DocX document = DocX.Create(path); document.InsertParagraph("Список должностей").Font("Times New Roman").FontSize(18).Alignment = Alignment.left; document.InsertParagraph(); var count = conn.QueryFirst <string> ($"select count(*) from position where company_id = {companybik}"); var positionList = conn.Query <Position> ($"select name, payment, conditions, requirements from position where company_id = {companybik}").ToList(); Table mainTable = document.AddTable(Convert.ToInt32(count) + 1, 4); mainTable.Alignment = Alignment.both; mainTable.AutoFit = AutoFit.ColumnWidth; mainTable.SetWidthsPercentage(new[] { 25.0f, 25.0f, 25.0f, 25.0f }); mainTable.Design = TableDesign.None; mainTable.Rows[0].Cells[0].Paragraphs[0].Append("Название должнолсти"); mainTable.Rows[0].Cells[1].Paragraphs[0].Append("Оплата"); mainTable.Rows[0].Cells[2].Paragraphs[0].Append("Условия"); mainTable.Rows[0].Cells[3].Paragraphs[0].Append("Требования"); for (int i = 0; i < Convert.ToInt32(count); i++) { mainTable.Rows[i + 1].Cells[0].Paragraphs[0].Append(positionList[i].name); mainTable.Rows[i + 1].Cells[1].Paragraphs[0].Append(positionList[i].payment); mainTable.Rows[i + 1].Cells[2].Paragraphs[0].Append(positionList[i].conditions); mainTable.Rows[i + 1].Cells[3].Paragraphs[0].Append(positionList[i].requirements); } document.InsertTable(mainTable); document.InsertParagraph(); var phone = conn.QueryFirstOrDefault <string> ($"select phone from company where bik = {companybik}"); document.InsertParagraph($"Звонить по телефону {phone}"); document.Save(); conn.Close(); Process.Start(path); }