.NET (1317)
Children categories
How to set word bullet style by appending the HTML code in C#
2015-01-21 07:02:29 Written by hayes LiuWith the help of Spire.Doc for .NET, developers can easily set bullet style for the existing word documents via invoke p.ListFormat.ApplyBulletStyle() method to format. This article will show you how to convert HTML list into word and set the bullet style for the word list in C#.
Firstly, please view the effective screenshot for the result word document:
Here comes to the steps:
Step 1: Create a new document and add a section to the document.
Document document = new Document(); Section section=document.AddSection();
Step 2: Add word list to the paragraph by appending HTML.
Paragraph paragraph = section.AddParagraph();
paragraph.AppendHTML("<ol><li>Version 1</li><li>Version 2</li><li>Version 3</li></ol>");
Step 3: Set the bullet style for the paragraph.
foreach (Paragraph p in section.Paragraphs)
{
p.ApplyStyle(BuiltinStyle.Heading2);
if (p.ListFormat.CurrentListLevel != null)
{
p.ListFormat.ApplyBulletStyle();
}
}
Step 4: Save the document to file
document.SaveToFile("result.docx",FileFormat.Docx);
Full codes:
// Create a new Word document object
Document document = new Document();
// Add a section to the document
Section section = document.AddSection();
// Add a paragraph to the section
Paragraph paragraph = section.AddParagraph();
// Append HTML content to the paragraph
paragraph.AppendHTML("- Version 1
- Version 2
- Version 3
");
// Loop through all paragraphs in the section
foreach (Paragraph p in section.Paragraphs)
{
// Apply "Heading 2" built-in style to the paragraph
p.ApplyStyle(BuiltinStyle.Heading2);
// Check if the paragraph has listformat
if (p.ListFormat.CurrentListLevel != null)
{
// Apply bullet style
p.ListFormat.ApplyBulletStyle();
}
}
// Save the document to a file in DOCX format
document.SaveToFile("result.docx", FileFormat.Docx);
// Dispose
document.Dispose();
In some cases, you have several items that you want them displayed on multiple lines within a PDF grid cell. However if you don't enter a line break at a specific point in a cell, these items will appear as a whole sentence. In the article, you can learn how to insert line breaks in PDF grid cell via Spire.PDF in C#, VB.NET.
Here come the detailed steps:
Step 1: Initialize a new instance of PdfDocument and add a new page to PDF document.
PdfDocument doc = new PdfDocument(); PdfPageBase page = doc.Pages.Add();
Step 2: Create a PDF gird with one row and three columns.
PdfGrid grid = new PdfGrid(); grid.Style.CellPadding = new PdfPaddings(1, 1, 1, 1); PdfGridRow row = grid.Rows.Add(); grid.Columns.Add(3); grid.Columns[0].Width = 80; grid.Columns[1].Width = 80; grid.Columns[2].Width = 80;
Step 3: Initialize a new instance of PdfGridCellTextAndStyleList class and PdfGridCellTextAndStyle class. Set parameters of the variable textAndStyle such as text, font and brush. Add textAndStlye into PdfGridCellTextAndStyleList.
PdfGridCellTextAndStyleList lst = new PdfGridCellTextAndStyleList();
PdfGridCellTextAndStyle textAndStyle = new PdfGridCellTextAndStyle();
textAndStyle.Text = "Line 1";
textAndStyle.Font = new PdfTrueTypeFont(new System.Drawing.Font("Airal", 8f, FontStyle.Regular), true);
textAndStyle.Brush = PdfBrushes.Black;
lst.List.Add(textAndStyle);
Step 4: Repeat step 3 to add three other lines. Here you should insert '\n' to where you want this line break appears.
textAndStyle = new PdfGridCellTextAndStyle();
textAndStyle.Text = "\nLine 2";
textAndStyle.Font = new PdfTrueTypeFont(new System.Drawing.Font("Arial", 8f, FontStyle.Regular), true);
textAndStyle.Brush = PdfBrushes.Black;
lst.List.Add(textAndStyle);
textAndStyle = new PdfGridCellTextAndStyle();
textAndStyle.Text = "\nLine 3";
textAndStyle.Font = new PdfTrueTypeFont(new System.Drawing.Font("Arial", 8f, FontStyle.Regular), true);
textAndStyle.Brush = PdfBrushes.Black;
lst.List.Add(textAndStyle);
textAndStyle = new PdfGridCellTextAndStyle();
textAndStyle.Text = "\nLine 4";
textAndStyle.Font = new PdfTrueTypeFont(new System.Drawing.Font("Arial",8f, FontStyle.Regular), true);
textAndStyle.Brush = PdfBrushes.Black;
lst.List.Add(textAndStyle);
row.Cells[0].Value = lst;
Step 5: Draw the gird on PDF page and save the file.
grid.Draw(page, new PointF(10, 20)); String outputFile = "..\\..\\Sample.pdf"; doc.SaveToFile(outputFile, FileFormat.PDF); System.Diagnostics.Process.Start(outputFile);
Result:
Full Code:
using Spire.Pdf;
using Spire.Pdf.Graphics;
using Spire.Pdf.Grid;
using System;
using System.Drawing;
namespace LineBreak
{
class Program
{
static void Main(string[] args)
{
PdfDocument doc = new PdfDocument();
PdfPageBase page = doc.Pages.Add();
PdfGrid grid = new PdfGrid();
grid.Style.CellPadding = new PdfPaddings(1, 1, 1, 1);
PdfGridRow row = grid.Rows.Add();
grid.Columns.Add(3);
grid.Columns[0].Width = 80;
grid.Columns[1].Width = 80;
grid.Columns[2].Width = 80;
PdfGridCellContentList lst = new PdfGridCellContentList();
PdfGridCellContent textAndStyle = new PdfGridCellContent();
textAndStyle.Text = "Line 1";
textAndStyle.Font = new PdfTrueTypeFont(new System.Drawing.Font("Airal", 8f, FontStyle.Regular), true);
textAndStyle.Brush = PdfBrushes.Black;
lst.List.Add(textAndStyle);
textAndStyle = new PdfGridCellContent();
textAndStyle.Text = "\nLine 2";
textAndStyle.Font = new PdfTrueTypeFont(new System.Drawing.Font("Arial", 8f, FontStyle.Regular), true);
textAndStyle.Brush = PdfBrushes.Black;
lst.List.Add(textAndStyle);
textAndStyle = new PdfGridCellContent();
textAndStyle.Text = "\nLine 3";
textAndStyle.Font = new PdfTrueTypeFont(new System.Drawing.Font("Arial", 8f, FontStyle.Regular), true);
textAndStyle.Brush = PdfBrushes.Black;
lst.List.Add(textAndStyle);
textAndStyle = new PdfGridCellContent();
textAndStyle.Text = "\nLine 4";
textAndStyle.Font = new PdfTrueTypeFont(new System.Drawing.Font("Arial", 8f, FontStyle.Regular), true);
textAndStyle.Brush = PdfBrushes.Black;
lst.List.Add(textAndStyle);
row.Cells[0].Value = lst;
grid.Draw(page, new PointF(10, 20));
String outputFile = "..\\..\\Sample.pdf";
doc.SaveToFile(outputFile, FileFormat.PDF);
System.Diagnostics.Process.Start(outputFile);
}
}
}
Imports Spire.Pdf
Imports Spire.Pdf.Graphics
Imports Spire.Pdf.Grid
Imports System.Drawing
Namespace LineBreak
Class Program
Private Shared Sub Main(args As String())
Dim doc As New PdfDocument()
Dim page As PdfPageBase = doc.Pages.Add()
Dim grid As New PdfGrid()
grid.Style.CellPadding = New PdfPaddings(1, 1, 1, 1)
Dim row As PdfGridRow = grid.Rows.Add()
grid.Columns.Add(3)
grid.Columns(0).Width = 80
grid.Columns(1).Width = 80
grid.Columns(2).Width = 80
Dim lst As New PdfGridCellContentList()
Dim textAndStyle As New PdfGridCellContent()
textAndStyle.Text = "Line 1"
textAndStyle.Font = New PdfTrueTypeFont(New System.Drawing.Font("Airal", 8F, FontStyle.Regular), True)
textAndStyle.Brush = PdfBrushes.Black
lst.List.Add(textAndStyle)
textAndStyle = New PdfGridCellContent()
textAndStyle.Text = vbLf & "Line 2"
textAndStyle.Font = New PdfTrueTypeFont(New System.Drawing.Font("Arial", 8F, FontStyle.Regular), True)
textAndStyle.Brush = PdfBrushes.Black
lst.List.Add(textAndStyle)
textAndStyle = New PdfGridCellContent()
textAndStyle.Text = vbLf & "Line 3"
textAndStyle.Font = New PdfTrueTypeFont(New System.Drawing.Font("Arial", 8F, FontStyle.Regular), True)
textAndStyle.Brush = PdfBrushes.Black
lst.List.Add(textAndStyle)
textAndStyle = New PdfGridCellContent()
textAndStyle.Text = vbLf & "Line 4"
textAndStyle.Font = New PdfTrueTypeFont(New System.Drawing.Font("Arial", 8F, FontStyle.Regular), True)
textAndStyle.Brush = PdfBrushes.Black
lst.List.Add(textAndStyle)
row.Cells(0).Value = lst
grid.Draw(page, New PointF(10, 20))
Dim outputFile As [String] = "..\..\Sample.pdf"
doc.SaveToFile(outputFile, FileFormat.PDF)
System.Diagnostics.Process.Start(outputFile)
End Sub
End Class
End Namespace
How to create vertical table at one side of the word document
2015-01-13 08:46:41 Written by AdministratorSpire.Doc can help developers to create word table with data and format cells easily and it also supports to add text watermark into the word documents. This article will show you how to create a vertical table at one side of the word document, which looks like the vertical watermark in the word document.
Firstly, please check the effective screenshot of the vertical table at the right of the word document added by Spire.Doc:
Here comes to the steps of how to create vertical table in C#.
Step 1: Create a new document and add a section to the document.
Document document = new Document(); Section section=document.AddSection();
Step 2: Add a table with rows and columns and set the text for the table.
Table table = section.AddTable();
table.ResetCells(1, 1);
TableCell cell = table.Rows[0].Cells[0];
table.Rows[0].Height = 150;
cell.AddParagraph().AppendText("Draft copy in vertical style");
Step 3: Set the TextDirection for the table to RightToLeftRotated.
cell.CellFormat.TextDirection = TextDirection.RightToLeftRotated;
Step 4: Set the table format.
table.TableFormat.WrapTextAround = true; table.TableFormat.Positioning.VertRelationTo = VerticalRelation.Page; table.TableFormat.Positioning.HorizRelationTo = HorizontalRelation.Page; table.TableFormat.Positioning.HorizPosition = section.PageSetup.PageSize.Width- table.Width; table.TableFormat.Positioning.VertPosition = 200;
Step 5: Save the document to file.
document.SaveToFile("result.docx",FileFormat.docx2013);
Full codes in C#:
using Spire.Doc;
using Spire.Doc.Documents;
namespace CreateVerticalTable
{
class Program
{
static void Main(string[] args)
{
Document document = new Document();
Section section=document.AddSection();
Table table = section.AddTable();
table.ResetCells(1, 1);
TableCell cell = table.Rows[0].Cells[0];
table.Rows[0].Height = 150;
cell.AddParagraph().AppendText("Draft copy in vertical style");
cell.CellFormat.TextDirection = TextDirection.RightToLeftRotated;
table.Format.WrapTextAround = true;
table.Format.Positioning.VertRelationTo = VerticalRelation.Page;
table.Format.Positioning.HorizRelationTo = HorizontalRelation.Page;
table.Format.Positioning.HorizPosition = section.PageSetup.PageSize.Width - table.Width;
table.Format.Positioning.VertPosition = 200;
document.SaveToFile(""result.docx"", FileFormat.Docx2013);
}
}
}
MS Excel contains a set of Windows Forms controls that can be used to Worksheet to host item. Spire.XLS also provides programmers similar features to add controls on Worksheet at runtime without installing any other control program. In this article, I'll introduce you how to insert TextBox, CheckBox and RadioButton into Worksheet via Spire.XLS in C#, VB.NET.
Detailed Steps:
Step 1: Download Spire.XLS and reference dll file to your VS project.
Step 2: Use Spire.Xls.Core as namespace, which contains all the interfaces like ITextBoxShap, ICheckBox, IRadioButton and etc.
Step 3: Initialize a new instance of Workbook and create a Worksheet in it.
Workbook wb = new Workbook(); Worksheet ws = wb.Worksheets[0];
Step 4: Insert a TextBox at specified location and input the display text.
ITextBoxShape textbox = ws.TextBoxes.AddTextBox(2, 2, 15, 100); textbox.Text = "Hello World";
Step 5: Insert three CheckBox into Worksheet at different locations. Set the CheckState and display text.
ICheckBox cb = ws.CheckBoxes.AddCheckBox(4, 2, 15, 100); cb.CheckState = CheckState.Checked; cb.Text = "Check Box 1"; cb = ws.CheckBoxes.AddCheckBox(4, 4, 15, 100); cb.CheckState = CheckState.Checked; cb.Text = "Check Box 2"; cb = ws.CheckBoxes.AddCheckBox(4, 6, 15, 100); cb.CheckState = CheckState.Checked; cb.Text = "Check Box 3";
Step 6: Insert three RadioButton and set the related properties.
IRadioButton rb = ws.RadioButtons.Add(6, 2, 15, 100); rb.Text = "Option 1"; rb = ws.RadioButtons.Add(8, 2, 15, 100); rb.CheckState = CheckState.Checked; rb.Text = "Option 2"; rb = ws.RadioButtons.Add(10, 2, 15, 100); rb.Text = "Option 3";
Step 7: Save the file.
ws.DefaultRowHeight = 15;
wb.SaveToFile("Result.xlsx", ExcelVersion.Version2010);
Output:
Full Code:
using Spire.Xls;
using Spire.Xls.Core;
namespace InsertControl
{
class Program
{
static void Main(string[] args)
{
Workbook wb = new Workbook();
Worksheet ws = wb.Worksheets[0];
ITextBoxShape textbox = ws.TextBoxes.AddTextBox(2, 2, 15, 100);
textbox.Text = "Hello World";
ICheckBox cb = ws.CheckBoxes.AddCheckBox(4, 2, 15, 100);
cb.CheckState = CheckState.Checked;
cb.Text = "Check Box 1";
cb = ws.CheckBoxes.AddCheckBox(4, 4, 15, 100);
cb.CheckState = CheckState.Checked;
cb.Text = "Check Box 2";
cb = ws.CheckBoxes.AddCheckBox(4, 6, 15, 100);
cb.CheckState = CheckState.Checked;
cb.Text = "Check Box 3";
IRadioButton rb = ws.RadioButtons.Add(6, 2, 15, 100);
rb.Text = "Option 1";
rb = ws.RadioButtons.Add(8, 2, 15, 100);
rb.CheckState = CheckState.Checked;
rb.Text = "Option 2";
rb = ws.RadioButtons.Add(10, 2, 15, 100);
rb.Text = "Option 3";
ws.DefaultRowHeight = 15;
wb.SaveToFile("Result.xlsx", ExcelVersion.Version2010);
}
}
}
Imports Spire.Xls
Imports Spire.Xls.Core
Namespace InsertControl
Class Program
Private Shared Sub Main(args As String())
Dim wb As New Workbook()
Dim ws As Worksheet = wb.Worksheets(0)
Dim textbox As ITextBoxShape = ws.TextBoxes.AddTextBox(2, 2, 15, 100)
textbox.Text = "Hello World"
Dim cb As ICheckBox = ws.CheckBoxes.AddCheckBox(4, 2, 15, 100)
cb.CheckState = CheckState.Checked
cb.Text = "Check Box 1"
cb = ws.CheckBoxes.AddCheckBox(4, 4, 15, 100)
cb.CheckState = CheckState.Checked
cb.Text = "Check Box 2"
cb = ws.CheckBoxes.AddCheckBox(4, 6, 15, 100)
cb.CheckState = CheckState.Checked
cb.Text = "Check Box 3"
Dim rb As IRadioButton = ws.RadioButtons.Add(6, 2, 15, 100)
rb.Text = "Option 1"
rb = ws.RadioButtons.Add(8, 2, 15, 100)
rb.CheckState = CheckState.Checked
rb.Text = "Option 2"
rb = ws.RadioButtons.Add(10, 2, 15, 100)
rb.Text = "Option 3"
ws.DefaultRowHeight = 15
wb.SaveToFile("Result.xlsx", ExcelVersion.Version2010)
End Sub
End Class
End Namespace
Sparkline is a tiny chart that can be inserted in cells to represent the trends in a series of values. Spire.XLS enables programmers to select a data cell range and display sparkline in another cell, usually next to data range. This article gives an example in C# and VB.NET to show how this purpose is achieved with a few lines of code.
Code Snippet:
Step 1: Create a new Workbook and load the sample file.
Workbook wb = new Workbook();
wb.LoadFromFile("sample.xlsx");
Step 2: Get the Worksheet from Workbook.
Worksheet ws = wb.Worksheets[0];
Step 3: Set SparklineType as line and apply line sparkline to SparklineCollection.
SparklineGroup sparklineGroup = ws.SparklineGroups.AddGroup(SparklineType.Line); SparklineCollection sparklines = sparklineGroup.Add();
Step 4: Call SparklineCollection.Add(DateRange, ReferenceRange) mothed get data from a range of cells and display sparkline chart inside another cell, e.g., a sparkline in E2 shows the trend of values from A2 to D2.
sparklines.Add(ws["A2:D2"], ws["E2"]); sparklines.Add(ws["A3:D3"], ws["E3"]); sparklines.Add(ws["A4:D4"], ws["E4"]); sparklines.Add(ws["A5:D5"], ws["E5"]);
Step 5: Save the file.
wb.SaveToFile("output.xlsx",ExcelVersion.Version2010);
Output:
Full Code:
using Spire.Xls;
namespace InsertSparkline
{
class Program
{
static void Main(string[] args)
{
Workbook wb = new Workbook();
wb.LoadFromFile("sample.xlsx");
Worksheet ws = wb.Worksheets[0];
SparklineGroup sparklineGroup = ws.SparklineGroups.AddGroup(SparklineType.Line);
SparklineCollection sparklines = sparklineGroup.Add();
sparklines.Add(ws["A2:D2"], ws["E2"]);
sparklines.Add(ws["A3:D3"], ws["E3"]);
sparklines.Add(ws["A4:D4"], ws["E4"]);
sparklines.Add(ws["A5:D5"], ws["E5"]);
wb.SaveToFile("output.xlsx", ExcelVersion.Version2010);
}
}
}
Imports Spire.Xls
Namespace InsertSparkline
Class Program
Private Shared Sub Main(args As String())
Dim wb As New Workbook()
wb.LoadFromFile("sample.xlsx")
Dim ws As Worksheet = wb.Worksheets(0)
Dim sparklineGroup As SparklineGroup = ws.SparklineGroups.AddGroup(SparklineType.Line)
Dim sparklines As SparklineCollection = sparklineGroup.Add()
sparklines.Add(ws("A2:D2"), ws("E2"))
sparklines.Add(ws("A3:D3"), ws("E3"))
sparklines.Add(ws("A4:D4"), ws("E4"))
sparklines.Add(ws("A5:D5"), ws("E5"))
wb.SaveToFile("output.xlsx", ExcelVersion.Version2010)
End Sub
End Class
End Namespace
In PDF documents, the functionality to expand or collapse bookmarks helps provide a more organized and easier to navigate layout. When bookmarks are expanded, the entire hierarchy of bookmarks is visible at once, giving a comprehensive view of the document's structure and aiding in comprehension of its flow. Conversely, the option to collapse bookmarks is beneficial for users who prefer a less detailed view, as it allows them to focus on a specific part of the document without being distracted by the entire hierarchy. This article will introduce how to expand or collapse bookmarks in PDF in C# using Spire.PDF for .NET.
Install Spire.PDF for .NET
To begin with, you need to add the DLL files included in the Spire.PDF for.NET package as references in your .NET project. The DLL files can be either downloaded from this link or installed via NuGet.
PM> Install-Package Spire.PDF
Expand or Collapse a Specific Bookmark in PDF in C#
Spire.PDF for .NET provides the PdfBookmark.ExpandBookmark property to expand or collapse a specified bookmark in PDF. The following are the detailed steps.
- Create a PdfDocument object.
- Load a PDF file using PdfDocument.LoadFromFile() method.
- Get a specified bookmark in the PDF file using PdfDocument.Bookmarks[] property.
- Expand the bookmark by setting the PdfBookmark.ExpandBookmark property to true. Or set it to false to collapses the bookmark.
- Save the result PDF file using PdfDocument.SaveToFile() method.
- C#
using Spire.Pdf;
using Spire.Pdf.Bookmarks;
namespace ExpandOrCollapseABookmark
{
class Program
{
static void Main(string[] args)
{
//Create a PdfDocument object
PdfDocument pdf = new PdfDocument();
//Load a PDF file
pdf.LoadFromFile("AnnualReport.pdf");
//Get a specified bookmark
PdfBookmark bookmarks = pdf.Bookmarks[3];
//Expand the bookmark
bookmarks.ExpandBookmark = true;
//collapse the bookmark
//bookmarks.ExpandBookmark = false;
//Save the result file
pdf.SaveToFile("ExpandSpecifiedBookmark.pdf");
}
}
}
Expand or Collapse All Bookmarks in PDF in C#
You can also iterate through all the bookmarks in a PDF file, and then expand or collapse each bookmark through the PdfBookmark.ExpandBookmark property. The following are the detailed steps.
- Create a PdfDocument object.
- Load a PDF file using PdfDocument.LoadFromFile() method.
- Iterate through all bookmarks in the PDF file.
- Expand each bookmark by setting the PdfBookmark.ExpandBookmark property to true. Or set it to false to collapses each bookmark.
- Save the result PDF file using PdfDocument.SaveToFile() method.
- C#
using Spire.Pdf;
using Spire.Pdf.Bookmarks;
namespace ExpandOrCollapsePDFBookmarks
{
class Program
{
static void Main(string[] args)
{
//Create a PdfDocument object
PdfDocument pdf = new PdfDocument();
//Load a PDF file
pdf.LoadFromFile("AnnualReport.pdf");
//Loop through all bookmarks and expand them
foreach (PdfBookmark bookmark in pdf.Bookmarks)
{
bookmark.ExpandBookmark = true;
}
//Save the result file
pdf.SaveToFile("ExpandAllBookmarks.pdf");
}
}
}
Apply for a Temporary License
If you'd like to remove the evaluation message from the generated documents, or to get rid of the function limitations, please request a 30-day trial license for yourself.
PDF document thumbnails, appearing in the left-hand corner of a PDF reader, provide miniature previews of document pages. The 'Thumbnail View' pane allows you to view page thumbnails of all the pages included in the PDF document and you can simply click on the thumbnail to quickly travel to that page.
This article presents how to create a PDF document thumbnail view in your own .NET PDF viewer via Spire.PDFViewer. Detailed steps are as below:
Step 1: Create a new project in Windows Forms Application.
Step 2: Add Spire.PDFViewer control to VS Toolbox.
Step 3: Design Form1.
- Add a ToolStrip to Form1. Insert two Buttons, one TextBox and one Label to ToolStrip.
- Drag PdfDocumentThumbnail and PdfDocumentViewer control from Toolbox to Form1.
- Set properties of the Buttons, Labels, TextBox, PdfDocumentThumbnail and PdfDocumentViewer as below.
Tools |
Properties |
As |
| ToolStripButton1 | Name | btnOpen |
| DisplayStyle | Image | |
| ToolStripButton2 | Name | btnThumbnailRatio |
| DisplayStyle | Image | |
| ToolStripLabel1 | Name | toolStripLabel1 |
| DisplayStyle | Text | |
| Text | Ratio | |
| ToolStripTextBox | Name | txtThumbnailRatio |
| PdfDocumentThumbnail | Name | pdfDocumentThumbnail1 |
| Dock | Fill | |
| PdfDocumentViewer | Name | pdfDocumentViewer1 |
| Dock | Full |
Step 4: Set code for btnOpen and btnThumbnailRatio.
1) Create a OpenFileDailog in btnOpen click event which enables you to open a file with correct type.
private void btnOpen_Click(object sender, EventArgs e)
{
OpenFileDialog dialog = new OpenFileDialog();
dialog.Filter = "PDF document(*.pdf)|*.pdf";
DialogResult result = dialog.ShowDialog();
if (result == DialogResult.OK)
{
string pdfDocument = dialog.FileName;
this.pdfDocumentViewer1.LoadFromFile(pdfDocument);
}
}
2) Set zoom ratio for thumbnail view mode.
private void btnThumbnailRatio_Click(object sender, EventArgs e)
{
if (this.pdfDocumentViewer1.IsDocumentLoaded)
{
int percent = 0;
bool isNumeric = int.TryParse(this.txtThumbnailRatio.Text, out percent);
if (isNumeric)
{
this.pdfDocumentThumbnail1.ZoomPercent =Math.Abs(percent);
}
}
}
Run this program and open an existing PDF document, you'll get following output:
Spire.XLS can help developers to write rich text into the spreadsheet easily, such as set the text in bold, italic, and set the colour and font for them. We have already shown you how to set Subscript and Superscript in Excel files by using Spire.XLS. This article will focus on demonstrate how to formatting text in Excel sheet in C#.
Spire.Xls offers ExcelFont class and developers can format the text of cells easily. By using RichText, we can add the text into cells and set font for it. Here comes to the steps of how to write rich text into excel cells.
Step 1: Create an excel document and get its first worksheet.
Workbook workbook = new Workbook(); Worksheet sheet = workbook.Worksheets[0];
Step 2: Create the fonts and sent the format for each font.
//create a font and set the format to bold. ExcelFont fontBold = workbook.CreateFont(); fontBold.IsBold = true; //create a font and set the format to underline. ExcelFont fontUnderline = workbook.CreateFont(); fontUnderline.Underline = FontUnderlineType.Single; //create a font and set the format to italic. ExcelFont fontItalic = workbook.CreateFont(); fontItalic.IsItalic = true; //create a font and set the color to green. ExcelFont fontColor = workbook.CreateFont(); fontColor.KnownColor = ExcelColors.Green;
Step 3: Set the font for specified cell range.
RichText richText = sheet.Range["A1"].RichText; richText.Text="It is in Bold"; richText.SetFont(0, richText.Text.Length-1, fontBold); richText = sheet.Range["A2"].RichText; richText.Text = "It is underlined"; richText.SetFont(0, richText.Text.Length-1, fontUnderline); richText = sheet.Range["A3"].RichText; richText.Text = "It is Italic"; richText.SetFont(0, richText.Text.Length - 1, fontItalic); richText = sheet.Range["A4"].RichText; richText.Text = "It is Green"; richText.SetFont(0, richText.Text.Length - 1, fontColor);
Step 4: Save the document to file.
workbook.SaveToFile("Sample.xls",ExcelVersion.Version97to2003);
Effective screenshot of writing rich text into excel worksheet:
Full codes:
using Spire.Xls;
namespace WriteRichtextinExcel
{
class Program
{
static void Main(string[] args)
{
Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
ExcelFont fontBold = workbook.CreateFont();
fontBold.IsBold = true;
ExcelFont fontUnderline = workbook.CreateFont();
fontUnderline.Underline = FontUnderlineType.Single;
ExcelFont fontItalic = workbook.CreateFont();
fontItalic.IsItalic = true;
ExcelFont fontColor = workbook.CreateFont();
fontColor.KnownColor = ExcelColors.Green;
RichText richText = sheet.Range["A1"].RichText;
richText.Text = "It is in Bold";
richText.SetFont(0, richText.Text.Length - 1, fontBold);
richText = sheet.Range["A2"].RichText;
richText.Text = "It is underlined";
richText.SetFont(0, richText.Text.Length - 1, fontUnderline);
richText = sheet.Range["A3"].RichText;
richText.Text = "It is Italic";
richText.SetFont(0, richText.Text.Length - 1, fontItalic);
richText = sheet.Range["A4"].RichText;
richText.Text = "It is Green";
richText.SetFont(0, richText.Text.Length - 1, fontColor);
workbook.SaveToFile("Sample.xls", ExcelVersion.Version97to2003);
}
}
}
Zoom is a basic as well useful function in any text file reader. Users can chose to zoom out or zoom in of a document depending on how small the font is, or on their own view preference. In this article, I’ll introduce two ways to zoom Word file using Spire.DocViewer:
- Zoom with a particular zoom mode
- Zoom by entering a percentage
Now, I will explain more by creating a Windows Forms Application. Some steps about how to add DocVierwer control to toolbox and how to open Word file using Spire.DocViewer have been demonstrated previously. In the following section, I only add a MenuItem and a TextBox to Form1.
In the MenuItem, named Zoom, I create three sub-items which are used to save three particular zoom modes.
- Default: View page in its original size.
- Fit to page: When this option is selected, the document will be resized to match the dimensions of your view window.
- Fit to width: When this option is selected, the document will best fit to width of window.
Code behind:
private void defaultToolStripMenuItem_Click(object sender, EventArgs e)
{
this.docDocumentViewer1.ZoomMode = ZoomMode.Default;
}
private void fitToPageToolStripMenuItem_Click(object sender, EventArgs e)
{
this.docDocumentViewer1.ZoomMode = ZoomMode.FitPage;
}
private void fitToWidthToolStripMenuItem_Click(object sender, EventArgs e)
{
this.docDocumentViewer1.ZoomMode = ZoomMode.FitWidth;
}
Another way to zoom in or out of Word document is enter a desired percentage in TextBox.
Code for TextBox:
private void toolStripTextBox1_KeyDown(object sender, KeyEventArgs e)
{
if (Keys.Enter == e.KeyCode)
{
int p;
if (int.TryParse(this.toolStripTextBox1.Text, out p))
{
this.docDocumentViewer1.ZoomTo(p);
}
}
}
Run the program, you can get following windows application.
Fit to Width:
Zoom with 50 percentages:
Adding text into the PDF files is one of the most important requirements for developers. With the help of Spire.PDF, developer can draw transform text, alignment text and rotate text in PDF files easily. This tutorial will show you how to add underline text in C#.
By using the method canvas.drawstring offered by Spire.PDF, developers can set the position, font, brush and style for the adding texts. With the PdfFontStyle, developers can set the style to underline, bold, italic, regular and strikeout. Here comes to the code snippet of how to add underline text in PDF.
Step 1: Create a new PDF document.
PdfDocument pdf = new PdfDocument();
Step 2: Add a new page to the PDF file.
PdfPageBase page = pdf.Pages.Add();
Step 3: Create a true type font with size 20f, underline style.
PdfTrueTypeFont font = new PdfTrueTypeFont(@"C:\WINDOWS\Fonts\CONSOLA.TTF", 20f, PdfFontStyle.Underline);
Step 4: Create a blue brush.
PdfSolidBrush brush = new PdfSolidBrush(Color.Blue);
Step 5: Draw the text string at the specified location with the specified Brush and Font objects.
page.Canvas.DrawString("Hello E-iceblue Support Team", font, brush, new PointF(10, 10));
Step 6: Save the PDF file.
pdf.SaveToFile("Result.pdf", FileFormat.PDF);
Effective screenshot:
Full codes:
using Spire.Pdf;
using Spire.Pdf.Graphics;
using System.Drawing;
namespace AddUnderlinetext
{
class Program
{
static void Main(string[] args)
{
PdfDocument pdf = new PdfDocument();
PdfPageBase page = pdf.Pages.Add();
PdfTrueTypeFont font = new PdfTrueTypeFont(@"C:\WINDOWS\Fonts\CONSOLA.TTF", 20f, PdfFontStyle.Underline);
PdfSolidBrush brush = new PdfSolidBrush(Color.Blue);
page.Canvas.DrawString("Hello E-iceblue Support Team", font, brush, new PointF(10, 10));
pdf.SaveToFile("Result.pdf", FileFormat.PDF);
}
}
}
