Insert Image in Excel in C#, VB.NET
Users are allowed to insert image in Excel files. With image, the appearance of Excel file will be more beautiful. Besides decorating, some images are related to data information in Excel. For example, the image will be a chart. These images can make readers learn data information more clearly. This guide will show an easy method to insert image in Excel with C#, VB.NET
Spire.XLS for .NET, a professional component to operating Excel files, enables users to insert image in Excel by using C# and VB.NET. This guide focuses on how to easily insert image in Excel by using Spire.XLS for .NET. Developers can use sheet.Pictures.Add(int toprow, int leftcolumn, filename string) method to insert image in Excel directly. Below demonstrates an Excel with an image of flower.
Download and install Spire.XLS for .NET and then use the following code to insert image.
using Spire.Xls; namespace InsertImage { class Program { static void Main(string[] args) { //Create Workbook Workbook workbook = new Workbook(); Worksheet sheet = workbook.Worksheets[0]; //Insert Image sheet.Pictures.Add(1, 1, @"E:\work\sample.jpg"); //Save and Launch workbook.SaveToFile("ExcelImage.xlsx", ExcelVersion.Version2010); System.Diagnostics.Process.Start("ExcelImage.xlsx"); } } }
Imports Spire.Xls Namespace InsertImage Friend Class Program Shared Sub Main(ByVal args() As String) 'Create Workbook Dim workbook As New Workbook() Dim sheet As Worksheet = workbook.Worksheets(0) 'Insert Image sheet.Pictures.Add(1, 1, "E:\work\sample.jpg") 'Save and Launch workbook.SaveToFile("ExcelImage.xlsx", ExcelVersion.Version2010) System.Diagnostics.Process.Start("ExcelImage.xlsx") End Sub End Class End Namespace
Create Excel Pie Chart in C#, VB.NET
Why We Create Excel Pie Charts?
Create excel pie charts is a simple method to display your data to other individuals or a group. Excel pie charts can easily relay your messages that may otherwise go unnoticed by your audience. Pie charts are helpful for international audiences because they are universally known and easily explained. And it's extremely easy to create and use in Excel.
Pie charts, unlike other charts in Microsoft Excel, require the data in your worksheet be contained in only one row or column. By indicating a "category", an additional row or column can be used. Relative sizes are easy to compare as each piece of data is represented as a portion of a whole.
How to Create Excel Pie Charts in Microsoft Excel?
Every one of you can create excel pie charts in no time by using Microsoft Excel through the following steps:
- Launch Microsoft Office Excel and open your excel file which with the data that you want to base your pie chart on.
- Select the data that you want to base your chart on. The last cell that you want to select will not be chosen but it will have bold outline borders around it.
- Click "Insert" button to open Chart Wizard window. Click on "Pie" in the right side column of Chart Type. Several sub-types of pie charts will be offered for you to choose. Pick a proper type which can best match with your data and click "Next"
- Prevew on this new interface. If the pie chart with wrong information or even no pie chart appears, click "Cancel" and select your data, try the above process again. If everything is OK, click "Next"
- On the new window, enter labels and a title for your pie chart. Click "Finish" when you see the pie chart appears as you want.
- On your spreadsheet, click the box and drag your mouse to manipulate the size of the chart. By right clicking the chart and box, you can get many options to edit the pie chart.
How to Use Spire.XLS for .NET to Creat Excel Pie Charts?
Spire.XLS presents you an easy way to create a pie chart in the Excel workbook. First, you should create a pie chart with the sheet.Charts.Add method. You may control the resource of the data and title of the chart by setting DataRange and ChartTitle properties. What's more, we create an object to operate more about the chart. You may set the label and value of the pie with the properties cs.CategoryLabels and cs.Values. If you want to hide the value of the pie, you may set the cs.DataPoints.DefaultDataPoint.DataLabels.HasValue property false. In this demo, in order to reflect the effect of the chart, we set the grid lines of the worksheet invisible by assigning the sheet.GridLinesVisible false.
Use the C#/VB.NET codes of Spire.XLS for .NET below to create excel pie charts:
using Spire.Xls; using System.Drawing; namespace Saveas { class Program { static void Main(string[] args) { //Create a new workbook Workbook workbook = new Workbook(); //Initialize worksheet workbook.CreateEmptySheets(1); Worksheet sheet = workbook.Worksheets[0]; //Set sheet name sheet.Name = "Chart data"; //Set the grid lines invisible sheet.GridLinesVisible = false; //Create a chart Chart chart = sheet.Charts.Add(ExcelChartType.Pie3D); //Set region of chart data chart.DataRange = sheet.Range["B2:B5"]; chart.SeriesDataFromRange = false; //Set position of chart chart.LeftColumn = 1; chart.TopRow = 6; chart.RightColumn = 9; chart.BottomRow = 25; //Chart title chart.ChartTitle = "Sales by year"; chart.ChartTitleArea.IsBold = true; chart.ChartTitleArea.Size = 12; //Initialize the chart series Spire.Xls.Charts.ChartSerie cs = chart.Series[0]; //Chart Labels resource cs.CategoryLabels = sheet.Range["A2:A5"]; //Chart value resource cs.Values = sheet.Range["B2:B5"]; //Set the value visible in the chart cs.DataPoints.DefaultDataPoint.DataLabels.HasValue = true; //Year sheet.Range["A1"].Value = "Year"; sheet.Range["A2"].Value = "2002"; sheet.Range["A3"].Value = "2003"; sheet.Range["A4"].Value = "2004"; sheet.Range["A5"].Value = "2005"; //Sales sheet.Range["B1"].Value = "Sales"; sheet.Range["B2"].NumberValue = 4000; sheet.Range["B3"].NumberValue = 6000; sheet.Range["B4"].NumberValue = 7000; sheet.Range["B5"].NumberValue = 8500; //Style sheet.Range["A1:B1"].Style.Font.IsBold = true; sheet.Range["A2:B2"].Style.KnownColor = ExcelColors.LightYellow; sheet.Range["A3:B3"].Style.KnownColor = ExcelColors.LightGreen1; sheet.Range["A4:B4"].Style.KnownColor = ExcelColors.LightOrange; sheet.Range["A5:B5"].Style.KnownColor = ExcelColors.LightTurquoise; //Border sheet.Range["A1:B5"].Style.Borders[BordersLineType.EdgeTop].Color = Color.FromArgb(0, 0, 128); sheet.Range["A1:B5"].Style.Borders[BordersLineType.EdgeTop].LineStyle = LineStyleType.Thin; sheet.Range["A1:B5"].Style.Borders[BordersLineType.EdgeBottom].Color = Color.FromArgb(0, 0, 128); sheet.Range["A1:B5"].Style.Borders[BordersLineType.EdgeBottom].LineStyle = LineStyleType.Thin; sheet.Range["A1:B5"].Style.Borders[BordersLineType.EdgeLeft].Color = Color.FromArgb(0, 0, 128); sheet.Range["A1:B5"].Style.Borders[BordersLineType.EdgeLeft].LineStyle = LineStyleType.Thin; sheet.Range["A1:B5"].Style.Borders[BordersLineType.EdgeRight].Color = Color.FromArgb(0, 0, 128); sheet.Range["A1:B5"].Style.Borders[BordersLineType.EdgeRight].LineStyle = LineStyleType.Thin; //Number format sheet.Range["B2:C5"].Style.NumberFormat = "\"$\"#,##0"; chart.PlotArea.Fill.Visible = false; //Save the file workbook.SaveToFile("Sample.xls",ExcelVersion.Version97to2003); //Launch the file System.Diagnostics.Process.Start("Sample.xls"); } }
Imports Spire.Xls Imports System.Drawing Module Module1 Sub Main() 'Create a new workbook Dim workbook As New Workbook() 'Initialize worksheet workbook.CreateEmptySheets(1) Dim sheet As Worksheet = workbook.Worksheets(0) 'Set sheet name sheet.Name = "Chart data" 'Set the grid lines invisible sheet.GridLinesVisible = False 'Create a chart Dim chart As Chart = sheet.Charts.Add(ExcelChartType.Pie3D) 'Set region of chart data chart.DataRange = sheet.Range("B2:B5") chart.SeriesDataFromRange = False 'Set position of chart chart.LeftColumn = 1 chart.TopRow = 6 chart.RightColumn = 9 chart.BottomRow = 25 'Chart title chart.ChartTitle = "Sales by year" chart.ChartTitleArea.IsBold = True chart.ChartTitleArea.Size = 12 'Set the chart Dim cs As Spire.Xls.Charts.ChartSerie = chart.Series(0) 'Chart Labels resource cs.CategoryLabels = sheet.Range("A2:A5") 'Chart value resource cs.Values = sheet.Range("B2:B5") 'Set the value visible in the chart cs.DataPoints.DefaultDataPoint.DataLabels.HasValue = True 'Year sheet.Range("A1").Value = "Year" sheet.Range("A2").Value = "2002" sheet.Range("A3").Value = "2003" sheet.Range("A4").Value = "2004" sheet.Range("A5").Value = "2005" 'Sales sheet.Range("B1").Value = "Sales" sheet.Range("B2").NumberValue = 4000 sheet.Range("B3").NumberValue = 6000 sheet.Range("B4").NumberValue = 7000 sheet.Range("B5").NumberValue = 8500 'Style sheet.Range("A1:B1").Style.Font.IsBold = True sheet.Range("A2:B2").Style.KnownColor = ExcelColors.LightYellow sheet.Range("A3:B3").Style.KnownColor = ExcelColors.LightGreen1 sheet.Range("A4:B4").Style.KnownColor = ExcelColors.LightOrange sheet.Range("A5:B5").Style.KnownColor = ExcelColors.LightTurquoise 'Border sheet.Range("A1:B5").Style.Borders(BordersLineType.EdgeTop).Color = Color.FromArgb(0, 0, 128) sheet.Range("A1:B5").Style.Borders(BordersLineType.EdgeTop).LineStyle = LineStyleType.Thin sheet.Range("A1:B5").Style.Borders(BordersLineType.EdgeBottom).Color = Color.FromArgb(0, 0, 128) sheet.Range("A1:B5").Style.Borders(BordersLineType.EdgeBottom).LineStyle = LineStyleType.Thin sheet.Range("A1:B5").Style.Borders(BordersLineType.EdgeLeft).Color = Color.FromArgb(0, 0, 128) sheet.Range("A1:B5").Style.Borders(BordersLineType.EdgeLeft).LineStyle = LineStyleType.Thin sheet.Range("A1:B5").Style.Borders(BordersLineType.EdgeRight).Color = Color.FromArgb(0, 0, 128) sheet.Range("A1:B5").Style.Borders(BordersLineType.EdgeRight).LineStyle = LineStyleType.Thin 'Number format sheet.Range("B2:C5").Style.NumberFormat = """$""#,##0" chart.PlotArea.Fill.Visible = False 'Save doc file. workbook.SaveToFile("Sample.xls",ExcelVersion.Version97to2003) 'Launch the MS Word file. System.Diagnostics.Process.Start("Sample.xls") End Sub End Module
After running the demo, you may find a pie appear in the document:
Create Word Table in C#, VB.NET
Word Table can save and display data to enable readers to get information more clearly. Users can insert table in Word document with specified rows, columns and format cells to have a good appearance. This guide introduces a solution to create Word table with data and format cells in C# and VB.NET via Spire.Doc for .NET. The screenshot below presents result after creating and formatting Word table.
Spire.Doc for .NET, the professional .NET Word component to operate Word document, provides a Table class to perform tasks on table, for example, including rows, columns, cells and table layout operation. The following will show a specified example to create Word table step by step.
Download and install Spire.Doc for .NET at the beginning and follow steps.
- Firstly, create a new Document class instance and add a new Section in this instance. Invoke Section.AddTable(bool ShowBorder) method to create a table with or without borders.
- Secondly, initialize two String array instances, Header and data to fill table soon.
- Thirdly, Invoke Table.ResetCells(int rowsNum, int columnsNum) method to reset rows and columns numbers.
- Fourthly, fill and format data in table. Create header row at first. Initialize a TableRow instance FRow and set its IsHeader property as true, Height property as a float value and BackColor of RowFormat property as a specified color.
- Use for loop to fill Header in this TableRow instance and format each cell. Set VerticalAlignment of CellFormat property of FRow.
- Then, initialize a Paragraph instance p for Cells of FRow. Set HorizontalAlignment of Format property of p.
- Next, Initialize a TextRange instance TR which stores String array Header.
- Set CharacterFormat property, including FontName, FontSize, TextColor and Bold for TR.
- Create data row now. Initialize another TableRow instance DataRow and set Height property.
- Then, fill this instance with String array data and format cells as operating on FRow.
using System; using System.Data; using System.Drawing; using Spire.Doc; using Spire.Doc.Documents; using Spire.Doc.Fields; namespace WordTable { class Program { static void Main(string[] args) { //Create Table Document doc = new Document(); Section s = doc.AddSection(); Table table =s.AddTable(true); //Create Header and Data String[] Header ={"Item","Description", "Qty","Unit Price","Price"}; String[][] data = { new String[]{ "Spire.Doc for .NET",".NET Word Component","1","$799.00","$799.00"}, new String[]{"Spire.XLS for .NET",".NET Excel Component","2","$799.00","$1,598.00"}, new String[]{"Spire.Office for .NET",".NET Office Component","1","$1,899.00","$1,899.00"}, new String[]{"Spire.PDF for .NET",".NET PDFComponent","2","$599.00","$1,198.00"}, }; //Add Cells table.ResetCells(data.Length + 1, Header.Length); //Header Row TableRow FRow= table.Rows[0]; FRow.IsHeader = true; //Row Height FRow.Height = 23; //Header Format FRow.RowFormat.BackColor = Color.AliceBlue; for (int i = 0; i < Header.Length; i++) { //Cell Alignment Paragraph p = FRow.Cells[i].AddParagraph(); FRow.Cells[i].CellFormat.VerticalAlignment = VerticalAlignment.Middle; p.Format.HorizontalAlignment = HorizontalAlignment.Center; //Data Format TextRange TR = p.AppendText(Header[i]); TR.CharacterFormat.FontName = "Calibri"; TR.CharacterFormat.FontSize = 14; TR.CharacterFormat.TextColor = Color.Teal; TR.CharacterFormat.Bold = true; } //Data Row for (int r = 0; r < data.Length; r++) { TableRow DataRow = table.Rows[r + 1]; //Row Height DataRow.Height = 20; //C Represents Column. for (int c = 0; c < data[r].Length; c++) { //Cell Alignment DataRow.Cells[c].CellFormat.VerticalAlignment = VerticalAlignment.Middle; //Fill Data in Rows Paragraph p2 =DataRow.Cells[c].AddParagraph(); TextRange TR2=p2.AppendText(data[r][c]); //Format Cells p2.Format.HorizontalAlignment = HorizontalAlignment.Center; TR2.CharacterFormat.FontName = "Calibri"; TR2.CharacterFormat.FontSize = 12; TR2.CharacterFormat.TextColor = Color.Brown; } } //Save and Launch doc.SaveToFile("WordTable.docx",FileFormat.docx2013); System.Diagnostics.Process.Start("WordTable.docx"); } } }
Imports System Imports System.Data Imports System.Drawing Imports Spire.Doc Imports Spire.Doc.Documents Imports Spire.Doc.Fields Namespace WordTable Friend Class Program Shared Sub Main(ByVal args() As String) 'Create Table Dim doc As New Document() Dim s As Section = doc.AddSection() Dim table As Table = s.AddTable(True) 'Create Header and Data Dim Header() As String = {"Item", "Description", "Qty", "Unit Price", "Price"} Dim data()() As String = {New String() {"Spire.Doc for .NET", ".NET Word Component", "1", "$799.00", "$799.00"}, New String() {"Spire.XLS for .NET", ".NET Excel Component", "2", "$799.00", "$1,598.00"}, New String() {"Spire.Office for .NET", ".NET Office Component", "1", "$1,899.00", "$1,899.00"}, New String() {"Spire.PDF for .NET", ".NET PDFComponent", "2", "$599.00", "$1,198.00"}} 'Add Cells table.ResetCells(data.Length + 1, Header.Length) 'Header Row Dim FRow As TableRow = table.Rows(0) FRow.IsHeader = True 'Row Height FRow.Height = 23 'Header Format FRow.RowFormat.BackColor = Color.AliceBlue For i As Integer = 0 To Header.Length - 1 'Cell Alignment Dim p As Paragraph = FRow.Cells(i).AddParagraph() FRow.Cells(i).CellFormat.VerticalAlignment = VerticalAlignment.Middle p.Format.HorizontalAlignment = HorizontalAlignment.Center 'Data Format Dim TR As TextRange = p.AppendText(Header(i)) TR.CharacterFormat.FontName = "Calibri" TR.CharacterFormat.FontSize = 14 TR.CharacterFormat.TextColor = Color.Teal TR.CharacterFormat.Bold = True Next i 'Data Row For r As Integer = 0 To data.Length - 1 Dim DataRow As TableRow = table.Rows(r + 1) 'Row Height DataRow.Height = 20 'C Represents Column. For c As Integer = 0 To data(r).Length - 1 'Cell Alignment DataRow.Cells(c).CellFormat.VerticalAlignment = VerticalAlignment.Middle 'Fill Data in Rows Dim p2 As Paragraph = DataRow.Cells(c).AddParagraph() Dim TR2 As TextRange = p2.AppendText(data(r)(c)) 'Format Cells p2.Format.HorizontalAlignment = HorizontalAlignment.Center TR2.CharacterFormat.FontName = "Calibri" TR2.CharacterFormat.FontSize = 12 TR2.CharacterFormat.TextColor = Color.Brown Next c Next r 'Save and Launch doc.SaveToFile("WordTable.docx",FileFormat.docx2013); System.Diagnostics.Process.Start("WordTable.docx") End Sub End Class End Namespace
Spire.Doc, an easy-to-use component to operate Word document, allows developers to fast generate, write, edit and save Word (Word 97-2003, Word 2007, Word 2010) in C# and VB.NET for .NET, Silverlight and WPF.
Create Excel Group in C#, VB.NET
Excel group separate data in Excel worksheet into several groups. Each group may present information of one item. For example, there is a worksheet about sales information about several kinds of products. Users can collect one kind of product in a group to distinguish products type.
Spire.XLS for .NET, an easy-to-use component to manipulate Microsoft Excel workbooks, enables users to create Excel group by using C#, VB.NET. This guide will show the easiest method to realize this function via Spire.XLS for .NET.
Download and install Spire.XLS for .NET. Then invoke sheet.GroupByRows(int firstRow, int lastRow, bool isCollapsed) method to create Excel group by rows. If you want to create group by columns, invoke sheet.GroupByColumns() method directly. After running, you can get the following result:
using Spire.Xls; namespace ExcelGroup { class Group { static void Main(string[] args) { Workbook workbook = new Workbook(); workbook.LoadFromFile(@"E:\Work\Documents\ExcelFiles\PartSalesInfo.xlsx"); Worksheet sheet = workbook.Worksheets[0]; sheet.GroupByRows(2, 9, true); workbook.SaveToFile("Group.xlsx", ExcelVersion.Version2010); System.Diagnostics.Process.Start("Group.xlsx"); } } }
Imports Spire.Xls Namespace ExcelGroup Friend Class Group Shared Sub Main(ByVal args() As String) Dim workbook As New Workbook() workbook.LoadFromFile("E:\Work\Documents\ExcelFiles\PartSalesInfo.xlsx") Dim sheet As Worksheet = workbook.Worksheets(0) sheet.GroupByRows(2, 9, True) workbook.SaveToFile("Group.xlsx", ExcelVersion.Version2010) System.Diagnostics.Process.Start("Group.xlsx") End Sub End Class End Namespace
Set Word Indent in C#, VB.NET
Word Indent, a kind of paragraph format, is used to adjust distance between paragraph body and page margins. It includes left indent, right indent, first line indent and hanging indent. Frist indent and right indent can be applied for all paragraph body, while first line indent just can be used for first line of one paragraph and hanging indent for paragraph body except the first line. This guide introduces a solution to set Word indent in C# and VB.NET via Spire.Doc for .NET. The following screenshot presents result after setting indents.
Spire.Doc for .NET, powerful .NET Word component, provides a ParagraphFormat class to enables users to set format for specified paragraph and indents are format properties of ParagraphFormat class. Firstly, get specified paragraphs to set indents in document. Secondly, set LeftIndent, RightIndent, FirstLineIndent properties for these paragraphs. Please note that type of all indent properties is float. Download and install Spire.Doc for .NET and follow the code blow to set Word indents.
using Spire.Doc; using Spire.Doc.Documents; namespace WordIndent { class Program { static void Main(string[] args) { Document doc = new Document(); doc.LoadFromFile(@"E:\Work\Documents\WordDocuments\Microsoft Word 2013 Preview.docx"); Paragraph para1 = doc.Sections[0].Paragraphs[0]; para1.Format.LeftIndent = 30; Paragraph para2 = doc.Sections[0].Paragraphs[2]; para2.Format.FirstLineIndent = 30; Paragraph para3 = doc.Sections[0].Paragraphs[4]; para3.Format.RightIndent = 80; doc.SaveToFile("Indent.docx", FileFormat.Docx2010); System.Diagnostics.Process.Start("Indent.docx"); } } }
Imports Spire.Doc Imports Spire.Doc.Documents Namespace WordIndent Friend Class Program Shared Sub Main(ByVal args() As String) Dim doc As New Document() doc.LoadFromFile("E:\Work\Documents\WordDocuments\Microsoft Word 2013 Preview.docx") Dim para1 As Paragraph = doc.Sections(0).Paragraphs(0) para1.Format.LeftIndent = 30 Dim para2 As Paragraph = doc.Sections(0).Paragraphs(2) para2.Format.FirstLineIndent = 30 Dim para3 As Paragraph = doc.Sections(0).Paragraphs(4) para3.Format.RightIndent = 80 doc.SaveToFile("Indent.docx", FileFormat.Docx2010) System.Diagnostics.Process.Start("Indent.docx") End Sub End Class End Namespace
Spire.Doc, specializing in manipulating Word document, enables users to generate, write, modify and save Word document (.doc/.docx) quickly and easily in .NET, Silverlight and WPF with C# and VB.NET.
Insert Word Page Break in Document in C#, VB.NET
Word Page Break, a mark to present ending of one page and beginning of new page, can be inserted automatically when users fill one page with contents or manually at a specified location by users. This guide demonstrates an easy solution to insert page break to split one page contents into two pages in C#, VB.NET via Spire.Doc for .NET. The following screenshot shows result after inserting Word page break.
Spire.Doc for .NET provides Paragraph.AppendBreak method with customers to insert break easily in Word. The overload, which should be passed to this method, is BreakType (enum-type). There are three break types offered by Spire.Doc for .NET, PageBreak, ColumnBreak and LineBreak. Download and install Spire.Doc for .NET and follow the code blow to insert Word page break behind the specified paragraph.
using Spire.Doc; using Spire.Doc.Documents; namespace WordBreak { class Program { static void Main(string[] args) { Document document = new Document(); document.LoadFromFile(@"E:\Work\Documents\WordDocuments\.NET Framework.docx"); document.Sections[0].Paragraphs[3].AppendBreak(BreakType.PageBreak); document.SaveToFile("PageBreak.docx", FileFormat.Docx2010); System.Diagnostics.Process.Start("PageBreak.docx"); } } }
Imports Spire.Doc Imports Spire.Doc.Documents Namespace WordBreak Friend Class Program Shared Sub Main(ByVal args() As String) Dim document As New Document() document.LoadFromFile("E:\Work\Documents\WordDocuments\.NET Framework.docx") document.Sections(0).Paragraphs(3).AppendBreak(BreakType.PageBreak) document.SaveToFile("PageBreak.docx", FileFormat.Docx2010) System.Diagnostics.Process.Start("PageBreak.docx") End Sub End Class End Namespace
Spire.Doc, a professional Word component, enables developers/programmers perform a wide range of processing tasks, such as generate, write, modify and save for their customize .NET, Silverlight and WPF applications.
Insert Word Comment in C#, VB.NET
Word comment, inserted by users to show opinions or additional information about words, phrases or paragraphs, is often appeared in the document margins. According to comments, readers can learn some more information about contents or modify contents to express own thoughts more correctly or clearly.
Spire.Doc for .NET, a professional .NET Word component to manipulate Word documents, enables users to insert comment in Word with C#, VB.NET. Users can invoke paragraph.AppendComment(string) method to insert comment for specified paragraph directly. Also, Spire.Doc for .NET provides a Comment class with users. Users can use Format property offered this class to set format comment.
The following demonstrates how perfect a comment can be. You can also freely download Spire.Doc and have a trial.
using Spire.Doc; using Spire.Doc.Documents; using Spire.Doc.Fields; namespace InsertComment { class Program { static void Main(string[] args) { //Load Document Document document = new Document(); document.LoadFromFile(@"E:\work\Documents\WordDocuments\Humor Them.docx"); //Get Paragraph to Insert Comment Section section = document.Sections[0]; Paragraph paragraph = section.Paragraphs[2]; //Insert Comment string str = "This paragraph presents the first example to Humor Them."; Comment comment = paragraph.AppendComment(str); comment.Format.Author = "E-iceblue"; comment.Format.Initial = "CM"; //Save Document document.SaveToFile("comments.docx", FileFormat.Docx2010); System.Diagnostics.Process.Start("comments.docx"); } } }
Imports Spire.Doc Imports Spire.Doc.Documents Imports Spire.Doc.Fields Namespace InsertComment Class Program Private Shared Sub Main(args As String()) 'Load Document Dim document As New Document() document.LoadFromFile("E:\work\Documents\WordDocuments\Humor Them.docx") 'Get Paragraph to Insert Comment Dim section As Section = document.Sections(0) Dim paragraph As Paragraph = section.Paragraphs(2) 'Insert Comment Dim str As String = "This paragraph presents the first example to Humor Them." Dim comment As Comment = paragraph.AppendComment(str) comment.Format.Author = "E-iceblue" comment.Format.Initial = "CM" 'Save Document document.SaveToFile("comments.docx", FileFormat.Docx2010) System.Diagnostics.Process.Start("comments.docx") End Sub End Class End Namespace
Spire.Doc is a Microsoft Word component, which enables users to perform a wide range of Word document processing tasks directly, such as generate, read, write and modify Word document in WPF, .NET and Silverlight.
Decrypt Word Document in C#, VB.NET
Word Decryption is a process to decode encrypted Word document. It requires a password or secret key. If readers want to open and read a protected Word, they need to decrypt this Word document firstly. This guide demonstrates an easy and convenient solution to decrypt Word in C# and VB.NET via Spire.Doc for .NET.
Spire.Doc for .NET, specially developed for programmers to manipulate Word without Word Automation, provides users a method Document.LoadFromFile(String fileName, FileFormat fileFormat, String password) of Document class to open encrypted Word document. It also provides another method Document.RemoveEncryption() to decrypt Word without any protection. Through these two methods, users can decrypt Word easily with Spire.Doc for .NET. Download and install Spire.Doc for .NET. Then follow the code to decrypt.
using Spire.Doc; namespace DecryptWord { class Decryption { static void Main(string[] args) { //Load Encrypted Word Document document = new Document(); document.LoadFromFile(@"E:\Work\Documents\Student Transcript.docx", FileFormat.Docx,"123456"); //Decrypt document.RemoveEncryption(); //Save and Launch document.SaveToFile("decryption.docx", FileFormat.Docx); System.Diagnostics.Process.Start("decryption.docx"); } } }
Imports Spire.Doc Namespace DecryptWord Friend Class Decryption Shared Sub Main(ByVal args() As String) 'Load Encrypted Word Dim document As New Document() document.LoadFromFile("E:\Work\Documents\Student Transcript.docx", FileFormat.Docx, "123456") 'Decrypt document.RemoveEncryption() 'Save and Launch document.SaveToFile("decryption.docx", FileFormat.Docx) System.Diagnostics.Process.Start("decryption.docx") End Sub End Class End Namespace
Spire.Doc, professional Word component, is specially designed for developers to fast generate, write, modify and save Word documents in .NET, Silverlight and WPF with C# and VB.NET. Also, it supports conversion between Word and other popular formats, such as PDF, HTML, Image, Text and so on, in .NET and WPF platform.
How to Convert Word to PDF
This is an all-in-one solution to convert Word to PDF. Within this solution, you can either create a word from scratch or load a word template from folder, and then edit the document as you like; finally you can effortlessly convert word to PDF in C#, VB.NET. The conversion can be doc to PDF or docx to PDF.
Spire.Doc for .NET is a professional .NET library which enables users to directly manage word editing without Microsoft Word being installed, after the editing, you can convert the document to PDF in 2 steps.
Below is the an effective screenshot of the document which will be converted to PDF, at the end Of this post, you can find the target PDF.
Now feel free to download Spire.Doc for .NET and convert word to PDF for personal use or evaluation. The whole process of converting word to PDF in C#, VB.NET can be described as 2 simple steps.
1. Declare a document and load document which you prepare by using ocument.LoadFromFile() method. The parameter passed to this method is file name string.
2. Save Word document as PDF by using document.SaveToFile() method. Parameters passed to this method is file name string and file format. The file format must be PDF.
using System; using Spire.Doc; using Spire.Doc.Documents; namespace DoctoPDF { class toPDF { static void Main(string[] args) { //Load Document Document document = new Document(); document.LoadFromFile(@"E:\work\documents\TestSample.docx"); //Convert Word to PDF document.SaveToFile("toPDF.PDF", FileFormat.PDF); //Launch Document System.Diagnostics.Process.Start("toPDF.PDF"); } } }
Imports System Imports Spire.Doc Imports Spire.Doc.Documents Namespace DoctoPDF Friend Class toPDF Shared Sub Main(ByVal args() As String) 'Load Document Dim document As New Document() document.LoadFromFile("E:\work\documents\TestSample.docx") 'Convert Word to PDF document.SaveToFile("toPDF.PDF", FileFormat.PDF) 'Launch Document System.Diagnostics.Process.Start("toPDF.PDF") End Sub End Class End Namespace
After running the demo, you may find a PDF document launched on your computer:
Spire.Doc is an MS Word component which enables user to perform a wide range of Word document processing tasks directly, such as generate, read, write and modify Word document for .NET and Silverlight.
More about This .NET Word component
Insert Image Header and Footer for Word
Word header and footer presents additional information of Word document, which can be text, image or page number. This guide focuses on introducing how to insert image header and footer for Word document in C# and VB.NET.
Header/Footer plays an important role in Word document, which uses text, image or page number to demonstrate some additional information about this document. The information can be company name, logo, author name, document title etc. This guide will demonstrate detailed process to insert image header/footer in Word with C# and VB.NET via Spire.Doc for .NET. The following screenshot displays Word image header/footer result after programming.
Spire.Doc for .NET provides a HeaderFooter. class to enable developers to generate a new header or footer. Firstly, initialize a header instance of HeaderFooter class and then invoke AddParagraph() method to add a paragraph body for this header/footer instance. Next, invoke Paragraph.AppendPicture(Image image) method to append a picture for header/footer paragraph. If you want to add text for paragraph as well, please invoke Paragraph.AppendText(string text) method. Also, you can set format for header/footer paragraph, appended image and text to have a better layout. Code as following:
using System.Drawing; using Spire.Doc; using Spire.Doc.Documents; using Spire.Doc.Fields; namespace ImageHeaderFooter { class Program { static void Main(string[] args) { //Load Document Document document = new Document(); document.LoadFromFile(@"E:\Work\Documents\Spire.Doc for .NET.docx"); //Initialize a Header Instance HeaderFooter header = document.Sections[0].HeadersFooters.Header; //Add Header Paragraph and Format Paragraph paragraph = header.AddParagraph(); paragraph.Format.HorizontalAlignment = HorizontalAlignment.Right; //Append Picture for Header Paragraph and Format DocPicture headerimage = paragraph.AppendPicture(Image.FromFile(@"E:\Logo\doclog.png")); headerimage.VerticalAlignment = ShapeVerticalAlignment.Bottom; //Initialize a Footer Instance HeaderFooter footer = document.Sections[0].HeadersFooters.Footer; //Add Footer Paragraph and Format Paragraph paragraph2 = footer.AddParagraph(); paragraph2.Format.HorizontalAlignment = HorizontalAlignment.Left; //Append Picture and Text for Footer Paragraph DocPicture footerimage = paragraph2.AppendPicture(Image.FromFile(@"E:\Logo\logo.jpeg")); TextRange TR = paragraph2.AppendText("Copyright © 2013 e-iceblue. All Rights Reserved."); TR.CharacterFormat.FontName = "Arial"; TR.CharacterFormat.FontSize = 10; TR.CharacterFormat.TextColor = Color.Black; //Save and Launch document.SaveToFile("ImageHeaderFooter.docx", FileFormat.Docx); System.Diagnostics.Process.Start("ImageHeaderFooter.docx"); } } }
Imports System.Drawing Imports Spire.Doc Imports Spire.Doc.Documents Imports Spire.Doc.Fields Namespace ImageHeaderFooter Friend Class Program Shared Sub Main(ByVal args() As String) 'Load Document Dim document As New Document() document.LoadFromFile("E:\Work\Documents\Spire.Doc for .NET.docx") 'Initialize a Header Instance Dim header As HeaderFooter = document.Sections(0).HeadersFooters.Header 'Add Header Paragraph and Format Dim paragraph As Paragraph = header.AddParagraph() paragraph.Format.HorizontalAlignment = HorizontalAlignment.Right 'Append Picture for Header Paragraph and Format Dim headerimage As DocPicture = paragraph.AppendPicture(Image.FromFile("E:\Logo\doclog.png")) headerimage.VerticalAlignment = ShapeVerticalAlignment.Bottom 'Initialize a Footer Instance Dim footer As HeaderFooter = document.Sections(0).HeadersFooters.Footer 'Add Footer Paragraph and Format Dim paragraph2 As Paragraph = footer.AddParagraph() paragraph2.Format.HorizontalAlignment = HorizontalAlignment.Left 'Append Picture and Text for Footer Paragraph Dim footerimage As DocPicture = paragraph2.AppendPicture(Image.FromFile("E:\Logo\logo.jpeg")) Dim TR As TextRange = paragraph2.AppendText("Copyright © 2013 e-iceblue. All Rights Reserved.") TR.CharacterFormat.FontName = "Arial" TR.CharacterFormat.FontSize = 10 TR.CharacterFormat.TextColor = Color.Black 'Save and Launch document.SaveToFile("ImageHeaderFooter.docx", FileFormat.Docx) System.Diagnostics.Process.Start("ImageHeaderFooter.docx") End Sub End Class End Namespace
Spire.Doc, an easy-to-use component to perform Word tasks, allows developers to fast generate, write, edit and save Word (Word 97-2003, Word 2007, Word 2010) in C# and VB.NET for .NET, Silverlight and WPF.