private void button1_Click_1(object sender, System.EventArgs e) { // Get Template document and database path. string dataPath = Application.StartupPath + @"..\..\..\..\..\..\..\common\Data\"; try { //SDF the database and get the NorthWind AppDomain.CurrentDomain.SetData("SQLServerCompactEditionUnderWebHosting", true); DataTable table = new DataTable(); SqlCeConnection conn = new SqlCeConnection(); if (conn.ServerVersion.StartsWith("3.5")) { conn.ConnectionString = "Data Source = " + dataPath + "NorthwindIO_3.5.sdf"; } else { conn.ConnectionString = "Data Source = " + dataPath + "NorthwindIO.sdf"; } conn.Open(); SqlCeDataAdapter adapter = new SqlCeDataAdapter("Select CustomerID,CompanyName,ContactName,Address,Country,Phone from Customers", conn); adapter.Fill(table); adapter.Dispose(); conn.Close(); // Creating a new document. WordDocument document = new WordDocument(); // Adding a new section to the document. IWSection section = document.AddSection(); IWParagraph paragraph = section.AddParagraph(); paragraph.ParagraphFormat.BeforeSpacing = 20f; //Format the heading. IWTextRange text = paragraph.AppendText("Northwind Report"); text.CharacterFormat.Bold = true; text.CharacterFormat.FontName = "Cambria"; text.CharacterFormat.FontSize = 14.0f; text.CharacterFormat.TextColor = Color.DarkBlue; paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; paragraph = section.AddParagraph(); paragraph.ParagraphFormat.BeforeSpacing = 18f; //Create a new table WTextBody textBody = section.Body; IWTable docTable = textBody.AddTable(); //Set the format for rows RowFormat format = new RowFormat(); format.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; format.Borders.LineWidth = 1.0F; format.Borders.Color = Color.Black; //Initialize number of rows and cloumns. docTable.ResetCells(table.Rows.Count + 1, table.Columns.Count, format, 84); //Repeat the header. docTable.Rows[0].IsHeader = true; string colName; //Format the header rows for (int c = 0; c <= table.Columns.Count - 1; c++) { string[] Cols = table.Columns[c].ColumnName.Split('|'); colName = Cols[Cols.Length - 1]; IWTextRange theadertext = docTable.Rows[0].Cells[c].AddParagraph().AppendText(colName); theadertext.CharacterFormat.FontSize = 12f; theadertext.CharacterFormat.Bold = true; theadertext.CharacterFormat.TextColor = Color.White; docTable.Rows[0].Cells[c].CellFormat.BackColor = Color.FromArgb(33, 67, 126); docTable.Rows[0].Cells[c].CellFormat.Borders.Color = Color.Black; docTable.Rows[0].Cells[c].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; docTable.Rows[0].Cells[c].CellFormat.Borders.LineWidth = 1.0f; docTable.Rows[0].Cells[c].CellFormat.VerticalAlignment = Syncfusion.DocIO.DLS.VerticalAlignment.Middle; } //Format the table body rows for (int r = 0; r <= table.Rows.Count - 1; r++) { for (int c = 0; c <= table.Columns.Count - 1; c++) { string Value = table.Rows[r][c].ToString(); IWTextRange theadertext = docTable.Rows[r + 1].Cells[c].AddParagraph().AppendText(Value); theadertext.CharacterFormat.FontSize = 10; docTable.Rows[r + 1].Cells[c].CellFormat.BackColor = ((r & 1) == 0) ? Color.FromArgb(237, 240, 246) : Color.FromArgb(192, 201, 219); docTable.Rows[r + 1].Cells[c].CellFormat.Borders.Color = Color.Black; docTable.Rows[r + 1].Cells[c].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; docTable.Rows[r + 1].Cells[c].CellFormat.Borders.LineWidth = 0.5f; docTable.Rows[r + 1].Cells[c].CellFormat.VerticalAlignment = Syncfusion.DocIO.DLS.VerticalAlignment.Middle; } } // Add a footer paragraph text to the document. WParagraph footerPar = new WParagraph(document); // Add text. footerPar.AppendText("Copyright Syncfusion Inc. 2001-2021"); // Add page and Number of pages field to the document. footerPar.AppendText(" Page "); footerPar.AppendField("Page", Syncfusion.DocIO.FieldType.FieldPage); section.HeadersFooters.Footer.Paragraphs.Add(footerPar); //Save as doc format if (wordDocRadioBtn.Checked) { //Saving the document to disk. document.Save("Sample.doc"); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated Word document?", "Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { //Launching the MS Word file using the default Application.[MS Word Or Free WordViewer] System.Diagnostics.Process.Start("Sample.doc"); //Exit this.Close(); } } //Save as docx format else if (wordDocxRadioBtn.Checked) { //Saving the document as .docx document.Save("Sample.docx", FormatType.Docx); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated Word document?", "Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { try { //Launching the MS Word file using the default Application.[MS Word Or Free WordViewer] System.Diagnostics.Process.Start("Sample.docx"); //Exit this.Close(); } catch (Win32Exception ex) { MessageBoxAdv.Show("Microsoft Word Viewer or Microsoft Word is not installed in this system"); Console.WriteLine(ex.ToString()); } } } //Save as pdf format else if (pdfRadioBtn.Checked) { DocToPDFConverter converter = new DocToPDFConverter(); //Convert word document into PDF document PdfDocument pdfDoc = converter.ConvertToPDF(document); //Save the pdf file pdfDoc.Save("Sample.pdf"); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated PDF?", " Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { try { System.Diagnostics.Process.Start("Sample.pdf"); //Exit this.Close(); } catch (Exception ex) { MessageBoxAdv.Show("PDF Viewer is not installed in this system"); Console.WriteLine(ex.ToString()); } } } else { // Exit this.Close(); } } catch (Exception Ex) { // Shows the Message box with Exception message, if an exception throws. MessageBoxAdv.Show(Ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { } }
public ActionResult FormatText(string Group1) { if (Group1 == null) { return(View()); } //Random number generator. Random r = new Random(); // List of FontNames. string[] fontNames = { "Arial", "Times New Roman", "Monotype Corsiva", " Book Antiqua ", "Bitstream Vera Sans", "Comic Sans MS", "Microsoft Sans Serif", "Batang" }; // Create a new document. WordDocument document = new WordDocument(); // Adding a new section to the document. IWSection section = document.AddSection(); // Adding a new paragraph to the section. IWParagraph paragraph = section.AddParagraph(); paragraph.AppendText("This sample demonstrates various text and paragraph formatting support."); section.AddParagraph(); section.AddParagraph(); section = document.AddSection(); section.BreakCode = SectionBreakCode.NoBreak; //Adding two columns to the section. section.AddColumn(250, 20); section.AddColumn(250, 20); #region Text Formatting //Create a TextRange IWTextRange text = null; // Writing Text with different Formatting styles. for (int i = 8, j = 0, k = 0; i <= 20; i++, j++, k++) { if (j >= fontNames.Length) { j = 0; } paragraph = section.AddParagraph(); text = paragraph.AppendText("This is " + "[" + fontNames[j] + "]"); text.CharacterFormat.FontName = fontNames[j]; text.CharacterFormat.UnderlineStyle = (UnderlineStyle)k; text.CharacterFormat.FontSize = i; text.CharacterFormat.TextColor = Syncfusion.Drawing.Color.FromArgb(r.Next(0, 255), r.Next(0, 255), r.Next(0, 255)); } // More formatting options. section.AddParagraph(); paragraph.ParagraphFormat.ColumnBreakAfter = true; paragraph = section.AddParagraph(); text = paragraph.AppendText("More formatting Options List..."); text.CharacterFormat.FontName = fontNames[2]; text.CharacterFormat.FontSize = 18; section.AddParagraph(); paragraph = section.AddParagraph(); paragraph.AppendText("AllCaps \n\n").CharacterFormat.AllCaps = true; paragraph.AppendText("Bold \n\n").CharacterFormat.Bold = true; paragraph.AppendText("DoubleStrike \n\n").CharacterFormat.DoubleStrike = true; paragraph.AppendText("Emboss \n\n").CharacterFormat.Emboss = true; paragraph.AppendText("Engrave \n\n").CharacterFormat.Engrave = true; paragraph.AppendText("Italic \n\n").CharacterFormat.Italic = true; paragraph.AppendText("Shadow \n\n").CharacterFormat.Shadow = true; paragraph.AppendText("SmallCaps \n\n").CharacterFormat.SmallCaps = true; paragraph.AppendText("Strikeout \n\n").CharacterFormat.Strikeout = true; paragraph.AppendText("Some Text"); paragraph.AppendText("SubScript \n\n").CharacterFormat.SubSuperScript = SubSuperScript.SubScript; paragraph.AppendText("Some Text"); paragraph.AppendText("SuperScript \n\n").CharacterFormat.SubSuperScript = SubSuperScript.SuperScript; paragraph.AppendText("TextBackgroundColor \n\n").CharacterFormat.TextBackgroundColor = Syncfusion.Drawing.Color.LightBlue; #endregion #region Paragraph formattings section = document.AddSection(); section.BreakCode = SectionBreakCode.NewPage; paragraph = section.AddParagraph(); paragraph.AppendText("Following paragraphs illustrates various paragraph formattings"); paragraph = section.AddParagraph(); paragraph.AppendText("We will use this paragraph to illustrate several Microsoft Word features using Essential DocIO. It will be used to illustrate Space Before, Space After, and Line Spacing. Space Before tells Microsoft Word how much space to leave before the paragraph. Space After tells Microsoft Word how much space to leave after the paragraph. Line Spacing sets the space between lines within a paragraph.It also explains about first line indentation,backcolor and paragraph border."); paragraph.ParagraphFormat.BeforeSpacing = 20f; paragraph.ParagraphFormat.AfterSpacing = 30f; paragraph.ParagraphFormat.BackColor = Syncfusion.Drawing.Color.LightGray; paragraph.ParagraphFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; paragraph.ParagraphFormat.FirstLineIndent = 20f; paragraph.ParagraphFormat.LineSpacing = 20f; paragraph = section.AddParagraph(); paragraph.AppendText("This is a sample paragraph. It is used to illustrate alignment. Left-justified text is aligned on the left. Right-justified text is aligned with on the right. Centered text is centered between the left and right margins. You can use Center to center your titles. Justified text is flush on both sides."); paragraph.ParagraphFormat.LineSpacing = 20f; paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Right; paragraph.ParagraphFormat.LineSpacingRule = LineSpacingRule.Exactly; section.AddParagraph(); //Adding a new paragraph to the section. paragraph = section.AddParagraph(); paragraph.ParagraphFormat.Keep = true; paragraph.AppendText("KEEP TOGETHER").CharacterFormat.Bold = true; paragraph.AppendText("This is a sample paragraph. It is used to illustrate Keep together of MsWord. You can control where Microsoft Word positions automatic page breaks (page break: The point at which one page ends and another begins. Microsoft Word inserts an 'automatic' (or soft) page break for you, or you can force a page break at a specific location by inserting a 'manual' (or hard) page break.) by setting pagination options.It keeps the lines in a paragraph together when there is page break").CharacterFormat.FontSize = 12f; for (int i = 0; i < 10; i++) { paragraph.AppendText("Text Body_Text Body_Text Body_Text Body_Text Body_Text Body_Text Body").CharacterFormat.FontSize = 12f; paragraph.ParagraphFormat.LineSpacing = 20f; } paragraph.AppendText("KEEP TOGETHER END").CharacterFormat.Bold = true; #endregion #region Bullets and Numbering // Adding a new section to the document. section = document.AddSection(); // Adding a new paragraph to the document. paragraph = section.AddParagraph(); // Writing text to the current paragraph. paragraph.AppendText("This document demonstrates the Bullets and Numbering functionality available in Essential DocIO"); //Add a new section section1 = document.AddSection(); //Adding two columns to the section. section1.Columns.Add(new Column(document)); section1.Columns.Add(new Column(document)); //Set the columns to be of equal width. section1.MakeColumnsEqual(); // Set section break code as NoBreak. section1.BreakCode = SectionBreakCode.NoBreak; // Set formatting. ProductDetailsInBullets(); // Set Formatting. ProductDetailsInNumbers(); #endregion Bullets and Numbering FormatType type = FormatType.Docx; string filename = "Sample.docx"; string contenttype = "application/vnd.ms-word.document.12"; #region Document SaveOption //Save as .doc format if (Group1 == "WordDoc") { type = FormatType.Doc; filename = "Sample.doc"; contenttype = "application/msword"; } //Save as .xml format else if (Group1 == "WordML") { type = FormatType.WordML; filename = "Sample.xml"; contenttype = "application/msword"; } #endregion Document SaveOption MemoryStream ms = new MemoryStream(); document.Save(ms, type); document.Close(); ms.Position = 0; return(File(ms, contenttype, filename)); }
public void ExportChart(string Data, string ChartModel) { // declaration ChartProperties obj = ConvertChartObject(ChartModel); string type = obj.ExportSettings.Type.ToString().ToLower(); string fileName = obj.ExportSettings.FileName; string orientation = obj.ExportSettings.Orientation.ToString(); if (type == "svg") // for svg export { StringWriter oStringWriter = new StringWriter(); string data = HttpUtility.HtmlDecode(Data); data = HttpUtility.UrlDecode(Data); data = System.Uri.UnescapeDataString(Data); oStringWriter.WriteLine(System.Uri.UnescapeDataString(Data)); Response.ContentType = "text/plain"; Response.AddHeader("Content-Disposition", String.Format("attachment;filename={0}", (obj.ExportSettings.FileName + ".svg"))); Response.Clear(); using (StreamWriter writer = new StreamWriter(Response.OutputStream)) { data = oStringWriter.ToString(); writer.Write(oStringWriter.ToString()); } Response.End(); } else if (type == "xlsx") // to export chart as excel { List <ExportChartData> chartData = new List <ExportChartData>(); chartData.Add(new ExportChartData("John", 10)); chartData.Add(new ExportChartData("Jake", 12)); chartData.Add(new ExportChartData("Peter", 18)); chartData.Add(new ExportChartData("James", 11)); chartData.Add(new ExportChartData("Mary", 9.7)); ExcelExport exp = new ExcelExport(); exp.Export(obj, (IEnumerable)chartData, fileName + ".xlsx", ExcelVersion.Excel2010, null, null); } else { Data = Data.Remove(0, Data.IndexOf(',') + 1); MemoryStream stream = new MemoryStream(Convert.FromBase64String(Data)); if (type == "docx") // to export as word document { WordDocument document = new WordDocument(); IWSection section = document.AddSection(); IWParagraph paragraph = section.AddParagraph(); //Set orientation based on chart width Image img = Image.FromStream(stream); if (obj.ExportSettings.Orientation.ToString() == "Landscape" || section.PageSetup.ClientWidth < img.Width) { section.PageSetup.Orientation = PageOrientation.Landscape; } else { section.PageSetup.Orientation = PageOrientation.Portrait; } img.Dispose(); paragraph.AppendPicture(Image.FromStream(stream)); document.Save(fileName + ".doc", Syncfusion.DocIO.FormatType.Doc, HttpContext.ApplicationInstance.Response, Syncfusion.DocIO.HttpContentDisposition.Attachment); } else if (type == "pdf") // to export as PDF { PdfDocument pdfDoc = new PdfDocument(); pdfDoc.Pages.Add(); //Set chart width as pdf page width Image img = Image.FromStream(stream); pdfDoc.Pages[0].Section.PageSettings.Width = img.Width; img.Dispose(); if (obj.ExportSettings.Orientation.ToString() == "Landscape") { pdfDoc.Pages[0].Section.PageSettings.Orientation = PdfPageOrientation.Landscape; } else { pdfDoc.Pages[0].Section.PageSettings.Orientation = PdfPageOrientation.Portrait; } pdfDoc.Pages[0].Graphics.DrawImage(PdfImage.FromStream(stream), new PointF(10, 30)); pdfDoc.Save(obj.ExportSettings.FileName + ".pdf", HttpContext.ApplicationInstance.Response, HttpReadType.Save); pdfDoc.Close(); } else // to export as image { stream.WriteTo(Response.OutputStream); Response.ContentType = "application/octet-stream"; Response.AddHeader("Content-Disposition", String.Format("attachment;filename={0}", fileName + "." + type)); Response.Flush(); stream.Close(); stream.Dispose(); } } }
private void button1_Click(object sender, System.EventArgs e) { try { //A new document is created. WordDocument document = new WordDocument(); //Adding a section to the document. IWSection section = document.AddSection(); //Adding a paragraph to the section. IWParagraph paragraph = section.AddParagraph(); #region DocVariable string name = "John Smith"; string address = "Cary, NC"; //Get the variables in the existing document DocVariables dVariable = document.Variables; //Add doc variables dVariable.Add("Customer Name", name); dVariable.Add("Customer Address", address); #endregion DocVariable #region Document Properties //Setting document Properties document.BuiltinDocumentProperties.Author = "Essential DocIO"; document.BuiltinDocumentProperties.ApplicationName = "Essential DocIO"; document.BuiltinDocumentProperties.Category = "Document Generator"; document.BuiltinDocumentProperties.Comments = "This document was generated using Essential DocIO"; document.BuiltinDocumentProperties.Company = "Syncfusion Inc"; document.BuiltinDocumentProperties.Subject = "Native Word Generator"; document.BuiltinDocumentProperties.Keywords = "Syncfusion"; document.BuiltinDocumentProperties.Manager = "Sync Manager"; document.BuiltinDocumentProperties.Title = "Essential DocIO"; // Add a custom document Property document.CustomDocumentProperties.Add("My_Doc_Date", DateTime.Today); document.CustomDocumentProperties.Add("My_Doc", true); document.CustomDocumentProperties.Add("My_ID", 1031); document.CustomDocumentProperties.Add("My_Comment", "Essential DocIO"); //Remove a custome property document.CustomDocumentProperties.Remove("My_Doc"); #endregion IWTextRange text = paragraph.AppendText(""); text.CharacterFormat.FontName = "Calibri"; text.CharacterFormat.FontSize = 13; text = paragraph.AppendText("This document is created with various Document Properties Summary Information and page settings information \n\n You can view Document Properties through: File -> Properties -> Summary/Custom."); text.CharacterFormat.FontName = "Calibri"; text.CharacterFormat.FontSize = 13; #region Page setup // Write section properties section.PageSetup.PageSize = new SizeF(500, 750); section.PageSetup.Orientation = PageOrientation.Landscape; section.PageSetup.Margins.Bottom = 100; section.PageSetup.Margins.Top = 100; section.PageSetup.Margins.Left = 50; section.PageSetup.Margins.Right = 50; section.PageSetup.PageBordersApplyType = PageBordersApplyType.AllPages; section.PageSetup.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.DoubleWave; section.PageSetup.Borders.Color = Color.DarkBlue; section.PageSetup.VerticalAlignment = PageAlignment.Middle; #endregion paragraph = section.AddParagraph(); text = paragraph.AppendText(""); text.CharacterFormat.FontName = "Calibri"; text.CharacterFormat.FontSize = 13; text = paragraph.AppendText("\n\n You can view Page setup options through File -> PageSetup."); text.CharacterFormat.FontName = "Calibri"; text.CharacterFormat.FontSize = 13; #region Get document variables paragraph = document.LastSection.AddParagraph(); dVariable = document.Variables; text = paragraph.AppendText("\n\n Document Variables\n"); text.CharacterFormat.FontName = "Calibri"; text.CharacterFormat.FontSize = 13; text.CharacterFormat.Bold = true; text = paragraph.AppendText("\n" + dVariable.GetNameByIndex(1) + ": " + dVariable.GetValueByIndex(1)); text.CharacterFormat.FontName = "Calibri"; text.CharacterFormat.FontSize = 13; //Display the current variable count text = paragraph.AppendText("\n\nDocument Variables Count: " + dVariable.Count); text.CharacterFormat.FontName = "Calibri"; text.CharacterFormat.FontSize = 13; #endregion Get document variables //Save as doc format if (wordDocRadioBtn.Checked) { //Saving the document to disk. document.Save("Sample.doc"); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated Word document?", "Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { //Launching the MS Word file using the default Application.[MS Word Or Free WordViewer] System.Diagnostics.Process.Start("Sample.doc"); //Exit this.Close(); } } //Save as docx format else if (wordDocxRadioBtn.Checked) { //Saving the document as .docx document.Save("Sample.docx", FormatType.Docx); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated Word document?", "Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { try { //Launching the MS Word file using the default Application.[MS Word Or Free WordViewer] System.Diagnostics.Process.Start("Sample.docx"); //Exit this.Close(); } catch (Win32Exception ex) { MessageBoxAdv.Show("Microsoft Word Viewer or Microsoft Word is not installed in this system"); Console.WriteLine(ex.ToString()); } } } else { // Exit this.Close(); } } catch (Exception Ex) { MessageBox.Show(Ex.Message); } }
void CreateFootNote(WordDocument document) { //Add a new section to the document. IWSection section = document.AddSection(); //Adding a new paragraph to the section. IWParagraph paragraph = section.AddParagraph(); IWTextRange textRange = paragraph.AppendText("\t\t\t\t\tDemo for Footnote"); textRange.CharacterFormat.TextColor = Color.Black; textRange.CharacterFormat.Bold = true; textRange.CharacterFormat.FontSize = 20; section.AddParagraph(); section.AddParagraph(); paragraph = section.AddParagraph(); WFootnote footnote = new WFootnote(document); footnote = paragraph.AppendFootnote(FootnoteType.Footnote); footnote.MarkerCharacterFormat.SubSuperScript = SubSuperScript.SuperScript; //Insert Text into the paragraph paragraph.AppendText("Google").CharacterFormat.Bold = true; paragraph = section.AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; paragraph.AppendPicture(Image.FromFile(dataPath3 + "google.png")); paragraph = footnote.TextBody.AddParagraph(); paragraph.AppendText(" Google is the most famous search engines in the Word "); //Adding a new paragraph to the section. paragraph = section.AddParagraph(); paragraph = section.AddParagraph(); footnote = paragraph.AppendFootnote(FootnoteType.Footnote); footnote.MarkerCharacterFormat.SubSuperScript = SubSuperScript.SuperScript; //Insert Text into the paragraph paragraph.AppendText("Yahoo").CharacterFormat.Bold = true; paragraph = section.AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; paragraph.AppendPicture(Image.FromFile(dataPath3 + "yahoo.gif")); paragraph = footnote.TextBody.AddParagraph(); paragraph.AppendText(" Yahoo experience makes it easier to discover the news and information that you care about most. "); //Adding a new paragraph to the section. paragraph = section.AddParagraph(); paragraph = section.AddParagraph(); footnote = paragraph.AppendFootnote(FootnoteType.Footnote); footnote.MarkerCharacterFormat.SubSuperScript = SubSuperScript.SuperScript; //Insert Text into the paragraph paragraph.AppendText("Northwind Traders").CharacterFormat.Bold = true; paragraph = section.AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; paragraph.AppendPicture(Image.FromFile(dataPath3 + "Northwind_logo.png")); paragraph = footnote.TextBody.AddParagraph(); paragraph.AppendText(" The Northwind sample database (Northwind.mdb) is included with all versions of Access. It provides data you can experiment with and database objects that demonstrate features you might want to implement in your own databases. "); //Setting number format for Footnote document.FootnoteNumberFormat = FootEndNoteNumberFormat.Arabic; //Setting Footnote position document.FootnotePosition = FootnotePosition.PrintAtBottomOfPage; }
private void button1_Click(object sender, System.EventArgs e) { try { // Creating a new document. WordDocument document = new WordDocument(); // Adding a section to the document. IWSection section = document.AddSection(); //Set Margin of the section section.PageSetup.Margins.All = 72; // Adding a new paragraph to the section. IWParagraph paragraph = section.AddParagraph(); // Writing text paragraph.AppendText("This document demonstrates Essential DocIO's Bookmark functionality.").CharacterFormat.FontSize = 14f; // Adding paragraph to the section. section.AddParagraph(); paragraph = section.AddParagraph(); paragraph.AppendText("1. Inserting Bookmark Text").CharacterFormat.FontSize = 12f; // Adding paragraph to the section. section.AddParagraph(); paragraph = section.AddParagraph(); // BookmarkStart. paragraph.AppendBookmarkStart("Bookmark"); // Write bookmark paragraph.AppendText("Bookmark Text"); paragraph.AppendComment("This is a simple bookmark"); // BookmarkEnd. paragraph.AppendBookmarkEnd("Bookmark"); // Adding paragraph to the section. section.AddParagraph(); paragraph = section.AddParagraph(); // Indicating hidden bookmark text start. paragraph.AppendBookmarkStart("_HiddenText"); // Writing bookmark text paragraph.AppendText("2. Hidden Bookmark Text").CharacterFormat.Font = new Font("Comic Sans MS", 10); // Indicating hidden bookmark text end. paragraph.AppendBookmarkEnd("_HiddenText"); paragraph.AppendComment("This is hidden bookmark"); section.AddParagraph(); paragraph = section.AddParagraph(); paragraph.AppendText("3. Nested Bookmarks").CharacterFormat.FontSize = 12f; // Writing nested bookmarks section.AddParagraph(); paragraph = section.AddParagraph(); paragraph.AppendBookmarkStart("Main"); paragraph.AppendText(" Main data "); paragraph.AppendBookmarkStart("Nested"); paragraph.AppendText(" Nested data "); paragraph.AppendComment("This is a nested bookmark"); paragraph.AppendBookmarkStart("NestedNested"); paragraph.AppendText(" Nested Nested "); paragraph.AppendBookmarkEnd("NestedNested"); paragraph.AppendText(" data Nested "); paragraph.AppendBookmarkEnd("Nested"); paragraph.AppendText(" Data Main "); paragraph.AppendBookmarkEnd("Main"); //Save as doc format if (wordDocRadioBtn.Checked) { //Saving the document to disk. document.Save("Sample.doc"); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated Word document?", "Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { //Launching the MS Word file using the default Application.[MS Word Or Free WordViewer] #if NETCORE System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo = new System.Diagnostics.ProcessStartInfo("Sample.doc") { UseShellExecute = true }; process.Start(); #else System.Diagnostics.Process.Start("Sample.doc"); #endif //Exit this.Close(); } } //Save as docx format else if (wordDocxRadioBtn.Checked) { //Saving the document as .docx document.Save("Sample.docx", FormatType.Docx); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated Word document?", "Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { try { //Launching the MS Word file using the default Application.[MS Word Or Free WordViewer] #if NETCORE System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo = new System.Diagnostics.ProcessStartInfo("Sample.docx") { UseShellExecute = true }; process.Start(); #else System.Diagnostics.Process.Start("Sample.docx"); #endif //Exit this.Close(); } catch (Win32Exception ex) { MessageBoxAdv.Show("Microsoft Word Viewer or Microsoft Word is not installed in this system"); Console.WriteLine(ex.ToString()); } } } //Save as pdf format else if (pdfRadioBtn.Checked) { DocToPDFConverter converter = new DocToPDFConverter(); //Convert word document into PDF document PdfDocument pdfDoc = converter.ConvertToPDF(document); //Save the pdf file pdfDoc.Save("Sample.pdf"); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated PDF?", " Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { try { #if NETCORE System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo = new System.Diagnostics.ProcessStartInfo("Sample.pdf") { UseShellExecute = true }; process.Start(); #else System.Diagnostics.Process.Start("Sample.pdf"); #endif //Exit this.Close(); } catch (Exception ex) { MessageBoxAdv.Show("PDF Viewer is not installed in this system"); Console.WriteLine(ex.ToString()); } } } else { // Exit this.Close(); } } catch (Exception Ex) { MessageBox.Show(Ex.Message); } }
private void button1_Click(object sender, EventArgs e) { try { if (this.textBox1.Text != string.Empty) { WordDocument document = new WordDocument(); IWSection section = document.AddSection(); // Set Margin of the document section.PageSetup.Margins.All = 72; IWParagraph para = section.AddParagraph(); bool valid = false; // This manual validation check is Transitional. We do this here only for instructional purpose. if (section.Body.IsValidXHTML(this.textBox1.Text, XHTMLValidationType.Transitional, out errorMessage)) { valid = true; document.XHTMLValidateOption = XHTMLValidationType.Transitional; } // This manual validation check is Strict. We do this here only for instructional purpose else if (section.Body.IsValidXHTML(this.textBox1.Text, XHTMLValidationType.Strict, out errorMessage)) { valid = true; document.XHTMLValidateOption = XHTMLValidationType.Strict; } // This manual validation check is None. We do this here only for instructional purpose else if (section.Body.IsValidXHTML(this.textBox1.Text, XHTMLValidationType.None, out errorMessage)) { valid = true; document.XHTMLValidateOption = XHTMLValidationType.None; } if (!valid) { outpuTextBox.Text = "Content is not a welformatted XHTML content.\t\t\tError message:\t\t\t\t\t\t" + errorMessage; this.panel4.Visible = true; this.label4.Visible = false; this.button3.Text = "-"; this.Size = new Size(384, 650); } else { // By default, the input html will be validated for XHTML format. This will provide you understandable error messages, if the format is invalid. // However, if you are sure that the input html is valid, then you can skip the validation step to improve performance. However, any error messages //you might get here will not be very useful as to where exactly in your html, the issue is. section.Body.InsertXHTML(this.textBox1.Text); outpuTextBox.Text = "Conversion Successful"; this.panel4.Visible = true; this.label4.Visible = false; this.button3.Text = "-"; this.Size = new Size(384, 650); #region Save and open Document //Save as doc format if (wordDocRadioBtn.Checked) { //Saving the document to disk. document.Save("Sample.doc"); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated Word document?", "Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { //Launching the MS Word file using the default Application.[MS Word Or Free WordViewer] System.Diagnostics.Process.Start("Sample.doc"); //Exit this.Close(); } } //Save as docx format else if (wordDocxRadioBtn.Checked) { //Saving the document as .docx document.Save("Sample.docx", FormatType.Docx); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated Word document?", "Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { try { //Launching the MS Word file using the default Application.[MS Word Or Free WordViewer] System.Diagnostics.Process.Start("Sample.docx"); //Exit this.Close(); } catch (Win32Exception ex) { MessageBoxAdv.Show("Microsoft Word Viewer or Microsoft Word is not installed in this system"); Console.WriteLine(ex.ToString()); } } } else { // Exit this.Close(); } #endregion } } else { MessageBoxAdv.Show("Browse or type the HTML content to be converted to word document"); } } catch (Exception Ex) { MessageBox.Show(Ex.Message); } }
private IActionResult GenerateVolunteerWordDoc(Volunteer ourVolunteer, DbSet <VolunteerActivity> volunteerActivities, DbSet <Initiative> initiatives) { //Creating and formatting document WordDocument report = new WordDocument(); IWSection section = report.AddSection(); section.PageSetup.Margins.All = 50f; IWParagraph name = section.AddParagraph(); name.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; name.ParagraphFormat.AfterSpacing = 18f; IWTextRange nameText = name.AppendText(ourVolunteer.FullName); //Creating and formatting table IWTable info = section.AddTable(); info.ResetCells(1, 5); info.Rows[0].Cells[0].AddParagraph().AppendText("Date"); info.Rows[0].Cells[1].AddParagraph().AppendText("Initiative"); info.Rows[0].Cells[2].AddParagraph().AppendText("Start Time"); info.Rows[0].Cells[3].AddParagraph().AppendText("End Time"); info.Rows[0].Cells[4].AddParagraph().AppendText("Elapsed Time"); info.Rows[0].Height = 20; //Looping through initiatives and filling the table int row = 0; foreach (CoHO.Models.VolunteerActivity activity in volunteerActivities.ToArray()) { if (activity.VolunteerId == ourVolunteer.VolunteerID) { info.AddRow(); row += 1; info.Rows[row].Height = 20; string Start = activity.StartTime.ToString(); string End = activity.EndTime.ToString(); var StartAMPM = activity.StartTime.ToString("hh:mm:ss tt", CultureInfo.InvariantCulture); var EndAMPM = activity.EndTime.ToString("hh:mm:ss tt", CultureInfo.InvariantCulture); int id = activity.InitiativeId; info.Rows[row].Cells[0].AddParagraph().AppendText(Start.Split(' ')[0]); info.Rows[row].Cells[1].AddParagraph() .AppendText(initiatives.Single(m => m.InitiativeID == id).Description); info.Rows[row].Cells[2].AddParagraph().AppendText(StartAMPM); info.Rows[row].Cells[3].AddParagraph().AppendText(EndAMPM); info.Rows[row].Cells[4].AddParagraph().AppendText(activity.ElapsedTime.ToString().Split('.')[0]); } } //Assigning font nameText.CharacterFormat.FontName = "Times New Roman"; nameText.CharacterFormat.FontSize = 14; //Saving document and downloading to user's computer MemoryStream stream = new MemoryStream(); report.Save(stream, FormatType.Docx); report.Close(); stream.Position = 0; return(File(stream, "application/msword", "UserReport.docx")); }
public ActionResult FormatTable(string Group1) { if (Group1 == null) { return(View()); } // Create a new document. WordDocument document = new WordDocument(); // Adding a new section to the document. IWSection section = document.AddSection(); section.PageSetup.Margins.All = 50; section.PageSetup.DifferentFirstPage = true; IWTextRange textRange; IWParagraph paragraph = section.AddParagraph(); #region Table Cell Spacing. // -------------------------------------------- // Table Cell Spacing. // -------------------------------------------- paragraph.AppendText("Table Cell spacing...").CharacterFormat.FontSize = 14; section.AddParagraph(); paragraph = section.AddParagraph(); WTextBody textBody = section.Body; // Adding a new Table to the textbody. IWTable table = textBody.AddTable(); table.TableFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; table.TableFormat.Paddings.All = 5.4f; RowFormat format = new RowFormat(); format.Paddings.All = 5; format.CellSpacing = 2; format.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.DotDash; format.IsBreakAcrossPages = true; table.ResetCells(25, 5, format, 90); IWTextRange text; table.Rows[0].IsHeader = true; for (int i = 0; i < table.Rows[0].Cells.Count; i++) { paragraph = table[0, i].AddParagraph() as WParagraph; paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; text = paragraph.AppendText(string.Format("Header {0}", i + 1)); text.CharacterFormat.Font = new Font("Bitstream Vera Serif", 10); text.CharacterFormat.Bold = true; text.CharacterFormat.TextColor = Syncfusion.Drawing.Color.FromArgb(0, 21, 84); table[0, i].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(203, 211, 226); } for (int i = 1; i < table.Rows.Count; i++) { for (int j = 0; j < 5; j++) { paragraph = table[i, j].AddParagraph() as WParagraph; paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; text = paragraph.AppendText(string.Format("Cell {0} , {1}", i, j + 1)); text.CharacterFormat.TextColor = Syncfusion.Drawing.Color.FromArgb(242, 151, 50); text.CharacterFormat.Bold = true; if (i % 2 != 1) { table[i, j].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(231, 235, 245); } else { table[i, j].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(246, 249, 255); } } } (table as WTable).AutoFit(AutoFitType.FitToContent); #endregion Table Cell Spacing. #region Nested Table // -------------------------------------------- // Nested Table. // -------------------------------------------- section.AddParagraph(); paragraph = section.AddParagraph(); paragraph.ParagraphFormat.PageBreakBefore = true; paragraph.AppendText("Nested Table...").CharacterFormat.FontSize = 14; section.AddParagraph(); paragraph = section.AddParagraph(); textBody = section.Body; // Adding a new Table to the textbody. table = textBody.AddTable(); format = new RowFormat(); format.Paddings.All = 5; format.CellSpacing = 2.5f; format.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.DotDash; table.ResetCells(5, 3, format, 100); for (int i = 0; i < table.Rows[0].Cells.Count; i++) { paragraph = table[0, i].AddParagraph() as WParagraph; paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; text = paragraph.AppendText(string.Format("Header {0}", i + 1)); text.CharacterFormat.Font = new Font("Bitstream Vera Serif", 10); text.CharacterFormat.Bold = true; text.CharacterFormat.TextColor = Syncfusion.Drawing.Color.FromArgb(0, 21, 84); table[0, i].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(242, 151, 50); } table[0, 2].Width = 200; for (int i = 1; i < table.Rows.Count; i++) { for (int j = 0; j < 3; j++) { paragraph = table[i, j].AddParagraph() as WParagraph; paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; if ((i == 2) && (j == 2)) { text = paragraph.AppendText("Nested Table"); } else { text = paragraph.AppendText(string.Format("Cell {0} , {1}", i, j + 1)); } if ((j == 2)) { table[i, j].Width = 200; } text.CharacterFormat.TextColor = Syncfusion.Drawing.Color.FromArgb(242, 151, 50); text.CharacterFormat.Bold = true; } } // Adding a nested Table. IWTable nestTable = table[2, 2].AddTable(); format = new RowFormat(); format.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.DotDash; format.HorizontalAlignment = RowAlignment.Center; nestTable.ResetCells(3, 3, format, 45); for (int i = 0; i < nestTable.Rows.Count; i++) { for (int j = 0; j < 3; j++) { paragraph = nestTable[i, j].AddParagraph() as WParagraph; paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; nestTable[i, j].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(231, 235, 245); text = paragraph.AppendText(string.Format("Cell {0} , {1}", i, j + 1)); text.CharacterFormat.TextColor = Syncfusion.Drawing.Color.Black; text.CharacterFormat.Bold = true; } } (nestTable as WTable).AutoFit(AutoFitType.FitToContent); (table as WTable).AutoFit(AutoFitType.FitToWindow); #endregion Nested Table #region Table with Images //Add a new section to the document. section = document.AddSection(); //Add paragraph to the section. paragraph = section.AddParagraph(); //Writing text. textRange = paragraph.AppendText("Table with Images"); textRange.CharacterFormat.FontSize = 13f; textRange.CharacterFormat.TextColor = Syncfusion.Drawing.Color.DarkBlue; textRange.CharacterFormat.Bold = true; //Add paragraph to the section. section.AddParagraph(); paragraph = section.AddParagraph(); text = null; //Adding a new Table to the paragraph. table = section.Body.AddTable(); table.ResetCells(1, 3); //Adding rows to the table. WTableRow row = table.Rows[0]; //Set heading row height row.Height = 25f; //set heading values to the Table. for (int i = 0; i < 3; i++) { //Add paragraph for writing Text to the cells. paragraph = (IWParagraph)row.Cells[i].AddParagraph(); //Set Horizontal Alignment as Center. paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; //Writing Row Heading switch (i) { case 0: text = paragraph.AppendText("SNO"); row.Cells[i].Width = 50f; break; case 1: text = paragraph.AppendText("Drinks"); break; case 2: text = paragraph.AppendText("Showcase Image"); row.Cells[i].Width = 200f; break; } //Set row Heading formatting text.CharacterFormat.Bold = true; text.CharacterFormat.FontName = "Cambria"; text.CharacterFormat.FontSize = 11f; text.CharacterFormat.TextColor = Syncfusion.Drawing.Color.White; //Set row cells formatting row.Cells[i].CellFormat.VerticalAlignment = VerticalAlignment.Middle; row.Cells[i].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(157, 161, 190); row.Cells[i].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; } int sno = 1; //Writing Sno, Product name and Product Images to the Table. WTableRow row1 = table.AddRow(false); //Writing SNO to the table with formatting text. paragraph = (IWParagraph)row1.Cells[0].AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; text = paragraph.AppendText(sno.ToString()); text.CharacterFormat.Bold = true; text.CharacterFormat.FontSize = 10f; row1.Cells[0].CellFormat.VerticalAlignment = VerticalAlignment.Middle; row1.Cells[0].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; row1.Cells[0].CellFormat.BackColor = Color.FromArgb(217, 223, 239); //Writing Product Name to the table with Formatting. paragraph = (IWParagraph)row1.Cells[1].AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; text = paragraph.AppendText("Apple Juice"); text.CharacterFormat.Bold = true; text.CharacterFormat.FontSize = 10f; text.CharacterFormat.TextColor = Color.FromArgb(50, 65, 124); row1.Cells[1].CellFormat.VerticalAlignment = VerticalAlignment.Middle; row1.Cells[1].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; row1.Cells[1].CellFormat.BackColor = Color.FromArgb(217, 223, 239); //Writing Product Images to the Table. paragraph = (IWParagraph)row1.Cells[2].AddParagraph(); string basePath = _hostingEnvironment.WebRootPath; FileStream imageStream = new FileStream(basePath + @"/images/DocIO/Apple Juice.png", FileMode.Open, FileAccess.Read); paragraph.AppendPicture(imageStream); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; row1.Cells[2].CellFormat.VerticalAlignment = VerticalAlignment.Middle; row1.Cells[2].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; row1.Cells[2].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(217, 223, 239); sno++; row1 = table.AddRow(false); //Writing SNO to the table with formatting text. paragraph = (IWParagraph)row1.Cells[0].AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; text = paragraph.AppendText(sno.ToString()); text.CharacterFormat.Bold = true; text.CharacterFormat.FontSize = 10f; row1.Cells[0].CellFormat.VerticalAlignment = VerticalAlignment.Middle; row1.Cells[0].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; row1.Cells[0].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(217, 223, 239); //Writing Product Name to the table with Formatting. paragraph = (IWParagraph)row1.Cells[1].AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; text = paragraph.AppendText("Grape Juice"); text.CharacterFormat.Bold = true; text.CharacterFormat.FontSize = 10f; text.CharacterFormat.TextColor = Syncfusion.Drawing.Color.FromArgb(50, 65, 124); row1.Cells[1].CellFormat.VerticalAlignment = VerticalAlignment.Middle; row1.Cells[1].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; row1.Cells[1].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(217, 223, 239); //Writing Product Images to the Table. paragraph = (IWParagraph)row1.Cells[2].AddParagraph(); imageStream = new FileStream(basePath + @"/images/DocIO/Grape Juice.png", FileMode.Open, FileAccess.Read); paragraph.AppendPicture(imageStream); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; row1.Cells[2].CellFormat.VerticalAlignment = VerticalAlignment.Middle; row1.Cells[2].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; row1.Cells[2].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(217, 223, 239); sno++; row1 = table.AddRow(false); //Writing SNO to the table with formatting text. paragraph = (IWParagraph)row1.Cells[0].AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; text = paragraph.AppendText(sno.ToString()); text.CharacterFormat.Bold = true; text.CharacterFormat.FontSize = 10f; row1.Cells[0].CellFormat.VerticalAlignment = VerticalAlignment.Middle; row1.Cells[0].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; row1.Cells[0].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(217, 223, 239); //Writing Product Name to the table with Formatting. paragraph = (IWParagraph)row1.Cells[1].AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; text = paragraph.AppendText("Hot Soup"); text.CharacterFormat.Bold = true; text.CharacterFormat.FontSize = 10f; text.CharacterFormat.TextColor = Syncfusion.Drawing.Color.FromArgb(50, 65, 124); row1.Cells[1].CellFormat.VerticalAlignment = VerticalAlignment.Middle; row1.Cells[1].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; row1.Cells[1].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(217, 223, 239); //Writing Product Images to the Table. paragraph = (IWParagraph)row1.Cells[2].AddParagraph(); imageStream = new FileStream(basePath + @"/images/DocIO/Hot Soup.png", FileMode.Open, FileAccess.Read); paragraph.AppendPicture(imageStream); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; row1.Cells[2].CellFormat.VerticalAlignment = VerticalAlignment.Middle; row1.Cells[2].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; row1.Cells[2].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(217, 223, 239); sno++; (table as WTable).AutoFit(AutoFitType.FixedColumnWidth); #endregion Table with Images FormatType type = FormatType.Docx; string filename = "Sample.docx"; string contenttype = "application/vnd.ms-word.document.12"; #region Document SaveOption //Save as .doc format if (Group1 == "WordDoc") { type = FormatType.Doc; filename = "Sample.doc"; contenttype = "application/msword"; } //Save as .xml format else if (Group1 == "WordML") { type = FormatType.WordML; filename = "Sample.xml"; contenttype = "application/msword"; } #endregion Document SaveOption MemoryStream ms = new MemoryStream(); document.Save(ms, type); document.Close(); ms.Position = 0; return(File(ms, contenttype, filename)); }
private async void CreaTabellaDinamicaWordAsync() { //Crea una istanza della classe WordDocument WordDocument document = new WordDocument(); IWSection section = document.AddSection(); section.AddParagraph().AppendText("Price Details"); section.AddParagraph(); //Aggiunge una nuova tabella al dovumento Word IWTable table = section.AddTable(); //Aggiunge la prima riga alla tabella WTableRow row = table.AddRow(); //Aggiunge la prima cella nella prima riga WTableCell cell = row.AddCell(); //Specifica la larghezza della cella cell.Width = 200; cell.AddParagraph().AppendText("Item"); //Aggiunge la seconda cella nella prima riga cell = row.AddCell(); //Specifica la larghezza della cella cell.Width = 200; cell.AddParagraph().AppendText("Price($)"); //Aggiunge la seconda riga alla tabella row = table.AddRow(true, false); //Aggiunge la prima cella nella seconda riga cell = row.AddCell(); //Specifica la larghezza della cella cell.Width = 200; cell.AddParagraph().AppendText("Apple"); //Aggiunge la seconda cella nella seconda riga cell = row.AddCell(); //Specifica la larghezza della cella cell.Width = 200; cell.AddParagraph().AppendText("50"); //Aggiunge la terza riga alla tabella row = table.AddRow(true, false); //Aggiunge la prima cella nella terza riga cell = row.AddCell(); //Specifica la larghezza della cella cell.Width = 200; cell.AddParagraph().AppendText("Orange"); //Aggiunge la seconda cella nella terza riga cell = row.AddCell(); //Specifica la larghezza della cella cell.Width = 200; cell.AddParagraph().AppendText("30"); //Aggiunge la quarta riga alla tabella row = table.AddRow(true, false); //Aggiunge la prima cella nella quarta riga cell = row.AddCell(); //Specifica la larghezza della cella cell.Width = 200; cell.AddParagraph().AppendText("Banana"); //Aggiunge la seconda cella nella quarta riga cell = row.AddCell(); //Specifica la larghezza della cella cell.Width = 200; cell.AddParagraph().AppendText("20"); //Aggiunge la quinta riga alla tabella row = table.AddRow(true, false); //Aggiunge la prima cella nella quinta riga cell = row.AddCell(); //Specifica la larghezza della cella cell.Width = 200; cell.AddParagraph().AppendText("Grapes"); //Aggiunge la seconda cella nella quinta riga cell = row.AddCell(); //Specifica la larghezza della cella cell.Width = 200; cell.AddParagraph().AppendText("70"); ////Saves and closes the document instance //document.Save("Table.docx", FormatType.Docx); //Salva il documento su memory stream MemoryStream stream = new MemoryStream(); await document.SaveAsync(stream, FormatType.Docx); document.Close(); //Salva lo stream come file di documento Word nella macchina locale StorageFile stFile = await Save(stream, "Table.docx"); DefaultLaunch("Table.docx"); }
/// <summary> /// Encrypt the word document /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void encrypt_Click(object sender, RoutedEventArgs e) { try { if (this.textBox1.Text != null && this.textBox1.Text != string.Empty) { using (WordDocument document = new WordDocument(this.textBox1.Text)) { // Getting last section of the document. IWSection section = document.LastSection; // Adding a paragraph to the section. IWParagraph paragraph = section.AddParagraph(); // Writing text IWTextRange text = paragraph.AppendText("This document was encrypted with password"); text.CharacterFormat.FontSize = 16f; text.CharacterFormat.FontName = "Bitstream Vera Serif"; // Encrypt the document by giving password document.EncryptDocument(this.passwordBox1.Password); #region Save Document //Save as doc format if (worddoc.IsChecked.Value) { try { //Saving the document to disk. document.Save("Encrypt.doc"); //Message box confirmation to view the created document. if (MessageBox.Show("Do you want to view the generated Word document?", "Document has been created", MessageBoxButton.YesNo, MessageBoxImage.Information) == MessageBoxResult.Yes) { try { //Launching the MS Word file using the default Application.[MS Word Or Free WordViewer] System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo = new System.Diagnostics.ProcessStartInfo("Encrypt.doc") { UseShellExecute = true }; process.Start(); } catch (Win32Exception ex) { MessageBox.Show("Microsoft Word Viewer or Microsoft Word is not installed in this system"); Console.WriteLine(ex.ToString()); } } } catch (Exception ex) { if (ex is IOException) { MessageBox.Show("Please close the file (" + Directory.GetCurrentDirectory() + "\\Encrypt.doc" + ") then try generating the document.", "File is already open", MessageBoxButton.OK, MessageBoxImage.Error); } else { MessageBox.Show("Document could not be generated, Could you please email the error details to [email protected] for trouble shooting" + "\r\n" + ex.ToString(), "Error", MessageBoxButton.OK, MessageBoxImage.Error); } } } //Save as docx format else if (worddocx.IsChecked.Value) { try { //Saving the document as .docx document.Save("Encrypt.docx", FormatType.Docx); //Message box confirmation to view the created document. if (MessageBox.Show("Do you want to view the generated Word document?", "Document has been created", MessageBoxButton.YesNo, MessageBoxImage.Information) == MessageBoxResult.Yes) { try { //Launching the MS Word file using the default Application.[MS Word Or Free WordViewer] System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo = new System.Diagnostics.ProcessStartInfo("Encrypt.docx") { UseShellExecute = true }; process.Start(); } catch (Win32Exception ex) { MessageBox.Show("Microsoft Word Viewer or Microsoft Word is not installed in this system"); Console.WriteLine(ex.ToString()); } } } catch (Exception ex) { if (ex is IOException) { MessageBox.Show("Please close the file (" + Directory.GetCurrentDirectory() + "\\Encrypt.doc" + ") then try generating the document.", "File is already open", MessageBoxButton.OK, MessageBoxImage.Error); } else { MessageBox.Show("Document could not be generated, Could you please email the error details to [email protected] for trouble shooting" + "\r\n" + ex.ToString(), "Error", MessageBoxButton.OK, MessageBoxImage.Error); } } } #endregion } } else { MessageBox.Show("Please browse a Word document to encrypt"); } } catch (Exception Ex) { MessageBox.Show(Ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void button1_Click(object sender, System.EventArgs e) { try { //Creates a new Word document WordDocument document = new WordDocument(); //Adds new section to the document IWSection section = document.AddSection(); //Sets page setup options section.PageSetup.Orientation = PageOrientation.Landscape; section.PageSetup.Margins.All = 72; section.PageSetup.PageSize = new SizeF(792f, 612f); //Adds new paragraph to the section WParagraph paragraph = section.AddParagraph() as WParagraph; //Creates new group shape GroupShape groupShape = new GroupShape(document); //Adds group shape to the paragraph. paragraph.ChildEntities.Add(groupShape); //Create a RoundedRectangle shape with "Management" text CreateChildShape(AutoShapeType.RoundedRectangle, new RectangleF(324f, 107.7f, 144f, 45f), 0, false, false, Color.FromArgb(50, 48, 142), "Management", groupShape, document); //Create a BentUpArrow shape to connect with "Development" shape CreateChildShape(AutoShapeType.BentUpArrow, new RectangleF(177.75f, 176.25f, 210f, 50f), 180, false, false, Color.White, null, groupShape, document); //Create a BentUpArrow shape to connect with "Sales" shape CreateChildShape(AutoShapeType.BentUpArrow, new RectangleF(403.5f, 175.5f, 210f, 50f), 180, true, false, Color.White, null, groupShape, document); //Create a DownArrow shape to connect with "Production" shape CreateChildShape(AutoShapeType.DownArrow, new RectangleF(381f, 153f, 29.25f, 72.5f), 0, false, false, Color.White, null, groupShape, document); //Create a RoundedRectangle shape with "Development" text CreateChildShape(AutoShapeType.RoundedRectangle, new RectangleF(135f, 226.45f, 110f, 40f), 0, false, false, Color.FromArgb(104, 57, 157), "Development", groupShape, document); //Create a RoundedRectangle shape with "Production" text CreateChildShape(AutoShapeType.RoundedRectangle, new RectangleF(341f, 226.5f, 110f, 40f), 0, false, false, Color.FromArgb(149, 50, 118), "Production", groupShape, document); //Create a RoundedRectangle shape with "Sales" text CreateChildShape(AutoShapeType.RoundedRectangle, new RectangleF(546.75f, 226.5f, 110f, 40f), 0, false, false, Color.FromArgb(179, 63, 62), "Sales", groupShape, document); //Create a DownArrow shape to connect with "Software" and "Hardware" shape CreateChildShape(AutoShapeType.DownArrow, new RectangleF(177f, 265.5f, 25.5f, 20.25f), 0, false, false, Color.White, null, groupShape, document); //Create a DownArrow shape to connect with "Series" and "Parts" shape CreateChildShape(AutoShapeType.DownArrow, new RectangleF(383.25f, 265.5f, 25.5f, 20.25f), 0, false, false, Color.White, null, groupShape, document); //Create a DownArrow shape to connect with "North" and "South" shape CreateChildShape(AutoShapeType.DownArrow, new RectangleF(588.75f, 266.25f, 25.5f, 20.25f), 0, false, false, Color.White, null, groupShape, document); //Create a BentUpArrow shape to connect with "Software" shape CreateChildShape(AutoShapeType.BentUpArrow, new RectangleF(129.5f, 286.5f, 60f, 33f), 180, false, false, Color.White, null, groupShape, document); //Create a BentUpArrow shape to connect with "Hardware" shape CreateChildShape(AutoShapeType.BentUpArrow, new RectangleF(190.5f, 286.5f, 60f, 33f), 180, true, false, Color.White, null, groupShape, document); //Create a BentUpArrow shape to connect with "Series" shape CreateChildShape(AutoShapeType.BentUpArrow, new RectangleF(336f, 287.25f, 60f, 33f), 180, false, false, Color.White, null, groupShape, document); //Create a BentUpArrow shape to connect with "Parts" shape CreateChildShape(AutoShapeType.BentUpArrow, new RectangleF(397f, 287.25f, 60f, 33f), 180, true, false, Color.White, null, groupShape, document); //Create a BentUpArrow shape to connect with "North" shape CreateChildShape(AutoShapeType.BentUpArrow, new RectangleF(541.5f, 288f, 60f, 33f), 180, false, false, Color.White, null, groupShape, document); //Create a BentUpArrow shape to connect with "South" shape CreateChildShape(AutoShapeType.BentUpArrow, new RectangleF(602.5f, 288f, 60f, 33f), 180, true, false, Color.White, null, groupShape, document); //Create a RoundedRectangle shape with "Software" text CreateChildShape(AutoShapeType.RoundedRectangle, new RectangleF(93f, 320.25f, 90f, 40f), 0, false, false, Color.FromArgb(23, 187, 189), "Software", groupShape, document); //Create a RoundedRectangle shape with "Hardware" text CreateChildShape(AutoShapeType.RoundedRectangle, new RectangleF(197.2f, 320.25f, 90f, 40f), 0, false, false, Color.FromArgb(24, 159, 106), "Hardware", groupShape, document); //Create a RoundedRectangle shape with "Series" text CreateChildShape(AutoShapeType.RoundedRectangle, new RectangleF(299.25f, 320.25f, 90f, 40f), 0, false, false, Color.FromArgb(23, 187, 189), "Series", groupShape, document); //Create a RoundedRectangle shape with "Parts" text CreateChildShape(AutoShapeType.RoundedRectangle, new RectangleF(404.2f, 320.25f, 90f, 40f), 0, false, false, Color.FromArgb(24, 159, 106), "Parts", groupShape, document); //Create a RoundedRectangle shape with "North" text CreateChildShape(AutoShapeType.RoundedRectangle, new RectangleF(505.5f, 321.75f, 90f, 40f), 0, false, false, Color.FromArgb(23, 187, 189), "North", groupShape, document); //Create a RoundedRectangle shape with "South" text CreateChildShape(AutoShapeType.RoundedRectangle, new RectangleF(609.7f, 321.75f, 90f, 40f), 0, false, false, Color.FromArgb(24, 159, 106), "South", groupShape, document); //Save as docx format if (wordDocxRadioBtn.Checked) { //Saving the document as .docx document.Save("Sample.docx", FormatType.Docx); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated Word document?", "Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { try { //Launching the MS Word file using the default Application.[MS Word Or Free WordViewer] #if NETCORE System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo = new System.Diagnostics.ProcessStartInfo("Sample.docx") { UseShellExecute = true }; process.Start(); #else System.Diagnostics.Process.Start("Sample.docx"); #endif //Exit this.Close(); } catch (Win32Exception ex) { MessageBoxAdv.Show("Microsoft Word Viewer or Microsoft Word is not installed in this system"); Console.WriteLine(ex.ToString()); } } } //Save as pdf format else if (pdfRadioBtn.Checked) { DocToPDFConverter converter = new DocToPDFConverter(); //Convert word document into PDF document PdfDocument pdfDoc = converter.ConvertToPDF(document); //Save the pdf file pdfDoc.Save("Sample.pdf"); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated PDF?", " Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { try { #if NETCORE System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo = new System.Diagnostics.ProcessStartInfo("Sample.pdf") { UseShellExecute = true }; process.Start(); #else System.Diagnostics.Process.Start("Sample.pdf"); #endif //Exit this.Close(); } catch (Exception ex) { MessageBoxAdv.Show("PDF Viewer is not installed in this system"); Console.WriteLine(ex.ToString()); } } } else { // Exit this.Close(); } } catch (Exception Ex) { MessageBox.Show(Ex.Message); } }
private void OnButtonClicked(object sender, EventArgs e) { Assembly assembly = Assembly.GetExecutingAssembly(); //A new document is created. WordDocument document = new WordDocument(); //Add new section to the Word document IWSection section = document.AddSection(); //Set page margins of the section section.PageSetup.Margins.All = 72; //Add new paragraph to the section IWParagraph paragraph = section.AddParagraph(); //Apply heading style to the title paragraph paragraph.ApplyStyle(BuiltinStyle.Heading1); //Apply center alignment to the paragraph paragraph.ParagraphFormat.HorizontalAlignment = HorizontalAlignment.Center; //Append text to the paragraph paragraph.AppendText("Northwind Management Report").CharacterFormat.TextColor = Syncfusion.Drawing.Color.FromArgb(46, 116, 181); //Add new paragraph paragraph = section.AddParagraph(); //Set before spacing to the paragraph paragraph.ParagraphFormat.BeforeSpacing = 20; //Load the excel template as stream Stream excelStream = assembly.GetManifestResourceStream("SampleBrowser.Samples.DocIO.Templates.Excel_Template.xlsx"); //Create and Append chart to the paragraph with excel stream as parameter WChart barChart = paragraph.AppendChart(excelStream, 1, "B2:C6", 470, 300); //Set chart data barChart.ChartType = OfficeChartType.Bar_Clustered; barChart.ChartTitle = "Purchase Details"; barChart.ChartTitleArea.FontName = "Calibri (Body)"; barChart.ChartTitleArea.Size = 14; //Set name to chart series barChart.Series[0].Name = "Sum of Purchases"; barChart.Series[1].Name = "Sum of Future Expenses"; //Set Chart Data table barChart.HasDataTable = true; barChart.DataTable.HasBorders = true; barChart.DataTable.HasHorzBorder = true; barChart.DataTable.HasVertBorder = true; barChart.DataTable.ShowSeriesKeys = true; barChart.HasLegend = false; //Setting background color barChart.ChartArea.Fill.ForeColor = Syncfusion.Drawing.Color.FromArgb(208, 206, 206); barChart.PlotArea.Fill.ForeColor = Syncfusion.Drawing.Color.FromArgb(208, 206, 206); //Setting line pattern to the chart area barChart.PrimaryCategoryAxis.Border.LinePattern = OfficeChartLinePattern.None; barChart.PrimaryValueAxis.Border.LinePattern = OfficeChartLinePattern.None; barChart.ChartArea.Border.LinePattern = OfficeChartLinePattern.None; barChart.PrimaryValueAxis.MajorGridLines.Border.LineColor = Syncfusion.Drawing.Color.FromArgb(175, 171, 171); //Set label for primary catagory axis barChart.PrimaryCategoryAxis.CategoryLabels = barChart.ChartData[2, 1, 6, 1]; #region Saving Document MemoryStream stream = new MemoryStream(); document.Save(stream, FormatType.Word2013); document.Close(); if (stream != null) { SaveAndroid androidSave = new SaveAndroid(); androidSave.Save("BarChart.docx", "application/msword", stream, m_context); } #endregion }
public ActionResult DocumentSettings(string Group1) { if (Group1 == null) { return(View()); } //A new document is created. WordDocument document = new WordDocument(); //Adding a section to the document. IWSection section = document.AddSection(); //Adding a paragraph to the section. IWParagraph paragraph = section.AddParagraph(); #region DocVariable string name = "John Smith"; string address = "Cary, NC"; //Get the variables in the existing document DocVariables dVariable = document.Variables; //Add doc variables dVariable.Add("Customer Name", name); dVariable.Add("Customer Address", address); #endregion DocVariable #region Document Properties //Setting document Properties document.BuiltinDocumentProperties.Author = "Essential DocIO"; document.BuiltinDocumentProperties.ApplicationName = "Essential DocIO"; document.BuiltinDocumentProperties.Category = "Document Generator"; document.BuiltinDocumentProperties.Comments = "This document was generated using Essential DocIO"; document.BuiltinDocumentProperties.Company = "Syncfusion Inc"; document.BuiltinDocumentProperties.Subject = "Native Word Generator"; document.BuiltinDocumentProperties.Keywords = "Syncfusion"; document.BuiltinDocumentProperties.Manager = "Sync Manager"; document.BuiltinDocumentProperties.Title = "Essential DocIO"; // Add a custom document Property document.CustomDocumentProperties.Add("My_Doc_Date", DateTime.Today); document.CustomDocumentProperties.Add("My_Doc", true); document.CustomDocumentProperties.Add("My_ID", 1031); document.CustomDocumentProperties.Add("My_Comment", "Essential DocIO"); //Remove a custome property document.CustomDocumentProperties.Remove("My_Doc"); #endregion Document Properties IWTextRange text = paragraph.AppendText(""); text.CharacterFormat.FontName = "Calibri"; text.CharacterFormat.FontSize = 13; text = paragraph.AppendText("This document is created with various Document Properties Summary Information and page settings information \n\n You can view Document Properties through: File -> Properties -> Summary/Custom."); text.CharacterFormat.FontName = "Calibri"; text.CharacterFormat.FontSize = 13; #region Page setup // Write section properties section.PageSetup.PageSize = new System.Drawing.SizeF(500, 750); section.PageSetup.Orientation = PageOrientation.Landscape; section.PageSetup.Margins.Bottom = 100; section.PageSetup.Margins.Top = 100; section.PageSetup.Margins.Left = 50; section.PageSetup.Margins.Right = 50; section.PageSetup.PageBordersApplyType = PageBordersApplyType.AllPages; section.PageSetup.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.DoubleWave; section.PageSetup.Borders.Color = System.Drawing.Color.DarkBlue; section.PageSetup.VerticalAlignment = PageAlignment.Middle; #endregion Page setup paragraph = section.AddParagraph(); text = paragraph.AppendText(""); text.CharacterFormat.FontName = "Calibri"; text.CharacterFormat.FontSize = 13; text = paragraph.AppendText("\n\n You can view Page setup options through File -> PageSetup."); text.CharacterFormat.FontName = "Calibri"; text.CharacterFormat.FontSize = 13; #region Get document variables paragraph = document.LastSection.AddParagraph(); dVariable = document.Variables; text = paragraph.AppendText("\n\n Document Variables\n"); text.CharacterFormat.FontName = "Calibri"; text.CharacterFormat.FontSize = 13; text.CharacterFormat.Bold = true; text = paragraph.AppendText("\n" + dVariable.GetNameByIndex(1) + ": " + dVariable.GetValueByIndex(1)); text.CharacterFormat.FontName = "Calibri"; text.CharacterFormat.FontSize = 13; //Display the current variable count text = paragraph.AppendText("\n\nDocument Variables Count: " + dVariable.Count); text.CharacterFormat.FontName = "Calibri"; text.CharacterFormat.FontSize = 13; #endregion Get document variables //Save as .doc format if (Group1 == "WordDoc") { return(document.ExportAsActionResult("Sample.doc", FormatType.Doc, HttpContext.ApplicationInstance.Response, HttpContentDisposition.Attachment)); } //Save as .docx format else if (Group1 == "WordDocx") { return(document.ExportAsActionResult("Sample.docx", FormatType.Docx, HttpContext.ApplicationInstance.Response, HttpContentDisposition.Attachment)); } // Save as WordML(.xml) format else if (Group1 == "WordML") { return(document.ExportAsActionResult("Sample.xml", FormatType.WordML, HttpContext.ApplicationInstance.Response, HttpContentDisposition.Attachment)); } return(View()); }
private void btnFill_Click(object sender, EventArgs e) { try { // Create a new document. WordDocument document = new WordDocument("Sample.doc"); IWSection sec = document.LastSection; WTextFormField textFF; WDropDownFormField dropFF; //Access the text field textFF = sec.Body.FormFields[0] as WTextFormField; //Fill value for the textfield textFF.TextRange.Text = "John"; //Access the form field with feild name textFF = sec.Body.FormFields["BirthDayField"] as WTextFormField; textFF.TextRange.Text = "5.13.1980"; textFF = sec.Body.FormFields[2] as WTextFormField; textFF.TextRange.Text = "221b Baker Street"; textFF = sec.Body.FormFields[3] as WTextFormField; textFF.TextRange.Text = "(206)555-3412"; textFF = sec.Body.FormFields[4] as WTextFormField; textFF.TextRange.Text = "*****@*****.**"; dropFF = sec.Body.FormFields[5] as WDropDownFormField; //Set the value dropFF.DropDownSelectedIndex = 1; textFF = sec.Body.FormFields[6] as WTextFormField; textFF.TextRange.Text = "Michigan University"; dropFF = sec.Body.FormFields[7] as WDropDownFormField; dropFF.DropDownSelectedIndex = 1; dropFF = sec.Body.FormFields[8] as WDropDownFormField; dropFF.DropDownSelectedIndex = 2; //Allow only to fill the form. document.ProtectionType = ProtectionType.AllowOnlyFormFields; //Save as doc format if (wordDocRadioBtn.Checked) { //Saving the document to disk. document.Save("Sample.doc"); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated Word document?", "Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { //Launching the MS Word file using the default Application.[MS Word Or Free WordViewer] #if NETCORE System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo = new System.Diagnostics.ProcessStartInfo("Sample.doc") { UseShellExecute = true }; process.Start(); #else System.Diagnostics.Process.Start("Sample.doc"); #endif //Exit this.Close(); } } //Save as docx format else if (wordDocxRadioBtn.Checked) { //Saving the document as .docx document.Save("Sample.docx", FormatType.Docx); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated Word document?", "Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { try { //Launching the MS Word file using the default Application.[MS Word Or Free WordViewer] #if NETCORE System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo = new System.Diagnostics.ProcessStartInfo("Sample.docx") { UseShellExecute = true }; process.Start(); #else System.Diagnostics.Process.Start("Sample.docx"); #endif //Exit this.Close(); } catch (Win32Exception ex) { MessageBoxAdv.Show("Microsoft Word Viewer or Microsoft Word is not installed in this system"); Console.WriteLine(ex.ToString()); } } } //Save as pdf format else if (pdfRadioBtn.Checked) { DocToPDFConverter converter = new DocToPDFConverter(); //Convert word document into PDF document PdfDocument pdfDoc = converter.ConvertToPDF(document); //Save the pdf file pdfDoc.Save("Sample.pdf"); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated PDF?", " Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { try { #if NETCORE System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo = new System.Diagnostics.ProcessStartInfo("Sample.pdf") { UseShellExecute = true }; process.Start(); #else System.Diagnostics.Process.Start("Sample.pdf"); #endif //Exit this.Close(); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } } } else { // Exit this.Close(); } } catch (Exception Ex) { MessageBox.Show(Ex.Message); } }
public MemoryStream ImageInsertion(string documentType) { string basePath = _hostingEnvironment.WebRootPath; string dataPath = basePath + @"\DocIO\rtf-to-doc.rtf"; #region ImageInsertion //Create a new document WordDocument document = new WordDocument(); //Adding a new section to the document. IWSection section = document.AddSection(); section.PageSetup.Margins.All = 72; //Adding a paragraph to the section IWParagraph paragraph = section.AddParagraph(); //Writing text. paragraph.AppendText("This sample demonstrates how to insert Vector and Scalar images inside a document."); //Adding a new paragraph paragraph = section.AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; FileStream imageStream = new FileStream(basePath + @"/images/docio/yahoo.gif", FileMode.Open, FileAccess.Read); //Inserting .gif . WPicture picture = (WPicture)paragraph.AppendPicture(imageStream); //Adding Image caption picture.AddCaption("Figure", CaptionNumberingFormat.Roman, CaptionPosition.AfterImage); ApplyFormattingForCaption(document.LastParagraph); paragraph = section.AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; imageStream = new FileStream(basePath + @"/images/docio/reports.bmp", FileMode.Open, FileAccess.Read); //Inserting .bmp picture = (WPicture)paragraph.AppendPicture(imageStream); //Adding Image caption picture.AddCaption("Figure", CaptionNumberingFormat.Roman, CaptionPosition.AfterImage); ApplyFormattingForCaption(document.LastParagraph); paragraph = section.AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; imageStream = new FileStream(basePath + @"/images/docio/google.png", FileMode.Open, FileAccess.Read); //Inserting .png picture = (WPicture)paragraph.AppendPicture(imageStream); //Adding Image caption picture.AddCaption("Figure", CaptionNumberingFormat.Roman, CaptionPosition.AfterImage); ApplyFormattingForCaption(document.LastParagraph); paragraph = section.AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; imageStream = new FileStream(basePath + @"/images/docio/square.tif", FileMode.Open, FileAccess.Read); //Inserting .tif picture = (WPicture)paragraph.AppendPicture(imageStream); //Adding Image caption picture.AddCaption("Figure", CaptionNumberingFormat.Roman, CaptionPosition.AfterImage); ApplyFormattingForCaption(document.LastParagraph); //Adding a new paragraph. paragraph = section.AddParagraph(); //Setting Alignment for the image. paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; imageStream = new FileStream(basePath + @"/images/docio/ess-chart.emf", FileMode.Open, FileAccess.Read); //Inserting .wmf Image to the document. WPicture mImage = (WPicture)paragraph.AppendPicture(imageStream); //Scaling Image mImage.HeightScale = 50f; mImage.WidthScale = 50f; //Adding Image caption mImage.AddCaption("Figure", CaptionNumberingFormat.Roman, CaptionPosition.AfterImage); ApplyFormattingForCaption(document.LastParagraph); //Updates the fields in Word document document.UpdateDocumentFields(); FormatType type = FormatType.Docx; #region Document SaveOption //Save as .doc format if (documentType == "WordDoc") { type = FormatType.Doc; } //Save as .xml format else if (documentType == "WordML") { type = FormatType.WordML; } #endregion Document SaveOption using (MemoryStream stream = new MemoryStream()) { //Save the created Word document to MemoryStream document.Save(stream, type); document.Close(); stream.Position = 0; return(stream); } }
private void button1_Click(object sender, System.EventArgs e) { try { //Getting Image files path. string dataPath = Application.StartupPath + @"..\..\..\..\..\..\..\..\Common\images\DocIO\"; //Create a new document WordDocument document = new WordDocument(); //Adding a new section to the document. IWSection section = document.AddSection(); //Set Margin of the section section.PageSetup.Margins.All = 72; //Adding a paragraph to the section IWParagraph paragraph = section.AddParagraph(); //Writing text. paragraph.AppendText("This sample demonstrates how to insert Vector and Scalar images inside a document."); //Adding a new paragraph paragraph = section.AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; //Inserting .gif . WPicture mImage = (WPicture)paragraph.AppendPicture(Image.FromFile(dataPath + "yahoo.gif")); //Adding Image caption mImage.AddCaption("Yahoo [.gif Image]", CaptionNumberingFormat.Roman, CaptionPosition.AboveImage); paragraph = section.AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; //Inserting .bmp mImage = (WPicture)paragraph.AppendPicture(Image.FromFile(dataPath + "Reports.bmp")); //Adding Image caption mImage.AddCaption("Reports [.bmp Image]", CaptionNumberingFormat.Roman, CaptionPosition.AboveImage); paragraph = section.AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; //Inserting .png mImage = (WPicture)paragraph.AppendPicture(Image.FromFile(dataPath + "google.PNG")); //Adding Image caption mImage.AddCaption("Google [.png Image]", CaptionNumberingFormat.Roman, CaptionPosition.AboveImage); paragraph = section.AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; //Inserting .tif mImage = (WPicture)paragraph.AppendPicture(Image.FromFile(dataPath + "Square.tif")); //Adding Image caption mImage.AddCaption("Square [.tif Image]", CaptionNumberingFormat.Roman, CaptionPosition.AboveImage); //Adding a new paragraph. paragraph = section.AddParagraph(); //Setting Alignment for the image. paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; //Inserting .emf Image to the document. mImage = (WPicture)paragraph.AppendPicture(Image.FromFile(dataPath + "Ess chart.emf")); //Scaling Image mImage.HeightScale = 50f; mImage.WidthScale = 50f; //Adding Image caption mImage.AddCaption("Chart Vector Image", CaptionNumberingFormat.Roman, CaptionPosition.AboveImage); //Save as doc format if (wordDocRadioBtn.Checked) { //Saving the document to disk. document.Save("Sample.doc"); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated Word document?", "Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { //Launching the MS Word file using the default Application.[MS Word Or Free WordViewer] #if NETCORE System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo = new System.Diagnostics.ProcessStartInfo("Sample.doc") { UseShellExecute = true }; process.Start(); #else System.Diagnostics.Process.Start(@"Sample.doc"); #endif //Exit this.Close(); } } //Save as docx format else if (wordDocxRadioBtn.Checked) { //Saving the document as .docx document.Save("Sample.docx", FormatType.Docx); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated Word document?", "Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { try { //Launching the MS Word file using the default Application.[MS Word Or Free WordViewer] #if NETCORE System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo = new System.Diagnostics.ProcessStartInfo("Sample.docx") { UseShellExecute = true }; process.Start(); #else System.Diagnostics.Process.Start(@"Sample.docx"); #endif //Exit this.Close(); } catch (Win32Exception ex) { MessageBoxAdv.Show("Microsoft Word Viewer or Microsoft Word is not installed in this system"); Console.WriteLine(ex.ToString()); } } } //Save as pdf format else if (pdfRadioBtn.Checked) { DocToPDFConverter converter = new DocToPDFConverter(); //Convert word document into PDF document PdfDocument pdfDoc = converter.ConvertToPDF(document); //Save the pdf file pdfDoc.Save("Sample.pdf"); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated PDF?", " Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { try { #if NETCORE System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo = new System.Diagnostics.ProcessStartInfo("Sample.pdf") { UseShellExecute = true }; process.Start(); #else System.Diagnostics.Process.Start(@"Sample.pdf"); #endif //Exit this.Close(); } catch (Exception ex) { MessageBoxAdv.Show("PDF Viewer is not installed in this system"); Console.WriteLine(ex.ToString()); } } } else { // Exit this.Close(); } } catch (Exception Ex) { MessageBox.Show(Ex.Message); } }
/// <summary> /// Encrypt the selected Word document /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { if (this.txtEncryptSource.Text != null && this.txtEncryptSource.Text != "") { WordDocument document = new WordDocument(this.txtEncryptSource.Text); // Getting last section of the document. IWSection section = document.LastSection; // Adding a paragraph to the section. IWParagraph paragraph = section.AddParagraph(); // Writing text IWTextRange text = paragraph.AppendText("This document was encrypted with password"); text.CharacterFormat.FontSize = 16f; text.CharacterFormat.FontName = "Bitstream Vera Serif"; // Encrypt the document by giving password document.EncryptDocument(txtEnOpen.Text); # region Save Document //Save as doc format if (wordDocRadioBtn.Checked) { //Saving the document to disk. document.Save("Sample.doc"); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated Word document?", "Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { //Launching the MS Word file using the default Application.[MS Word Or Free WordViewer] #if NETCORE System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo = new System.Diagnostics.ProcessStartInfo("Sample.doc") { UseShellExecute = true }; process.Start(); #else System.Diagnostics.Process.Start("Sample.doc"); #endif //Exit this.Close(); } } //Save as docx format else if (wordDocxRadioBtn.Checked) { //Saving the document as .docx document.Save("Sample.docx", FormatType.Docx); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated Word document?", "Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { try { //Launching the MS Word file using the default Application.[MS Word Or Free WordViewer] #if NETCORE System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo = new System.Diagnostics.ProcessStartInfo("Sample.docx") { UseShellExecute = true }; process.Start(); #else System.Diagnostics.Process.Start("Sample.docx"); #endif //Exit this.Close(); } catch (Win32Exception ex) { MessageBoxAdv.Show("Microsoft Word Viewer or Microsoft Word is not installed in this system"); Console.WriteLine(ex.ToString()); } } } else { // Exit this.Close(); } # endregion }
private void button1_Click(object sender, System.EventArgs e) { try { //Random number generator. Random r = new Random(); // List of FontNames. string[] fontNames = { "Arial", "Times New Roman", "Monotype Corsiva", " Book Antiqua ", "Bitstream Vera Sans", "Comic Sans MS", "Microsoft Sans Serif", "Batang" }; // Create a new document. WordDocument document = new WordDocument(); // Adding new section to the document. IWSection section = document.AddSection(); // Set Margin for the document section.PageSetup.Margins.All = 72; // Adding new paragraph to the section. IWParagraph paragraph = section.AddParagraph(); paragraph.AppendText("This sample demonstrates various text and paragraph formatting support."); section.AddParagraph(); section.AddParagraph(); section = document.AddSection(); section.BreakCode = SectionBreakCode.NoBreak; //Adding two columns to the section. section.AddColumn(250, 20); section.AddColumn(250, 20); #region Text Formatting //Create a TextRange IWTextRange text = null; // Writing Text with different Formatting styles. for (int i = 8, j = 0, k = 0; i <= 20; i++, j++, k++) { if (j >= fontNames.Length) { j = 0; } paragraph = section.AddParagraph(); text = paragraph.AppendText("This is " + "[" + fontNames[j] + "] Font"); text.CharacterFormat.FontName = fontNames[j]; text.CharacterFormat.UnderlineStyle = (UnderlineStyle)k; text.CharacterFormat.FontSize = i; text.CharacterFormat.TextColor = Color.FromArgb(r.Next(0, 255), r.Next(0, 255), r.Next(0, 255)); } // More formatting options. section.AddParagraph(); paragraph.ParagraphFormat.ColumnBreakAfter = true; paragraph = section.AddParagraph(); text = paragraph.AppendText("More formatting Options List..."); text.CharacterFormat.FontName = fontNames[2]; text.CharacterFormat.FontSize = 18; section.AddParagraph(); paragraph = section.AddParagraph(); paragraph.AppendText("AllCaps \n\n").CharacterFormat.AllCaps = true; paragraph.AppendText("Bold \n\n").CharacterFormat.Bold = true; paragraph.AppendText("DoubleStrike \n\n").CharacterFormat.DoubleStrike = true; paragraph.AppendText("Emboss \n\n").CharacterFormat.Emboss = true; paragraph.AppendText("Engrave \n\n").CharacterFormat.Engrave = true; paragraph.AppendText("Italic \n\n").CharacterFormat.Italic = true; paragraph.AppendText("Shadow \n\n").CharacterFormat.Shadow = true; paragraph.AppendText("SmallCaps \n\n").CharacterFormat.SmallCaps = true; paragraph.AppendText("Strikeout \n\n").CharacterFormat.Strikeout = true; paragraph.AppendText("Some Text"); paragraph.AppendText("SubScript \n\n").CharacterFormat.SubSuperScript = SubSuperScript.SubScript; paragraph.AppendText("Some Text"); paragraph.AppendText("SuperScript \n\n").CharacterFormat.SubSuperScript = SubSuperScript.SuperScript; paragraph.AppendText("TextBackgroundColor \n\n").CharacterFormat.TextBackgroundColor = Color.LightBlue; #endregion #region Paragraph formattings section = document.AddSection(); section.BreakCode = SectionBreakCode.NewPage; paragraph = section.AddParagraph(); paragraph.AppendText("Following paragraphs illustrates various paragraph formattings"); paragraph = section.AddParagraph(); paragraph.AppendText("This paragraph demonstrates several paragraph formats. It will be used to illustrate Space Before, Space After, and Line Spacing. Space Before tells Microsoft Word how much space to leave before the paragraph. Space After tells Microsoft Word how much space to leave after the paragraph. Line Spacing sets the space between lines within a paragraph.It also explains about first line indentation,backcolor and paragraph border."); paragraph.ParagraphFormat.BeforeSpacing = 20f; paragraph.ParagraphFormat.AfterSpacing = 30f; paragraph.ParagraphFormat.BackColor = Color.LightGray; paragraph.ParagraphFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; paragraph.ParagraphFormat.FirstLineIndent = 20f; paragraph.ParagraphFormat.LineSpacing = 20f; paragraph = section.AddParagraph(); paragraph.AppendText("This is a sample paragraph. It is used to illustrate alignment. Left-justified text is aligned on the left. Right-justified text is aligned with on the right. Centered text is centered between the left and right margins. You can use Center to center your titles. Justified text is flush on both sides."); paragraph.ParagraphFormat.LineSpacing = 20f; paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Right; paragraph.ParagraphFormat.LineSpacingRule = LineSpacingRule.Exactly; section.AddParagraph(); //Adding new paragraph to the section. paragraph = section.AddParagraph(); paragraph.ParagraphFormat.Keep = true; paragraph.AppendText("KEEP TOGETHER ").CharacterFormat.Bold = true; paragraph.AppendText("This is a sample paragraph. It is used to illustrate Keep together of MsWord. You can control where Microsoft Word positions automatic page breaks (page break: The point at which one page ends and another begins. Microsoft Word inserts an 'automatic' (or soft) page break for you, or you can force a page break at a specific location by inserting a 'manual' (or hard) page break.) by setting pagination options.It keeps the lines in a paragraph together when there is page break ").CharacterFormat.FontSize = 12f; for (int i = 0; i < 10; i++) { paragraph.AppendText("Text Body_Text Body_Text Body_Text Body_Text Body_Text Body_Text Body").CharacterFormat.FontSize = 12f; paragraph.ParagraphFormat.LineSpacing = 20f; } paragraph.AppendText(" KEEP TOGETHER END").CharacterFormat.Bold = true; #endregion #region Bullets and Numbering // Adding a new section to the document. section = document.AddSection(); //Set Margin of the document section.PageSetup.Margins.Top = 20; section.PageSetup.Margins.Bottom = 20; section.PageSetup.Margins.Left = 50; section.PageSetup.Margins.Right = 20; // Adding a new paragraph to the document. paragraph = section.AddParagraph(); // Writing text to the current paragraph. paragraph.AppendText("This document demonstrates the Bullets and Numbering functionality. Here fruits are taken as an example to demonstrate the lists. \n\n\n\n"); //Add a new section section1 = document.AddSection(); //Adding two columns to the section. section1.Columns.Add(new Column(document)); section1.Columns.Add(new Column(document)); //Set the columns to be of equal width. section1.MakeColumnsEqual(); // Set section break code as NoBreak. section1.BreakCode = SectionBreakCode.NoBreak; // Set formatting. ProductDetailsInBullets(); // Set Formatting. ProductDetailsInNumbers(); #endregion Bullets and Numbering //Save as doc format if (wordDocRadioBtn.Checked) { //Saving the document to disk. document.Save("Sample.doc"); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated Word document?", "Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { //Launching the MS Word file using the default Application.[MS Word Or Free WordViewer] #if NETCORE System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo = new System.Diagnostics.ProcessStartInfo("Sample.doc") { UseShellExecute = true }; process.Start(); #else System.Diagnostics.Process.Start("Sample.doc"); #endif //Exit this.Close(); } } //Save as docx format else if (wordDocxRadioBtn.Checked) { //Saving the document as .docx document.Save("Sample.docx", FormatType.Docx); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated Word document?", "Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { try { //Launching the MS Word file using the default Application.[MS Word Or Free WordViewer] #if NETCORE System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo = new System.Diagnostics.ProcessStartInfo("Sample.docx") { UseShellExecute = true }; process.Start(); #else System.Diagnostics.Process.Start("Sample.docx"); #endif //Exit this.Close(); } catch (Win32Exception ex) { MessageBoxAdv.Show("Microsoft Word Viewer or Microsoft Word is not installed in this system"); Console.WriteLine(ex.ToString()); } } } //Save as pdf format else if (pdfRadioBtn.Checked) { DocToPDFConverter converter = new DocToPDFConverter(); //Convert word document into PDF document PdfDocument pdfDoc = converter.ConvertToPDF(document); //Save the pdf file pdfDoc.Save("Sample.pdf"); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated PDF?", " Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { try { #if NETCORE System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo = new System.Diagnostics.ProcessStartInfo("Sample.pdf") { UseShellExecute = true }; process.Start(); #else System.Diagnostics.Process.Start("Sample.pdf"); #endif //Exit this.Close(); } catch (Exception ex) { MessageBoxAdv.Show("PDF Viewer is not installed in this system"); Console.WriteLine(ex.ToString()); } } } else { // Exit this.Close(); } } catch (Exception Ex) { MessageBox.Show(Ex.Message); } }
public void CreateDocument() { // выборка данных с группировкой var query = from dogs in db.DOG join dog_awards in db.DOG_AWARD on dogs.DOG_ID equals dog_awards.DOG_ID join award in db.AWARD on dog_awards.AWARD_ID equals award.AWARD_ID join breeds in db.BREED on dogs.ID_BREED equals breeds.BREED_ID group new { dogs, dog_awards, award, breeds } by new { breeds.BREED_NAME, dogs.DOG_NAME, dogs.SEX, dogs.BIRTH_DATE, award.AWARD_NAME, dog_awards.DATE_AWARD } into g orderby g.Key.BREED_NAME, g.Key.DOG_NAME select new { All = g.Key, Age = DbFunctions.DiffYears((DateTime)g.Key.BIRTH_DATE, DateTime.Now) }; //Create document WordDocument document = new WordDocument(); List <string> list = new List <string>(); List <string> breedsDog = new List <string>(); //document.EnsureMinimal(); IWSection section = document.AddSection() as WSection; //Set Margin of the section section.PageSetup.Margins.All = 72; //Set page size of the section //section.PageSetup.PageSize = new System.Drawing.SizeF(612, 792); //Create Paragraph IWParagraph paragraph = section.AddParagraph(); foreach (var el in query.ToList()) { //если такая порода не выводилась, то выводим if (!breedsDog.Contains(el.All.BREED_NAME)) { //Appends table. IWTable table = section.AddTable(); //значение строк и столбцов table.ResetCells(1, 2); //нет границ table.TableFormat.Borders.BorderType = BorderStyle.None; table.TableFormat.IsAutoResized = true; //добавляем в 1 ячейку paragraph = table[0, 0].AddParagraph(); //интервал после 6пт paragraph.ParagraphFormat.AfterSpacing = 6f; // добавляем запись с породой IWTextRange textRangeBreed = paragraph.AppendText(el.All.BREED_NAME); //стили ячейки textRangeBreed.CharacterFormat.Bold = true; textRangeBreed.CharacterFormat.FontName = "Times New Roman"; textRangeBreed.CharacterFormat.FontSize = 14; //добавляем во вторую ячейку paragraph = table[0, 1].AddParagraph(); //интервал после 6пт paragraph.ParagraphFormat.AfterSpacing = 6f; IWTextRange textRangeDate = paragraph.AppendText(DateTime.Now.ToShortDateString()); textRangeDate.CharacterFormat.Bold = true; textRangeDate.CharacterFormat.FontName = "Times New Roman"; textRangeDate.CharacterFormat.FontSize = 14; breedsDog.Add(el.All.BREED_NAME); // добаляем породу в список } if (!list.Contains(el.All.DOG_NAME)) { paragraph = section.AddParagraph(); paragraph.ParagraphFormat.AfterSpacing = 6f; IWTextRange textRange = paragraph.AppendText("Кличка: " + el.All.DOG_NAME + "; " + "\tпол: " + el.All.SEX + " " + "\tвозраст: " + el.Age + "; " + "\t[награда: " + el.All.AWARD_NAME + "; " + "\tдата: " + Convert.ToDateTime(el.All.DATE_AWARD).ToShortDateString() + "]" + "\n"); list.Add(el.All.DOG_NAME); } else { //добовляем текст к последнему созданому параграфу document.LastParagraph.AppendText("\t\t\t\t\t\t\t[награда: " + el.All.AWARD_NAME + "; " + "\tдата: " + Convert.ToDateTime(el.All.DATE_AWARD).ToShortDateString() + "]" + "\n"); } } document.Save("Result.docx", FormatType.Docx, HttpContext.ApplicationInstance.Response, HttpContentDisposition.Attachment); }
void OnConvertClicked(object sender, EventArgs e) { //Creates a new Word document WordDocument document = new WordDocument(); //Adds new section to the document IWSection section = document.AddSection(); //Sets page setup options section.PageSetup.Orientation = PageOrientation.Landscape; section.PageSetup.Margins.All = 72; section.PageSetup.PageSize = new SizeF(792f, 612f); //Adds new paragraph to the section WParagraph paragraph = section.AddParagraph() as WParagraph; //Creates new group shape GroupShape groupShape = new GroupShape(document); //Adds group shape to the paragraph. paragraph.ChildEntities.Add(groupShape); //Create a RoundedRectangle shape with "Management" text CreateChildShape(AutoShapeType.RoundedRectangle, new RectangleF(324f, 107.7f, 144f, 45f), 0, false, false, Syncfusion.Drawing.Color.FromArgb(50, 48, 142), "Management", groupShape, document); //Create a BentUpArrow shape to connect with "Development" shape CreateChildShape(AutoShapeType.BentUpArrow, new RectangleF(177.75f, 176.25f, 210f, 50f), 180, false, false, Syncfusion.Drawing.Color.White, null, groupShape, document); //Create a BentUpArrow shape to connect with "Sales" shape CreateChildShape(AutoShapeType.BentUpArrow, new RectangleF(403.5f, 175.5f, 210f, 50f), 180, true, false, Syncfusion.Drawing.Color.White, null, groupShape, document); //Create a DownArrow shape to connect with "Production" shape CreateChildShape(AutoShapeType.DownArrow, new RectangleF(381f, 153f, 29.25f, 72.5f), 0, false, false, Syncfusion.Drawing.Color.White, null, groupShape, document); //Create a RoundedRectangle shape with "Development" text CreateChildShape(AutoShapeType.RoundedRectangle, new RectangleF(135f, 226.45f, 110f, 40f), 0, false, false, Syncfusion.Drawing.Color.FromArgb(104, 57, 157), "Development", groupShape, document); //Create a RoundedRectangle shape with "Production" text CreateChildShape(AutoShapeType.RoundedRectangle, new RectangleF(341f, 226.5f, 110f, 40f), 0, false, false, Syncfusion.Drawing.Color.FromArgb(149, 50, 118), "Production", groupShape, document); //Create a RoundedRectangle shape with "Sales" text CreateChildShape(AutoShapeType.RoundedRectangle, new RectangleF(546.75f, 226.5f, 110f, 40f), 0, false, false, Syncfusion.Drawing.Color.FromArgb(179, 63, 62), "Sales", groupShape, document); //Create a DownArrow shape to connect with "Software" and "Hardware" shape CreateChildShape(AutoShapeType.DownArrow, new RectangleF(177f, 265.5f, 25.5f, 20.25f), 0, false, false, Syncfusion.Drawing.Color.White, null, groupShape, document); //Create a DownArrow shape to connect with "Series" and "Parts" shape CreateChildShape(AutoShapeType.DownArrow, new RectangleF(383.25f, 265.5f, 25.5f, 20.25f), 0, false, false, Syncfusion.Drawing.Color.White, null, groupShape, document); //Create a DownArrow shape to connect with "North" and "South" shape CreateChildShape(AutoShapeType.DownArrow, new RectangleF(588.75f, 266.25f, 25.5f, 20.25f), 0, false, false, Syncfusion.Drawing.Color.White, null, groupShape, document); //Create a BentUpArrow shape to connect with "Software" shape CreateChildShape(AutoShapeType.BentUpArrow, new RectangleF(129.5f, 286.5f, 60f, 33f), 180, false, false, Syncfusion.Drawing.Color.White, null, groupShape, document); //Create a BentUpArrow shape to connect with "Hardware" shape CreateChildShape(AutoShapeType.BentUpArrow, new RectangleF(190.5f, 286.5f, 60f, 33f), 180, true, false, Syncfusion.Drawing.Color.White, null, groupShape, document); //Create a BentUpArrow shape to connect with "Series" shape CreateChildShape(AutoShapeType.BentUpArrow, new RectangleF(336f, 287.25f, 60f, 33f), 180, false, false, Syncfusion.Drawing.Color.White, null, groupShape, document); //Create a BentUpArrow shape to connect with "Parts" shape CreateChildShape(AutoShapeType.BentUpArrow, new RectangleF(397f, 287.25f, 60f, 33f), 180, true, false, Syncfusion.Drawing.Color.White, null, groupShape, document); //Create a BentUpArrow shape to connect with "North" shape CreateChildShape(AutoShapeType.BentUpArrow, new RectangleF(541.5f, 288f, 60f, 33f), 180, false, false, Syncfusion.Drawing.Color.White, null, groupShape, document); //Create a BentUpArrow shape to connect with "South" shape CreateChildShape(AutoShapeType.BentUpArrow, new RectangleF(602.5f, 288f, 60f, 33f), 180, true, false, Syncfusion.Drawing.Color.White, null, groupShape, document); //Create a RoundedRectangle shape with "Software" text CreateChildShape(AutoShapeType.RoundedRectangle, new RectangleF(93f, 320.25f, 90f, 40f), 0, false, false, Syncfusion.Drawing.Color.FromArgb(23, 187, 189), "Software", groupShape, document); //Create a RoundedRectangle shape with "Hardware" text CreateChildShape(AutoShapeType.RoundedRectangle, new RectangleF(197.2f, 320.25f, 90f, 40f), 0, false, false, Syncfusion.Drawing.Color.FromArgb(24, 159, 106), "Hardware", groupShape, document); //Create a RoundedRectangle shape with "Series" text CreateChildShape(AutoShapeType.RoundedRectangle, new RectangleF(299.25f, 320.25f, 90f, 40f), 0, false, false, Syncfusion.Drawing.Color.FromArgb(23, 187, 189), "Series", groupShape, document); //Create a RoundedRectangle shape with "Parts" text CreateChildShape(AutoShapeType.RoundedRectangle, new RectangleF(404.2f, 320.25f, 90f, 40f), 0, false, false, Syncfusion.Drawing.Color.FromArgb(24, 159, 106), "Parts", groupShape, document); //Create a RoundedRectangle shape with "North" text CreateChildShape(AutoShapeType.RoundedRectangle, new RectangleF(505.5f, 321.75f, 90f, 40f), 0, false, false, Syncfusion.Drawing.Color.FromArgb(23, 187, 189), "North", groupShape, document); //Create a RoundedRectangle shape with "South" text CreateChildShape(AutoShapeType.RoundedRectangle, new RectangleF(609.7f, 321.75f, 90f, 40f), 0, false, false, Syncfusion.Drawing.Color.FromArgb(24, 159, 106), "South", groupShape, document); string fileName = null; string ContentType = null; MemoryStream ms = new MemoryStream(); if (pdfButton != null && (bool)pdfButton.IsChecked) { fileName = "GroupShapes.pdf"; ContentType = "application/pdf"; DocIORenderer renderer = new DocIORenderer(); PdfDocument pdfDoc = renderer.ConvertToPDF(document); pdfDoc.Save(ms); pdfDoc.Close(); } else { fileName = "GroupShapes.docx"; ContentType = "application/msword"; document.Save(ms, FormatType.Docx); } //Reset the stream position ms.Position = 0; //Close the document instance. document.Close(); if (ms != null) { SaveiOS iOSSave = new SaveiOS(); iOSSave.Save(fileName, ContentType, ms as MemoryStream); } }
protected void Button1_Click(object sender, EventArgs e) { // Creating a new document. WordDocument doc = new WordDocument(); // Add a new section to the document. IWSection section1 = doc.AddSection(); //Add different header and footer for first and other pages if (CheckBox2.Checked && CheckBox3.Checked) { // Set the header/footer setup. section1.PageSetup.DifferentFirstPage = true; //Inserts Header Footer for first page InsertFirstPageHeader(doc, section1); //Inserts Header Footer for all pages InsertPageHeader(doc, section1); } //Add first page header and footer if (CheckBox2.Checked && !CheckBox3.Checked) { // Set the header/footer setup. section1.PageSetup.DifferentFirstPage = true; //Inserts Header Footer for first page InsertFirstPageHeader(doc, section1); } //Add header and footer for all the pages if (CheckBox3.Checked && !CheckBox2.Checked) { //Inserts Header Footer for all pages InsertPageHeader(doc, section1); } // Add text to the document body section. IWParagraph par; par = section1.AddParagraph(); //Insert Text into the word Document. StreamReader reader = new StreamReader(ResolveApplicationDataPath_Data("WinFAQ.txt"), System.Text.Encoding.ASCII); string text = reader.ReadToEnd(); par.AppendText(text); if (rdButtonDoc.Checked) { //Save as .doc format doc.Save("Sample.doc", FormatType.Doc, Response, HttpContentDisposition.Attachment); } //Save as .docx format else if (rdButtonDocx.Checked) { doc.Save("Sample.docx", FormatType.Docx, Response, HttpContentDisposition.Attachment); } //Save as WordML(.xml) format else if (rdButtonWordML.Checked) { doc.Save("Sample.xml", FormatType.WordML, Response, HttpContentDisposition.Attachment); } //Save as .pdf format else if (rdButtonPdf.Checked) { DocToPDFConverter converter = new DocToPDFConverter(); PdfDocument pdfDoc = converter.ConvertToPDF(doc); pdfDoc.Save("Sample.pdf", Response, HttpReadType.Save); } }
public ActionResult ImageInsertion(string Group1) { if (Group1 == null) { return(View()); } //Create a new document WordDocument document = new WordDocument(); //Adding a new section to the document. IWSection section = document.AddSection(); //Adding a paragraph to the section IWParagraph paragraph = section.AddParagraph(); //Writing text. paragraph.AppendText("This sample demonstrates how to insert Vector and Scalar images inside a document."); //Adding a new paragraph paragraph = section.AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; string basePath = _hostingEnvironment.WebRootPath; FileStream imageStream = new FileStream(basePath + @"/images/DocIO/yahoo.gif", FileMode.Open, FileAccess.Read); //Inserting .gif . WPicture picture = (WPicture)paragraph.AppendPicture(imageStream); //Adding Image caption picture.AddCaption("Yahoo [.gif Image]", CaptionNumberingFormat.Roman, CaptionPosition.AboveImage); paragraph = section.AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; imageStream = new FileStream(basePath + @"/images/DocIO/Reports.bmp", FileMode.Open, FileAccess.Read); //Inserting .bmp picture = (WPicture)paragraph.AppendPicture(imageStream); //Adding Image caption picture.AddCaption("Reports [.bmp Image]", CaptionNumberingFormat.Roman, CaptionPosition.AboveImage); paragraph = section.AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; imageStream = new FileStream(basePath + @"/images/DocIO/google.png", FileMode.Open, FileAccess.Read); //Inserting .png picture = (WPicture)paragraph.AppendPicture(imageStream); //Adding Image caption picture.AddCaption("Google [.png Image]", CaptionNumberingFormat.Roman, CaptionPosition.AboveImage); paragraph = section.AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; imageStream = new FileStream(basePath + @"/images/DocIO/Square.tif", FileMode.Open, FileAccess.Read); //Inserting .tif picture = (WPicture)paragraph.AppendPicture(imageStream); //Adding Image caption picture.AddCaption("Square [.tif Image]", CaptionNumberingFormat.Roman, CaptionPosition.AboveImage); //Adding a new paragraph. paragraph = section.AddParagraph(); //Setting Alignment for the image. paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; imageStream = new FileStream(basePath + @"/images/DocIO/Ess chart.emf", FileMode.Open, FileAccess.Read); //Inserting .wmf Image to the document. WPicture mImage = (WPicture)paragraph.AppendPicture(imageStream); //Scaling Image mImage.HeightScale = 50f; mImage.WidthScale = 50f; //Adding Image caption mImage.AddCaption("Chart Vector Image", CaptionNumberingFormat.Roman, CaptionPosition.AboveImage); FormatType type = FormatType.Docx; string filename = "Sample.docx"; string contenttype = "application/vnd.ms-word.document.12"; #region Document SaveOption //Save as .doc format if (Group1 == "WordDoc") { type = FormatType.Doc; filename = "Sample.doc"; contenttype = "application/msword"; } //Save as .xml format else if (Group1 == "WordML") { type = FormatType.WordML; filename = "Sample.xml"; contenttype = "application/msword"; } #endregion Document SaveOption MemoryStream ms = new MemoryStream(); document.Save(ms, type); document.Close(); ms.Position = 0; return(File(ms, contenttype, filename)); }
public ActionResult FormatTable(string Group1) { if (Group1 == null) { return(View()); } // Create a new document. WordDocument document = new WordDocument(); // Adding a new section to the document. IWSection section = document.AddSection(); section.PageSetup.DifferentFirstPage = true; IWTextRange textRange; IWParagraph paragraph = section.AddParagraph(); // -------------------------------------------- // Table in page header // -------------------------------------------- IWParagraph hParagraph = new WParagraph(document); hParagraph.AppendText("Header text\r\n").CharacterFormat.FontSize = 14; section.HeadersFooters.FirstPageHeader.Paragraphs.Add(hParagraph); IWTable hTable = document.LastSection.HeadersFooters.FirstPageHeader.AddTable(); hTable.TableFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; hTable.TableFormat.Paddings.All = 5.4f; hTable.ResetCells(2, 2); hTable[0, 0].AddParagraph().AppendText("1"); hTable[0, 1].AddParagraph().AppendText("2"); hTable[1, 0].AddParagraph().AppendText("3"); hTable[1, 1].AddParagraph().AppendText("4"); // -------------------------------------------- // Tiny table // -------------------------------------------- paragraph = section.AddParagraph(); paragraph.AppendText("Tiny table\r\n").CharacterFormat.FontSize = 14; paragraph = section.AddParagraph(); WTextBody textBody = section.Body; IWTable table = textBody.AddTable(); table.ResetCells(2, 2); table.TableFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; table.TableFormat.Paddings.All = 5.4f; WTableRow row_0 = table.Rows[0]; row_0.Cells[0].AddParagraph().AppendText("A"); row_0.Cells[0].AddParagraph().AppendText("AA"); row_0.Cells[0].AddParagraph().AppendText("AAA"); WTableRow row_1 = table.Rows[1]; row_1.Cells[1].AddParagraph().AppendText("B"); row_1.Cells[1].AddParagraph().AppendText("BB\r\nBBB"); row_1.Cells[1].AddParagraph().AppendText("BBB"); textBody.AddParagraph().AppendText("Text after table...").CharacterFormat.FontSize = 14; // -------------------------------------------- // Table with different formatting // -------------------------------------------- section.AddParagraph(); paragraph = section.AddParagraph(); paragraph.AppendText("Table with different formatting\r\n").CharacterFormat.FontSize = 14; paragraph = section.AddParagraph(); textBody = section.Body; table = textBody.AddTable(); table.ResetCells(3, 3); /* ------- First Row -------- */ WTableRow row0 = table.Rows[0]; paragraph = (IWParagraph)row0.Cells[0].AddParagraph(); textRange = paragraph.AppendText("1"); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Left; textRange.CharacterFormat.FontName = "Arial"; textRange.CharacterFormat.Bold = true; textRange.CharacterFormat.FontSize = 14f; row0.Cells[0].CellFormat.Borders.LineWidth = 2f; row0.Cells[0].CellFormat.Borders.Color = Syncfusion.Drawing.Color.Magenta; paragraph = (IWParagraph)row0.Cells[1].AddParagraph(); textRange = paragraph.AppendText("2"); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Right; textRange.CharacterFormat.Emboss = true; textRange.CharacterFormat.FontSize = 15f; row0.Cells[1].CellFormat.Borders.LineWidth = 1.3f; row0.Cells[1].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.DoubleWave; paragraph = (IWParagraph)row0.Cells[2].AddParagraph(); textRange = paragraph.AppendText("3"); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Left; textRange.CharacterFormat.Engrave = true; textRange.CharacterFormat.FontSize = 15f; row0.Cells[2].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Emboss3D; /* ------- Second Row -------- */ WTableRow row1 = table.Rows[1]; paragraph = (IWParagraph)row1.Cells[0].AddParagraph(); textRange = paragraph.AppendText("4"); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; textRange.CharacterFormat.SmallCaps = true; textRange.CharacterFormat.FontName = "Comic Sans MS"; textRange.CharacterFormat.FontSize = 16; row1.Cells[0].CellFormat.Borders.LineWidth = 2f; row1.Cells[0].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.DashDotStroker; paragraph = (IWParagraph)row1.Cells[1].AddParagraph(); textRange = paragraph.AppendText("5"); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; textRange.CharacterFormat.FontName = "Times New Roman"; textRange.CharacterFormat.Shadow = true; textRange.CharacterFormat.TextBackgroundColor = Syncfusion.Drawing.Color.Orange; textRange.CharacterFormat.FontSize = 15f; row1.Cells[1].CellFormat.Borders.LineWidth = 2f; row1.Cells[1].CellFormat.Borders.Color = Syncfusion.Drawing.Color.Brown; paragraph = (IWParagraph)row1.Cells[2].AddParagraph(); textRange = paragraph.AppendText("6"); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; textRange.CharacterFormat.Bold = true; textRange.CharacterFormat.FontSize = 14f; row1.Cells[2].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(51, 51, 101); row1.Cells[2].CellFormat.VerticalAlignment = VerticalAlignment.Middle; /* ------- Third Row -------- */ WTableRow row2 = table.Rows[2]; paragraph = (IWParagraph)row2.Cells[0].AddParagraph(); textRange = paragraph.AppendText("7"); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Right; textRange.CharacterFormat.FontSize = 13f; row2.Cells[0].CellFormat.Borders.LineWidth = 1.5f; row2.Cells[0].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.DashLargeGap; paragraph = (IWParagraph)row2.Cells[1].AddParagraph(); textRange = paragraph.AppendText("8"); textRange.CharacterFormat.TextColor = Syncfusion.Drawing.Color.Blue; textRange.CharacterFormat.FontSize = 16f; row2.Cells[1].CellFormat.Borders.LineWidth = 3f; row2.Cells[1].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Wave; paragraph = (IWParagraph)row2.Cells[2].AddParagraph(); textRange = paragraph.AppendText("9"); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Right; row2.Cells[2].CellFormat.Borders.LineWidth = 2f; row2.Cells[2].CellFormat.Borders.Color = Syncfusion.Drawing.Color.Cyan; row2.Cells[2].CellFormat.Borders.Shadow = true; row2.Cells[2].CellFormat.Borders.Space = 20; // -------------------------------------------- // Table Cell Merging. // -------------------------------------------- section.AddParagraph(); paragraph = section.AddParagraph(); paragraph.AppendText("Table Cell Merging...").CharacterFormat.FontSize = 14; section.AddParagraph(); paragraph = section.AddParagraph(); textBody = section.Body; // Adding a new Table to the textbody. table = textBody.AddTable(); RowFormat format = new RowFormat(); format.Paddings.All = 5; format.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Dot; format.Borders.LineWidth = 2; // Inserting rows to the table. table.ResetCells(6, 6, format, 80); // Table formatting with cell merging. table.Rows[0].Cells[0].CellFormat.HorizontalMerge = CellMerge.Start; table.Rows[0].Cells[1].CellFormat.HorizontalMerge = CellMerge.Continue; table.Rows[0].Cells[0].CellFormat.VerticalAlignment = VerticalAlignment.Middle; table.Rows[0].Cells[0].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(218, 230, 246); IWParagraph par = table.Rows[0].Cells[0].AddParagraph(); par.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; par.AppendText("Horizontal Merge").CharacterFormat.Bold = true; table.Rows[2].Cells[3].CellFormat.VerticalMerge = CellMerge.Start; table.Rows[3].Cells[3].CellFormat.VerticalMerge = CellMerge.Continue; table.Rows[2].Cells[3].CellFormat.VerticalAlignment = VerticalAlignment.Middle; par = table.Rows[2].Cells[3].AddParagraph(); table.Rows[2].Cells[3].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(252, 172, 85); par.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; par.AppendText("Vertical Merge").CharacterFormat.Bold = true; #region Table Cell Spacing. // -------------------------------------------- // Table Cell Spacing. // -------------------------------------------- section.AddParagraph(); paragraph = section.AddParagraph(); paragraph.AppendText("Table Cell spacing...").CharacterFormat.FontSize = 14; section.AddParagraph(); paragraph = section.AddParagraph(); textBody = section.Body; // Adding a new Table to the textbody. table = textBody.AddTable(); table.TableFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; table.TableFormat.Paddings.All = 5.4f; format = new RowFormat(); format.Paddings.All = 5; format.CellSpacing = 2; format.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.DotDash; format.IsBreakAcrossPages = true; table.ResetCells(25, 5, format, 90); IWTextRange text; table.Rows[0].IsHeader = true; for (int i = 0; i < table.Rows[0].Cells.Count; i++) { paragraph = table[0, i].AddParagraph() as WParagraph; paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; text = paragraph.AppendText(string.Format("Header {0}", i + 1)); text.CharacterFormat.Font = new Font("Bitstream Vera Serif", 10); text.CharacterFormat.Bold = true; text.CharacterFormat.TextColor = Syncfusion.Drawing.Color.FromArgb(0, 21, 84); table[0, i].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(203, 211, 226); } for (int i = 1; i < table.Rows.Count; i++) { for (int j = 0; j < 5; j++) { paragraph = table[i, j].AddParagraph() as WParagraph; paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; text = paragraph.AppendText(string.Format("Cell {0} , {1}", i, j + 1)); text.CharacterFormat.TextColor = Syncfusion.Drawing.Color.FromArgb(242, 151, 50); text.CharacterFormat.Bold = true; if (i % 2 != 1) { table[i, j].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(231, 235, 245); } else { table[i, j].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(246, 249, 255); } } } #endregion Table Cell Spacing. #region Nested Table // -------------------------------------------- // Nested Table. // -------------------------------------------- section.AddParagraph(); paragraph = section.AddParagraph(); paragraph.ParagraphFormat.PageBreakBefore = true; paragraph.AppendText("Nested Table...").CharacterFormat.FontSize = 14; section.AddParagraph(); paragraph = section.AddParagraph(); textBody = section.Body; // Adding a new Table to the textbody. table = textBody.AddTable(); format = new RowFormat(); format.Paddings.All = 5; format.CellSpacing = 2.5f; format.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.DotDash; table.ResetCells(5, 3, format, 100); for (int i = 0; i < table.Rows[0].Cells.Count; i++) { paragraph = table[0, i].AddParagraph() as WParagraph; paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; text = paragraph.AppendText(string.Format("Header {0}", i + 1)); text.CharacterFormat.Font = new Font("Bitstream Vera Serif", 10); text.CharacterFormat.Bold = true; text.CharacterFormat.TextColor = Syncfusion.Drawing.Color.FromArgb(0, 21, 84); table[0, i].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(242, 151, 50); } table[0, 2].Width = 200; for (int i = 1; i < table.Rows.Count; i++) { for (int j = 0; j < 3; j++) { paragraph = table[i, j].AddParagraph() as WParagraph; paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; if ((i == 2) && (j == 2)) { text = paragraph.AppendText("Nested Table"); } else { text = paragraph.AppendText(string.Format("Cell {0} , {1}", i, j + 1)); } if ((j == 2)) { table[i, j].Width = 200; } text.CharacterFormat.TextColor = Syncfusion.Drawing.Color.FromArgb(242, 151, 50); text.CharacterFormat.Bold = true; } } // Adding a nested Table. IWTable nestTable = table[2, 2].AddTable(); format = new RowFormat(); format.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.DotDash; format.HorizontalAlignment = RowAlignment.Center; nestTable.ResetCells(3, 3, format, 45); for (int i = 0; i < nestTable.Rows.Count; i++) { for (int j = 0; j < 3; j++) { paragraph = nestTable[i, j].AddParagraph() as WParagraph; paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; nestTable[i, j].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(231, 235, 245); text = paragraph.AppendText(string.Format("Cell {0} , {1}", i, j + 1)); text.CharacterFormat.TextColor = Syncfusion.Drawing.Color.Black; text.CharacterFormat.Bold = true; } } #endregion Nested Table #region Table with Images Assembly execAssem = typeof(DocIOController).GetTypeInfo().Assembly; //Add a new section to the document. section = document.AddSection(); //Add paragraph to the section. paragraph = section.AddParagraph(); //Writing text. textRange = paragraph.AppendText("Table with Images"); textRange.CharacterFormat.FontSize = 13f; textRange.CharacterFormat.TextColor = Syncfusion.Drawing.Color.DarkBlue; textRange.CharacterFormat.Bold = true; //Add paragraph to the section. section.AddParagraph(); paragraph = section.AddParagraph(); text = null; //Adding a new Table to the paragraph. table = section.Body.AddTable(); table.ResetCells(1, 3); //Adding rows to the table. WTableRow row = table.Rows[0]; //Set heading row height row.Height = 25f; //set heading values to the Table. for (int i = 0; i < 3; i++) { //Add paragraph for writing Text to the cells. paragraph = (IWParagraph)row.Cells[i].AddParagraph(); //Set Horizontal Alignment as Center. paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; //Writing Row Heading switch (i) { case 0: text = paragraph.AppendText("SNO"); row.Cells[i].Width = 50f; break; case 1: text = paragraph.AppendText("Drinks"); break; case 2: text = paragraph.AppendText("Showcase Image"); row.Cells[i].Width = 200f; break; } //Set row Heading formatting text.CharacterFormat.Bold = true; text.CharacterFormat.FontName = "Cambria"; text.CharacterFormat.FontSize = 11f; text.CharacterFormat.TextColor = Syncfusion.Drawing.Color.White; //Set row cells formatting row.Cells[i].CellFormat.VerticalAlignment = VerticalAlignment.Middle; row.Cells[i].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(157, 161, 190); row.Cells[i].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; } int sno = 1; //Writing Sno, Product name and Product Images to the Table. row1 = table.AddRow(false); //Writing SNO to the table with formatting text. paragraph = (IWParagraph)row1.Cells[0].AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; text = paragraph.AppendText(sno.ToString()); text.CharacterFormat.Bold = true; text.CharacterFormat.FontSize = 10f; row1.Cells[0].CellFormat.VerticalAlignment = VerticalAlignment.Middle; row1.Cells[0].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; row1.Cells[0].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(217, 223, 239); //Writing Product Name to the table with Formatting. paragraph = (IWParagraph)row1.Cells[1].AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; text = paragraph.AppendText("Apple Juice"); text.CharacterFormat.Bold = true; text.CharacterFormat.FontSize = 10f; text.CharacterFormat.TextColor = Syncfusion.Drawing.Color.FromArgb(50, 65, 124); row1.Cells[1].CellFormat.VerticalAlignment = VerticalAlignment.Middle; row1.Cells[1].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; row1.Cells[1].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(217, 223, 239); //Writing Product Images to the Table. paragraph = (IWParagraph)row1.Cells[2].AddParagraph(); string basePath = _hostingEnvironment.WebRootPath; FileStream imageStream = new FileStream(basePath + @"/images/DocIO/Apple Juice.png", FileMode.Open, FileAccess.Read); paragraph.AppendPicture(imageStream); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; row1.Cells[2].CellFormat.VerticalAlignment = VerticalAlignment.Middle; row1.Cells[2].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; row1.Cells[2].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(217, 223, 239); sno++; row1 = table.AddRow(false); //Writing SNO to the table with formatting text. paragraph = (IWParagraph)row1.Cells[0].AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; text = paragraph.AppendText(sno.ToString()); text.CharacterFormat.Bold = true; text.CharacterFormat.FontSize = 10f; row1.Cells[0].CellFormat.VerticalAlignment = VerticalAlignment.Middle; row1.Cells[0].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; row1.Cells[0].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(217, 223, 239); //Writing Product Name to the table with Formatting. paragraph = (IWParagraph)row1.Cells[1].AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; text = paragraph.AppendText("Grape Juice"); text.CharacterFormat.Bold = true; text.CharacterFormat.FontSize = 10f; text.CharacterFormat.TextColor = Syncfusion.Drawing.Color.FromArgb(50, 65, 124); row1.Cells[1].CellFormat.VerticalAlignment = VerticalAlignment.Middle; row1.Cells[1].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; row1.Cells[1].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(217, 223, 239); //Writing Product Images to the Table. paragraph = (IWParagraph)row1.Cells[2].AddParagraph(); imageStream = new FileStream(basePath + @"/images/DocIO/Grape Juice.png", FileMode.Open, FileAccess.Read); paragraph.AppendPicture(imageStream); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; row1.Cells[2].CellFormat.VerticalAlignment = VerticalAlignment.Middle; row1.Cells[2].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; row1.Cells[2].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(217, 223, 239); sno++; row1 = table.AddRow(false); //Writing SNO to the table with formatting text. paragraph = (IWParagraph)row1.Cells[0].AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; text = paragraph.AppendText(sno.ToString()); text.CharacterFormat.Bold = true; text.CharacterFormat.FontSize = 10f; row1.Cells[0].CellFormat.VerticalAlignment = VerticalAlignment.Middle; row1.Cells[0].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; row1.Cells[0].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(217, 223, 239); //Writing Product Name to the table with Formatting. paragraph = (IWParagraph)row1.Cells[1].AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; text = paragraph.AppendText("Hot Soup"); text.CharacterFormat.Bold = true; text.CharacterFormat.FontSize = 10f; text.CharacterFormat.TextColor = Syncfusion.Drawing.Color.FromArgb(50, 65, 124); row1.Cells[1].CellFormat.VerticalAlignment = VerticalAlignment.Middle; row1.Cells[1].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; row1.Cells[1].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(217, 223, 239); //Writing Product Images to the Table. paragraph = (IWParagraph)row1.Cells[2].AddParagraph(); imageStream = new FileStream(basePath + @"/images/DocIO/Hot Soup.png", FileMode.Open, FileAccess.Read); paragraph.AppendPicture(imageStream); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; row1.Cells[2].CellFormat.VerticalAlignment = VerticalAlignment.Middle; row1.Cells[2].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Single; row1.Cells[2].CellFormat.BackColor = Syncfusion.Drawing.Color.FromArgb(217, 223, 239); sno++; #endregion Table with Images FormatType type = FormatType.Docx; string filename = "Sample.docx"; string contenttype = "application/vnd.ms-word.document.12"; #region Document SaveOption //Save as .doc format if (Group1 == "WordDoc") { type = FormatType.Doc; filename = "Sample.doc"; contenttype = "application/msword"; } //Save as .xml format else if (Group1 == "WordML") { type = FormatType.WordML; filename = "Sample.xml"; contenttype = "application/msword"; } #endregion Document SaveOption MemoryStream ms = new MemoryStream(); document.Save(ms, type); document.Close(); ms.Position = 0; return(File(ms, contenttype, filename)); }
void CreateEndNote(WordDocument document) { //Add a new section to the document. IWSection section = document.AddSection(); //Adding a new paragraph to the section. IWParagraph paragraph = section.AddParagraph(); IWTextRange textRange = paragraph.AppendText("\t\t\t\t\tDemo for Endnote"); textRange.CharacterFormat.TextColor = Color.Black; textRange.CharacterFormat.Bold = true; textRange.CharacterFormat.FontSize = 20; section.AddParagraph(); section.AddParagraph(); paragraph = section.AddParagraph(); WFootnote footnote = new WFootnote(document); footnote = paragraph.AppendFootnote(FootnoteType.Endnote); footnote.MarkerCharacterFormat.SubSuperScript = SubSuperScript.SuperScript; //Insert Text into the paragraph paragraph.AppendText("Google").CharacterFormat.Bold = true; paragraph = section.AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; paragraph.AppendPicture(Image.FromFile(@"..\..\..\..\..\..\..\Common\images\DocIO\google.png")); paragraph = footnote.TextBody.AddParagraph(); paragraph.AppendText(" Google is the most famous search engines in the Word "); section = document.AddSection(); section.BreakCode = SectionBreakCode.NoBreak; //Adding a new paragraph to the section. paragraph = section.AddParagraph(); paragraph = section.AddParagraph(); footnote = paragraph.AppendFootnote(FootnoteType.Endnote); footnote.MarkerCharacterFormat.SubSuperScript = SubSuperScript.SuperScript; //Insert Text into the paragraph paragraph.AppendText("Yahoo").CharacterFormat.Bold = true; paragraph = section.AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; paragraph.AppendPicture(Image.FromFile(@"..\..\..\..\..\..\..\Common\images\DocIO\yahoo.gif")); paragraph = footnote.TextBody.AddParagraph(); paragraph.AppendText(" Yahoo experience makes it easier to discover the news and information that you care about most. "); section = document.AddSection(); section.BreakCode = SectionBreakCode.NoBreak; //Adding a new paragraph to the section. paragraph = section.AddParagraph(); paragraph = section.AddParagraph(); footnote = paragraph.AppendFootnote(FootnoteType.Endnote); footnote.MarkerCharacterFormat.SubSuperScript = SubSuperScript.SuperScript; //Insert Text into the paragraph paragraph.AppendText("Northwind Traders").CharacterFormat.Bold = true; paragraph = section.AddParagraph(); paragraph.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; paragraph.AppendPicture(Image.FromFile(@"..\..\..\..\..\..\..\Common\images\DocIO\Northwind_logo.png")); paragraph = footnote.TextBody.AddParagraph(); paragraph.AppendText(" The Northwind sample database (Northwind.mdb) is included with all versions of Access. It provides data you can experiment with and database objects that demonstrate features you might want to implement in your own databases "); //Set the number format for the Endnote. document.EndnoteNumberFormat = Syncfusion.DocIO.FootEndNoteNumberFormat.LowerCaseRoman; document.RestartIndexForEndnote = Syncfusion.DocIO.EndnoteRestartIndex.DoNotRestart; //Set the Endnote position. document.EndnotePosition = Syncfusion.DocIO.EndnotePosition.DisplayEndOfSection; }
public ActionResult EncryptAndDecrypt(string Group1, string Group2) { if (Group1 == null) { return(View()); } WordDocument document = null; if (Group1 == "CreateEncryptDoc") { document = new WordDocument(); document.EnsureMinimal(); // Getting last section of the document. IWSection section = document.LastSection; // Adding a paragraph to the section. IWParagraph paragraph = section.AddParagraph(); // Writing text IWTextRange text = paragraph.AppendText("This document was encrypted with password"); text.CharacterFormat.FontSize = 16f; text.CharacterFormat.FontName = "Bitstream Vera Serif"; // Encrypt the document by giving password document.EncryptDocument("syncfusion"); } else { // Open an existing template document. string basePath = _hostingEnvironment.WebRootPath; string dataPath = basePath + @"/DocIO/Security Settings.docx"; FileStream fileStream = new FileStream(dataPath, FileMode.Open, FileAccess.Read, FileShare.ReadWrite); document = new WordDocument(fileStream, FormatType.Docx, "syncfusion"); // Getting last section of the document. IWSection section = document.LastSection; // Adding a paragraph to the section. IWParagraph paragraph = section.AddParagraph(); // Writing text IWTextRange text = paragraph.AppendText("\nDemo For Document Decryption with Essential DocIO"); text.CharacterFormat.FontSize = 16f; text.CharacterFormat.FontName = "Bitstream Vera Serif"; text = paragraph.AppendText("\nThis document is Decrypted"); text.CharacterFormat.FontSize = 16f; text.CharacterFormat.FontName = "Bitstream Vera Serif"; } #region Document SaveOption FormatType type = FormatType.Docx; string filename = "EncryptAndDecrypt.docx"; string contenttype = "application/vnd.ms-word.document.12"; //Save as .doc format #endregion Document SaveOption MemoryStream ms = new MemoryStream(); document.Save(ms, type); document.Close(); ms.Position = 0; return(File(ms, contenttype, filename)); }
protected void ExportChart(object sender, Syncfusion.JavaScript.Web.ChartEventArgs e) { string Format = e.Arguments["Format"].ToString(); string FileName = e.Arguments["FileName"].ToString(); string DataURL = e.Arguments["Data"].ToString(); string Orientation = e.Arguments["Orientation"].ToString(); if (Format == "svg") // for svg export { StringWriter oStringWriter = new StringWriter(); oStringWriter.WriteLine(System.Uri.UnescapeDataString(DataURL)); Response.ContentType = "text/plain"; Response.AddHeader("Content-Disposition", String.Format("attachment;filename={0}", ("Chart.svg"))); Response.Clear(); using (StreamWriter writer = new StreamWriter(Response.OutputStream)) { writer.Write(oStringWriter.ToString()); } Response.End(); } else if (Format == "xlsx") // to export as excel { ExcelExport exp = new ExcelExport(); exp.Export(this.Chart1.Model, (IEnumerable)Chart1.DataSource, FileName + ".xlsx", ExcelVersion.Excel2010, null, null); } else { DataURL = DataURL.Remove(0, DataURL.IndexOf(',') + 1); MemoryStream stream = new MemoryStream(Convert.FromBase64String(DataURL)); if (Format == "docx") // to export as word document { WordDocument document = new WordDocument(); IWSection section = document.AddSection(); IWParagraph paragraph = section.AddParagraph(); //Set orientation based on chart width System.Drawing.Image img = System.Drawing.Image.FromStream(stream); if (Orientation == "landscape" || section.PageSetup.ClientWidth < img.Width) { section.PageSetup.Orientation = PageOrientation.Landscape; } else { section.PageSetup.Orientation = PageOrientation.Portrait; } paragraph.AppendPicture(img); img.Dispose(); document.Save(FileName + ".doc", Syncfusion.DocIO.FormatType.Doc, Response, Syncfusion.DocIO.HttpContentDisposition.Attachment); } else if (Format == "pdf") // to export as PDF { PdfDocument pdfDoc = new PdfDocument(); pdfDoc.Pages.Add(); //Set chart width as pdf page width System.Drawing.Image img = System.Drawing.Image.FromStream(stream); pdfDoc.Pages[0].Section.PageSettings.Width = img.Width; img.Dispose(); if (Orientation == "landscape") { pdfDoc.Pages[0].Section.PageSettings.Orientation = PdfPageOrientation.Landscape; } else { pdfDoc.Pages[0].Section.PageSettings.Orientation = PdfPageOrientation.Portrait; } pdfDoc.Pages[0].Graphics.DrawImage(PdfImage.FromStream(stream), new PointF(10, 30)); pdfDoc.Save(FileName + ".pdf", Response, HttpReadType.Save); pdfDoc.Close(); } else // to export as image { stream.WriteTo(Response.OutputStream); Response.ContentType = "application/octet-stream"; Response.AddHeader("Content-Disposition", String.Format("attachment;filename={0}", FileName + "." + Format)); Response.Flush(); stream.Close(); stream.Dispose(); } } }
private void button1_Click(object sender, System.EventArgs e) { try { // Create a new document. WordDocument document = new WordDocument(); // Adding a new section to the document. IWSection section = document.AddSection(); // Adding a new paragraph to the section. IWParagraph paragraph = section.AddParagraph(); #region Document formatting //Set background color. document.Background.Gradient.Color1 = Color.FromArgb(232, 232, 232); document.Background.Gradient.Color2 = Color.FromArgb(255, 255, 255); document.Background.Type = BackgroundType.Gradient; document.Background.Gradient.ShadingStyle = GradientShadingStyle.Horizontal; document.Background.Gradient.ShadingVariant = GradientShadingVariant.ShadingDown; section.PageSetup.Margins.All = 72f; section.PageSetup.PageSize = new SizeF(612, 792); #endregion #region Title Section IWTable table = section.Body.AddTable(); table.ResetCells(1, 2); WTableRow row = table.Rows[0]; row.Height = 25f; IWParagraph cellPara = row.Cells[0].AddParagraph(); #if NETCORE Image img = Image.FromFile(@"..\..\..\..\..\..\..\..\Common\images\DocIO\Image.jpg"); #else Image img = Image.FromFile(@"..\..\..\..\..\..\..\Common\images\DocIO\Image.jpg"); #endif IWPicture pic = cellPara.AppendPicture(img); pic.Height = 80; pic.Width = 180; cellPara = row.Cells[1].AddParagraph(); row.Cells[1].CellFormat.VerticalAlignment = Syncfusion.DocIO.DLS.VerticalAlignment.Middle; row.Cells[1].CellFormat.BackColor = Color.FromArgb(173, 215, 255); IWTextRange txt = cellPara.AppendText("Job Application Form"); cellPara.ParagraphFormat.HorizontalAlignment = Syncfusion.DocIO.DLS.HorizontalAlignment.Center; txt.CharacterFormat.Bold = true; txt.CharacterFormat.FontName = "Arial"; txt.CharacterFormat.FontSize = 18f; row.Cells[0].Width = 200; row.Cells[1].Width = 300; row.Cells[1].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Hairline; #endregion section.AddParagraph(); #region General Information table = section.Body.AddTable(); table.TableFormat.Paddings.All = 5.4f; table.ResetCells(2, 1); row = table.Rows[0]; row.Height = 20; row.Cells[0].Width = 500; cellPara = row.Cells[0].AddParagraph(); row.Cells[0].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Thick; row.Cells[0].CellFormat.Borders.Color = Color.FromArgb(155, 205, 255); row.Cells[0].CellFormat.BackColor = Color.FromArgb(198, 227, 255); row.Cells[0].CellFormat.VerticalAlignment = Syncfusion.DocIO.DLS.VerticalAlignment.Middle; txt = cellPara.AppendText(" General Information"); txt.CharacterFormat.FontName = "Arial"; txt.CharacterFormat.Bold = true; txt.CharacterFormat.FontSize = 11f; row = table.Rows[1]; cellPara = row.Cells[0].AddParagraph(); row.Cells[0].Width = 500; row.Cells[0].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Hairline; row.Cells[0].CellFormat.Borders.Color = Color.FromArgb(155, 205, 255); row.Cells[0].CellFormat.BackColor = Color.FromArgb(222, 239, 255); txt = cellPara.AppendText("\n Full Name:\t\t\t\t"); txt.CharacterFormat.FontName = "Arial"; txt.CharacterFormat.FontSize = 11f; WTextFormField txtField = cellPara.AppendTextFormField(null); txtField.TextRange.CharacterFormat.TextColor = Color.MidnightBlue; txtField.TextRange.CharacterFormat.FontName = "Arial"; txtField.TextRange.CharacterFormat.FontSize = 11f; txt = cellPara.AppendText("\n\n Birth Date:\t\t\t\t"); txt.CharacterFormat.FontName = "Arial"; txt.CharacterFormat.FontSize = 11f; txtField = cellPara.AppendTextFormField("BirthDayField", DateTime.Now.ToString("M/d/yyyy")); txtField.StringFormat = "M/d/yyyy"; txtField.Type = TextFormFieldType.DateText; txtField.TextRange.CharacterFormat.TextColor = Color.MidnightBlue; txtField.TextRange.CharacterFormat.FontName = "Arial"; txtField.TextRange.CharacterFormat.FontSize = 11f; txtField.CharacterFormat.TextColor = Color.MidnightBlue; txtField.CharacterFormat.FontName = "Arial"; txtField.CharacterFormat.FontSize = 11f; txt = cellPara.AppendText("\n\n Address:\t\t\t\t"); txt.CharacterFormat.FontName = "Arial"; txt.CharacterFormat.FontSize = 11f; txtField = cellPara.AppendTextFormField(null); txtField.Type = TextFormFieldType.RegularText; txtField.TextRange.CharacterFormat.TextColor = Color.MidnightBlue; txtField.TextRange.CharacterFormat.FontName = "Arial"; txtField.TextRange.CharacterFormat.FontSize = 11f; txt = cellPara.AppendText("\n\n Phone:\t\t\t\t"); txt.CharacterFormat.FontName = "Arial"; txt.CharacterFormat.FontSize = 11f; txtField = cellPara.AppendTextFormField(null); txtField.TextRange.CharacterFormat.TextColor = Color.MidnightBlue; txtField.TextRange.CharacterFormat.FontName = "Arial"; txtField.TextRange.CharacterFormat.FontSize = 11f; txt = cellPara.AppendText("\n\n Email:\t\t\t\t\t"); txt.CharacterFormat.FontName = "Arial"; txt.CharacterFormat.FontSize = 11f; txtField = cellPara.AppendTextFormField(null); txtField.TextRange.CharacterFormat.TextColor = Color.MidnightBlue; txtField.TextRange.CharacterFormat.FontName = "Arial"; txtField.TextRange.CharacterFormat.FontSize = 11f; cellPara.AppendText("\n"); #endregion section.AddParagraph(); #region Educational Qualification table = section.Body.AddTable(); table.TableFormat.Paddings.All = 5.4f; table.ResetCells(2, 1); row = table.Rows[0]; row.Height = 20; row.Cells[0].Width = 500; cellPara = row.Cells[0].AddParagraph(); row.Cells[0].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Thick; row.Cells[0].CellFormat.Borders.Color = Color.FromArgb(155, 205, 255); row.Cells[0].CellFormat.BackColor = Color.FromArgb(198, 227, 255); row.Cells[0].CellFormat.VerticalAlignment = Syncfusion.DocIO.DLS.VerticalAlignment.Middle; txt = cellPara.AppendText(" Educational Qualification"); txt.CharacterFormat.FontName = "Arial"; txt.CharacterFormat.Bold = true; txt.CharacterFormat.FontSize = 11f; row = table.Rows[1]; cellPara = row.Cells[0].AddParagraph(); row.Cells[0].Width = 500; row.Cells[0].CellFormat.Borders.BorderType = Syncfusion.DocIO.DLS.BorderStyle.Hairline; row.Cells[0].CellFormat.Borders.Color = Color.FromArgb(155, 205, 255); row.Cells[0].CellFormat.BackColor = Color.FromArgb(222, 239, 255); txt = cellPara.AppendText("\n Type:\t\t\t\t\t"); txt.CharacterFormat.FontName = "Arial"; txt.CharacterFormat.FontSize = 11f; WDropDownFormField dropField = cellPara.AppendDropDownFormField(); dropField.DropDownItems.Add("Higher"); dropField.DropDownItems.Add("Vocational"); dropField.DropDownItems.Add("Universal"); dropField.CharacterFormat.TextColor = Color.MidnightBlue; dropField.CharacterFormat.FontName = "Arial"; dropField.CharacterFormat.FontSize = 11f; txt = cellPara.AppendText("\n\n Institution:\t\t\t\t"); txt.CharacterFormat.FontName = "Arial"; txt.CharacterFormat.FontSize = 11f; txtField = cellPara.AppendTextFormField(null); txtField.TextRange.CharacterFormat.TextColor = Color.MidnightBlue; txtField.TextRange.CharacterFormat.FontName = "Arial"; txtField.CharacterFormat.FontSize = 11f; txt = cellPara.AppendText("\n\n Programming Languages:"); txt.CharacterFormat.FontName = "Arial"; txt.CharacterFormat.FontSize = 11f; txt = cellPara.AppendText("\n\n\t C#:\t\t\t\t"); txt.CharacterFormat.FontName = "Arial"; txt.CharacterFormat.FontSize = 9f; dropField = cellPara.AppendDropDownFormField(); dropField.DropDownItems.Add("Perfect"); dropField.DropDownItems.Add("Good"); dropField.DropDownItems.Add("Excellent"); dropField.CharacterFormat.TextColor = Color.MidnightBlue; dropField.CharacterFormat.FontName = "Arial"; dropField.CharacterFormat.FontSize = 11f; txt = cellPara.AppendText("\n\n\t VB:\t\t\t\t"); txt.CharacterFormat.FontName = "Arial"; txt.CharacterFormat.FontSize = 9f; dropField = cellPara.AppendDropDownFormField(); dropField.DropDownItems.Add("Perfect"); dropField.DropDownItems.Add("Good"); dropField.DropDownItems.Add("Excellent"); dropField.CharacterFormat.TextColor = Color.MidnightBlue; dropField.CharacterFormat.FontName = "Arial"; dropField.CharacterFormat.FontSize = 11f; #endregion btnFill.Enabled = true; //Protect document document.ProtectionType = ProtectionType.AllowOnlyFormFields; document.Save("Sample.doc", FormatType.Doc); //Save as doc format if (wordDocRadioBtn.Checked) { //Saving the document to disk. document.Save("Sample.doc"); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated Word document?", "Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { //Launching the MS Word file using the default Application.[MS Word Or Free WordViewer] #if NETCORE System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo = new System.Diagnostics.ProcessStartInfo("Sample.doc") { UseShellExecute = true }; process.Start(); #else System.Diagnostics.Process.Start("Sample.doc"); #endif //Exit this.Close(); } } //Save as docx format else if (wordDocxRadioBtn.Checked) { //Saving the document as .docx document.Save("Sample.docx", FormatType.Docx); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated Word document?", "Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { try { //Launching the MS Word file using the default Application.[MS Word Or Free WordViewer] #if NETCORE System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo = new System.Diagnostics.ProcessStartInfo("Sample.docx") { UseShellExecute = true }; process.Start(); #else System.Diagnostics.Process.Start("Sample.docx"); #endif //Exit this.Close(); } catch (Win32Exception ex) { MessageBoxAdv.Show("Microsoft Word Viewer or Microsoft Word is not installed in this system"); Console.WriteLine(ex.ToString()); } } } //Save as pdf format else if (pdfRadioBtn.Checked) { DocToPDFConverter converter = new DocToPDFConverter(); //Convert word document into PDF document PdfDocument pdfDoc = converter.ConvertToPDF(document); //Save the pdf file pdfDoc.Save("Sample.pdf"); //Message box confirmation to view the created document. if (MessageBoxAdv.Show("Do you want to view the generated PDF?", " Document has been created", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { try { #if NETCORE System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo = new System.Diagnostics.ProcessStartInfo("Sample.pdf") { UseShellExecute = true }; process.Start(); #else System.Diagnostics.Process.Start("Sample.pdf"); #endif //Exit this.Close(); } catch (Exception ex) { MessageBoxAdv.Show("PDF Viewer is not installed in this system"); Console.WriteLine(ex.ToString()); } } } else { // Exit this.Close(); } } catch (Exception Ex) { MessageBox.Show(Ex.Message); } }
void OnButtonClicked(object sender, EventArgs e) { Assembly assembly = typeof(CreateEquation).GetTypeInfo().Assembly; //Creates a new word document instance WordDocument document = new WordDocument(); //Adds new section to the document IWSection section = document.AddSection(); //Sets page margins document.LastSection.PageSetup.Margins.All = 72; //Adds new paragraph to the section IWParagraph paragraph = section.AddParagraph(); //Appends text to paragraph IWTextRange textRange = paragraph.AppendText("Mathematical equations"); textRange.CharacterFormat.FontSize = 28; paragraph.ParagraphFormat.HorizontalAlignment = HorizontalAlignment.Center; paragraph.ParagraphFormat.AfterSpacing = 12; #region Sum to the power of n //Adds new paragraph to the section paragraph = AddParagraph(section, "This is an expansion of the sum (1+X) to the power of n."); //Creates an equation with sum to the power of N CreateSumToThePowerOfN(paragraph); #endregion #region Fourier series //Adds new paragraph to the section paragraph = AddParagraph(section, "This is a Fourier series for the function of period 2L"); //Creates a Fourier series equation CreateFourierseries(paragraph); #endregion #region Triple scalar product //Adds new paragraph to the section paragraph = AddParagraph(section, "This is an expansion of triple scalar product"); //Creates a triple scalar product equation CreateTripleScalarProduct(paragraph); #endregion #region Gamma function //Adds new paragraph to the section paragraph = AddParagraph(section, "This is an expansion of gamma function"); //Creates a gamma function equation CreateGammaFunction(paragraph); #endregion #region Vector relation //Adds new paragraph to the section paragraph = AddParagraph(section, "This is an expansion of vector relation "); //Creates a vector relation equation CreateVectorRelation(paragraph); #endregion MemoryStream stream = new MemoryStream(); document.Save(stream, FormatType.Docx); document.Close(); if (Device.RuntimePlatform == Device.UWP) { Xamarin.Forms.DependencyService.Get <ISaveWindowsPhone>().Save("CreateEquation.docx", "application/msword", stream); } else { Xamarin.Forms.DependencyService.Get <ISave>().Save("CreateEquation.docx", "application/msword", stream); } }
void OnButtonClicked(object sender, EventArgs e) { //Creates a new word document instance WordDocument document = new WordDocument(); //Adds new section to the document IWSection section = document.AddSection(); //Sets page margins document.LastSection.PageSetup.Margins.All = 72; //Adds new paragraph to the section IWParagraph paragraph = section.AddParagraph(); //Appends text to paragraph IWTextRange textRange = paragraph.AppendText("Mathematical equations"); textRange.CharacterFormat.FontSize = 28; paragraph.ParagraphFormat.HorizontalAlignment = HorizontalAlignment.Center; paragraph.ParagraphFormat.AfterSpacing = 12; #region Sum to the power of n //Adds new paragraph to the section paragraph = AddParagraph(section, "This is an expansion of the sum (1+X) to the power of n."); //Creates an equation with sum to the power of N CreateSumToThePowerOfN(paragraph); #endregion #region Fourier series //Adds new paragraph to the section paragraph = AddParagraph(section, "This is a Fourier series for the function of period 2L"); //Creates a Fourier series equation CreateFourierseries(paragraph); #endregion #region Triple scalar product //Adds new paragraph to the section paragraph = AddParagraph(section, "This is an expansion of triple scalar product"); //Creates a triple scalar product equation CreateTripleScalarProduct(paragraph); #endregion #region Gamma function //Adds new paragraph to the section paragraph = AddParagraph(section, "This is an expansion of gamma function"); //Creates a gamma function equation CreateGammaFunction(paragraph); #endregion #region Vector relation //Adds new paragraph to the section paragraph = AddParagraph(section, "This is an expansion of vector relation "); //Creates a vector relation equation CreateVectorRelation(paragraph); #endregion MemoryStream stream = new MemoryStream(); document.Save(stream, FormatType.Docx); document.Close(); if (stream != null) { SaveAndroid androidSave = new SaveAndroid(); androidSave.Save("CreateEquation.docx", "application/msword", stream, m_context); } }