Different printer drivers print out the document with different numbers of rows and columns. When we need to print an excel file with header and footer, the information of how many pages in one excel file and where is the first line start becomes very important. This article will show you how to get the page count of excel file and the row and column number of page break in C# by using Spire.XLS for .NET.

Firstly, make sure that Spire.XLS for .NET (version7.3.12 or above) has been installed on your machine. And then, adds Spire.XLS.dll as reference in the downloaded Bin folder thought the below path: "..\Spire.XLS\Bin\NET4.0\ Spire.XLS.dll".

Now it comes to the details of how to get the page count of excel file in C#:

//Create a new excel document
Workbook wb = new Workbook();
//load from the file
wb.LoadFromFile(@"D:\test.xlsx");
//get the page info.
var pageInfoList = wb.GetSplitPageInfo();
//Get the sheet count
int sheetCount = pageInfoList.Count;
//The page count of the first sheet
int pageCount = pageInfoList[0].Count;

You could find a screenshot shows row number and column number of each Excel page.

Spire.XLS for .NET, as a professional Excel component, it enables you to generate, read, write and manipulate Excel files in C#, VB.NET in any .NET applications directly.

PPT file format is commonly used for office and educational slide shows. With Spire.Presentation, you can generate beautiful and powerful PPT files and edit them without utilizing Microsoft PowerPoint. The PPT files generated are compatible with PowerPoint.

In this document, I will introduce you how to set Font of text in PPT file. First add IAutoShape to the slide. The IAutoShape is a TextBox. You have to add it first. Then add text to the IAutoShape using the method AppendTextFrame. Then you can get the property TextRange of the shape. Using TextRange, you can set Font of text finally.

Step 1: Add the shape to the slide.

IAutoShape shape = presentation.Slides[0].Shapes.AppendShape(ShapeType.Rectangle,
                new RectangleF(50, 70, 400, 50));

Step 2: Add the text to the shape.

shape.AppendTextFrame("This is a demo of text font and color.");

Step 3: Get the property TextRange of the text.

TextRange textRange = shape.TextFrame.TextRange;

Step 4: Set the Font of the text in shape.

textRange.FontHeight = 21;
textRange.IsItalic = TriState.True;
textRange.TextUnderlineType = TextUnderlineType.Single;
textRange.LatinFont = new TextFont("Gulim");

Step 5: Save the document.

presentation.SaveToFile("text.pptx", FileFormat.Pptx2007);

Full code:

using Spire.Presentation;
using System.Drawing;
namespace SetFont
{
    class Program
    {
        static void Main(string[] args)
        {
            //create PPT document
            Presentation presentation = new Presentation();

            //set background Image
            string ImageFile = @"..\..\..\..\..\..\Data\bg.png";
            RectangleF rect = new RectangleF(0, 0, presentation.SlideSize.Size.Width, presentation.SlideSize.Size.Height);
            presentation.Slides[0].Shapes.AppendEmbedImage(ShapeType.Rectangle, ImageFile, rect);
            presentation.Slides[0].Shapes[0].Line.FillFormat.SolidFillColor.Color = Color.FloralWhite;

            //append new shape
            IAutoShape shape = presentation.Slides[0].Shapes.AppendShape(ShapeType.Rectangle,
                new RectangleF(50, 70, 400, 50));

            //set the LineColor
            shape.ShapeStyle.LineColor.Color = Color.Black;

            //set the color and fill style
            shape.Fill.FillType = Spire.Presentation.Drawing.FillFormatType.Solid;
            shape.Fill.SolidColor.Color = Color.LightGray;
            shape.AppendTextFrame("This is a demo of text font and color.");

            //set the color of text in shape
            TextRange textRange = shape.TextFrame.TextRange;
            textRange.Fill.FillType = Spire.Presentation.Drawing.FillFormatType.Solid;
            textRange.Fill.SolidColor.Color = Color.Green;

            //set the Font of text in shape
            textRange.FontHeight = 21;
            textRange.IsItalic = TriState.True;
            textRange.TextUnderlineType = TextUnderlineType.Single;
            textRange.LatinFont = new TextFont("Gulim");

            //save the document
            presentation.SaveToFile("text.pptx", FileFormat.Pptx2007);
            System.Diagnostics.Process.Start("text.pptx");
        }
    }
}

Screenshot:

PPT text Alignment can be taken as one kind of text format tools. It allows users to align text with the following styles: Left, Right, Center and Justify. By default, text will be aligned right. Also, users can customize alignment. Below demonstrate the effect by a screenshot which shows the text is corresponding to the alignment, for example, text Left is aligned left and Center is aligned center.

Spire.Presentation for .NET, a professional .NET PPT component to allow users to manipulate PPT documents without automation. This guide will introduce a method to align text with C#, VB.NET via Spire.Presentation for .NET.

The method is:

First, new a PPT document, and set its slide. Then, traversal all alignment and use the new paragraph to show them. Last set the font and fill style for added paragraphs.

Download and install Spire.Presentation for .NET and use below code to experience this method to align text in PPT document.

The full code:

using System;
using System.Drawing;
using Spire.Presentation;
using Spire.Presentation.Drawing;

namespace Alignment
{
    class Program
    {
        static void Main(string[] args)
        {
            Presentation presentation = new Presentation();


            //set background Image
            string ImageFile = @"bg.png";
            // set the rectangle size and position
            RectangleF rect = new RectangleF(0, 0, presentation.SlideSize.Size.Width, presentation.SlideSize.Size.Height);     
    //set the slide's shapes,background image and rectangle .
            presentation.Slides[0].Shapes.AppendEmbedImage(ShapeType.Rectangle, ImageFile, rect);
            //set the shape's solidFillColor 
            presentation.Slides[0].Shapes[0].Line.FillFormat.SolidFillColor.Color = Color.FloralWhite;

            //append new shape 
            IAutoShape shape = presentation.Slides[0].Shapes.AppendShape(ShapeType.Rectangle, new RectangleF(50, 70, 600, 400));

            shape.TextFrame.Paragraphs[0].Alignment = TextAlignmentType.Left;
            shape.Fill.FillType = FillFormatType.None;
            shape.TextFrame.Text = "Demo about Alignment";

            foreach (TextAlignmentType textAlign in Enum.GetValues(typeof(TextAlignmentType)))
            {
                //create a text range
                TextRange textRange = new TextRange(textAlign.ToString());

                //create a new paragraph
                TextParagraph paragraph = new TextParagraph();

                //apend the text range
                paragraph.TextRanges.Append(textRange);

                //set the alignment
                paragraph.Alignment = textAlign;

                //append to shape

                shape.TextFrame.Paragraphs.Append(paragraph);
            }


            //set the font and fill style
            foreach (TextParagraph paragraph in shape.TextFrame.Paragraphs)
            {
                paragraph.TextRanges[0].LatinFont = new TextFont("Arial Black");
                paragraph.TextRanges[0].Fill.FillType = FillFormatType.Solid;
                paragraph.TextRanges[0].Fill.SolidColor.Color = Color.Black;
            }

            //save the document
            presentation.SaveToFile("alignment.pptx", FileFormat.Pptx2010);
            System.Diagnostics.Process.Start("alignment.pptx");
        }
    }
}

Imports System.Text
Imports System.Drawing
Imports Spire.Presentation
Imports Spire.Presentation.Drawing

Public Class Form1

    Private Sub btnRun_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRun.Click

        'create PPT document
        Dim presentation As New Presentation()

        'set background Image
        Dim ImageFile As String = "bg.png"
        Dim rect As New RectangleF(0, 0, presentation.SlideSize.Size.Width, presentation.SlideSize.Size.Height)
        presentation.Slides(0).Shapes.AppendEmbedImage(ShapeType.Rectangle, ImageFile, rect)
        presentation.Slides(0).Shapes(0).Line.FillFormat.SolidFillColor.Color = Color.FloralWhite

        'append new shape
        Dim shape As IAutoShape = presentation.Slides(0).Shapes.AppendShape(ShapeType.Rectangle, New RectangleF(50, 70, 350, 200))
        shape.TextFrame.Paragraphs(0).Alignment = TextAlignmentType.Left
        shape.Fill.FillType = FillFormatType.None
        shape.TextFrame.Text = "Demo about Alignment"

        For Each textAlign As TextAlignmentType In [Enum].GetValues(GetType(TextAlignmentType))
            'create a text range
            Dim textRange As New TextRange(textAlign.ToString())

            'create a new paragraph
            Dim paragraph As New TextParagraph()

            'apend the text range
            paragraph.TextRanges.Append(textRange)

            'set the alignment
            paragraph.Alignment = textAlign

            'append to shape
            shape.TextFrame.Paragraphs.Append(paragraph)
        Next


        'set the font and fill style
        For Each paragraph As TextParagraph In shape.TextFrame.Paragraphs
            paragraph.TextRanges(0).LatinFont = New TextFont("Arial Black")
            paragraph.TextRanges(0).Fill.FillType = FillFormatType.Solid
            paragraph.TextRanges(0).Fill.SolidColor.Color = Color.Black
        Next

        'save the document
        presentation.SaveToFile("alignment.pptx", FileFormat.Pptx2010)
        System.Diagnostics.Process.Start("alignment.pptx")

    End Sub
End Class

In this document, we will quickly help you finish a simple demo about Spire.Presentation using Visual Studio. As usual, it's a HelloWorld demo. Before you get started, please make sure the Spire.Presentation and Visual Studio (2005 or later) are installed on your computer.

1. In Visual Studio, click, File, New, and then Project. If you want to create a C# project, select Visual C#, Windows and choose Windows Forms Application and name the project HelloWorld. Click OK. If you want to create a Visual Basic project, select Visual Basic, Windows Forms Application and name the project HelloWorld. Click OK.

2. In Solution Explorer, right-click the project HelloWorld and click Add Reference. In the Browse tab, find the folder which you installed the Spire.Presentation in, default is "C:\ProgramFiles\e-iceblue\ Spire.Presentation", double-click the folder Bin. If the target framework of the project HelloWorld

• is .NET 2.0, double-click folder NET2.0
• is .NET 3.5, double-click folder NET3.5
• is .NET 4.0, double-click folder NET4.0

Select assembly Spire.Presentation.dll and click OK to add it to the project.

3. In Solution Explorer, double-click the file Form1.cs/Form1.vb to open the form design view, add a button into the form, and change its name to 'btnRun', change its text to 'Run'.

4. Double-click the button 'Run', you will see the code view and the following method has been added automatically:

private void btnRun_Click(object sender, EventArgs e)

Private Sub btnRun_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRun.Click

5. Add the following codes to the top of the file:

using  Spire.Presentation;
using  Spire.Presentation.Drawing;

Imports  Spire.Presentation
Imports  Spire.Presentation.Drawing

6. Add the following codes to the method btnRun_Click

//create PPT document
Presentation  presentation = new Presentation();  
//add new shape to PPT document           
IAutoShape shape = presentation.Slides[0].Shapes.AppendShape(ShapeType.Rectangle,
					new RectangleF(0, 50, 200, 50));
shape.ShapeStyle.LineColor.Color = Color.White;
shape.Fill.FillType = Spire.Presentation.Drawing.FillFormatType.None;  
//add text to shape
shape.AppendTextFrame("Hello World!");   
//set the Font fill style of text  
TextRange textRange = shape.TextFrame.TextRange;
textRange.Fill.FillType = Presentation.Drawing.FillFormatType.Solid;
textRange.Fill.SolidColor.Color = Color.Black;  
textRange.LatinFont = new TextFont("Arial Black");  
//save the document
presentation.SaveToFile("hello.pptx", FileFormat.Pptx2010);
System.Diagnostics.Process.Start("hello.pptx");

'create PPT document  
Dim presentation As New Presentation()   
'add new shape to PPT document
Dim shape As IAutoShape = presentation.Slides(0).Shapes.AppendShape(ShapeType.Rectangle, New RectangleF(0, 50, 200, 50)    
shape.ShapeStyle.LineColor.Color = Color.White
shape.Fill.FillType = Spire.Presentation.Drawing.FillFormatType.None  
'add text to shape  
shape.AppendTextFrame("Hello World!")  
'set the Font fill style of text
Dim textRange As TextRange = shape.TextFrame.TextRange
textRange.Fill.FillType =  Spire.Presentation.Drawing.FillFormatType.Solid
textRange.Fill.SolidColor.Color = Color.Black
textRange.LatinFont = New TextFont("Arial Black")  
'save the document
presentation.SaveToFile("hello.pptx", FileFormat.Pptx2010)
System.Diagnostics.Process.Start("hello.pptx")

7. In Solution Explorer, right-click the project HelloWorld and click Debug, then Start new instance, you will see the opened window Form1, click the button 'Run', a PPT document will be created, edited and opened. The string "Hello, World" is filled in the first page.

The following screenshot is result of the project ran:

You may need to convert PowerPoint documents to images for various purposes, such as preventing other users from editing the contents of the PowerPoint documents, generating thumbnails for the PowerPoint documents, or sharing the PowerPoint documents on social media. In this article, you will learn how to convert PowerPoint documents to various image formats in C# and VB.NET using Spire.Presentation for .NET.

• Convert PowerPoint Documents to JPG or PNG Images
• Convert PowerPoint Documents to TIFF Images
• Convert PowerPoint Documents to EMF Images
• Convert PowerPoint Documents to SVG Images

Install Spire.Presentation for .NET

To begin with, you need to add the DLL files included in the Spire.Presentation 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.Presentation

Convert PowerPoint Documents to JPG or PNG Images in C# and VB.NET

The following are the main steps to convert a PowerPoint document to JPG or PNG image:

• Initialize an instance of Presentation class.
• Load a PowerPoint document using Presentation.LoadFromFile() method.
• Iterate through all slides in the PowerPoint document.
• Save each slide as System.Drawing.Image object using ISlide.SaveAsImage() method.
• Save the image object to PNG or JPG file using Image.Save() method.

using Spire.Presentation;
using System.Drawing;

namespace ConvertPowerPointToJpgOrPngImage
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create a Presentation instance
            Presentation presentation = new Presentation();
            //Load a PowerPoint document
            presentation.LoadFromFile(@"Sample.pptx");

            int i = 0;
            //Iterate through all slides in the PowerPoint document
            foreach(ISlide slide in presentation.Slides)
            {                 
                //Save each slide as PNG image
                Image image = slide.SaveAsImage();
                string fileName = string.Format("ToImage-img-{0}.png", i);
                image.Save(fileName, System.Drawing.Imaging.ImageFormat.Png);
                i++;
            }
        }
    }
}

Imports Spire.Presentation

Namespace ConvertPowerPointToJpgOrPngImage
    Friend Class Program
        Private Shared Sub Main(ByVal args As String())
            'Create a Presentation instance
            Dim presentation As Presentation = New Presentation()
            'Load a PowerPoint document
            presentation.LoadFromFile("Sample.pptx")

            Dim i = 0
            'Iterate through all slides in the PowerPoint document
            For Each slide As ISlide In presentation.Slides
                'Save each slide as PNG image
                Dim image As Image = slide.SaveAsImage()
                Dim fileName = String.Format("ToImage-img-{0}.png", i)
                image.Save(fileName, Drawing.Imaging.ImageFormat.Png)
                i += 1
            Next
        End Sub
    End Class
End Namespace

Convert PowerPoint Documents to TIFF Images in C# and VB.NET

The following are the steps to convert a PowerPoint document to TIFF image:

• Initialize an instance of Presentation class.
• Load a PowerPoint document using Presentation.LoadFromFile() method.
• Convert the PowerPoint document to TIFF image using Presentation.SaveToFile(string, FileFormat) method.

using Spire.Presentation;

namespace ConvertPowerPointToTiffImage
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create a Presentation instance
            Presentation presentation = new Presentation();
            //Load a PowerPoint document
            presentation.LoadFromFile(@"Sample.pptx");

            //Convert the PowerPoint document to TIFF image
            presentation.SaveToFile("toTIFF.tiff", FileFormat.Tiff);
        }
    }
}

Imports Spire.Presentation

Namespace ConvertPowerPointToTiffImage
    Friend Class Program
        Private Shared Sub Main(ByVal args As String())
            'Create a Presentation instance
            Dim presentation As Presentation = New Presentation()
            'Load a PowerPoint document
            presentation.LoadFromFile("Sample.pptx")

            'Convert the PowerPoint document to TIFF image
            presentation.SaveToFile("toTIFF.tiff", FileFormat.Tiff)
        End Sub
    End Class
End Namespace

Convert PowerPoint Documents to EMF Images in C# and VB.NET

The following are the steps to convert a PowerPoint document to EMF image:

• Initialize an instance of Presentation class.
• Load a PowerPoint document using Presentation.LoadFromFile() method.
• Iterate through all slides in the PowerPoint document.
• Save each slide to EMF image using ISlide.SaveAsEMF() method.

using Spire.Presentation;

namespace ConvertPowerPointToEmfImage
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create a Presentation instance
            Presentation presentation = new Presentation();
            //Load a PowerPoint document
            presentation.LoadFromFile(@"Sample.pptx");

            int i = 0;
            //Iterate through all slides in the PowerPoint document
            foreach (ISlide slide in presentation.Slides)
            {
                string fileName = string.Format("ToEmf-{0}.emf", i);
                //Save each slide to EMF image
                slide.SaveAsEMF(fileName);
                //Save each slide to EMF image with specified width and height
                //slide.SaveAsEMF(fileName, 1075, 710);
                i++;
            }
        }
    }
}

Imports Spire.Presentation

Namespace ConvertPowerPointToEmfImage
    Friend Class Program
        Private Shared Sub Main(ByVal args As String())
            'Create a Presentation instance
            Dim presentation As Presentation = New Presentation()
            'Load a PowerPoint document
            presentation.LoadFromFile("Sample.pptx")

            Dim i = 0
            'Iterate through all slides in the PowerPoint document
            For Each slide As ISlide In presentation.Slides
                Dim fileName = String.Format("ToEmf-{0}.emf", i)
                'Save each slide to EMF image
                slide.SaveAsEMF(fileName)
                'Save each slide to EMF image with specified width and height
                'slide.SaveAsEMF(fileName, 1075, 710);
                i += 1
            Next
        End Sub
    End Class
End Namespace

Convert PowerPoint Documents to SVG Images in C# and VB.NET

The following are the steps to convert a PowerPoint document to SVG images:

• Initialize an instance of Presentation class.
• Load a PowerPoint document using Presentation.LoadFromFile() method.
• Convert the PowerPoint document to SVG and save the results into a queue of byte arrays using Presentation.SaveToSVG() method.
• Iterate through the byte arrays in the queue.
• At each iteration, remove and return the byte array at the beginning of the queue using Queue.Dequeue() method.
• Initialize an instance of FileStream class and save the byte array to an SVG file using FileStream.Write() method.

using Spire.Presentation;
using System.Collections.Generic;
using System.IO;

namespace ConvertPowerPointToSvgImage
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create a Presentation instance
            Presentation presentation = new Presentation();
            //Load a PowerPoint document
            presentation.LoadFromFile(@"Sample.pptx");

            //Convert the PowerPoint document to SVG and save the results into a queue of byte arrays
            Queue svgBytes = presentation.SaveToSVG();
            int count = svgBytes.Count;
            //Iterate through the byte arrays in the queue
            for (int i = 0; i < count; i++)
            {
                //Remove and return the byte array at the beginning of the queue
                byte[] bt = svgBytes.Dequeue();
                //Specify the output file name
                string fileName = string.Format("ToSVG-{0}.svg", i);
                //Create a FileStream instance
                FileStream fs = new FileStream(fileName, FileMode.Create);
                //Save the byte array to a SVG file
                fs.Write(bt, 0, bt.Length);
            }
        }
    }
}

Imports Spire.Presentation
Imports System.Collections.Generic
Imports System.IO

Namespace ConvertPowerPointToSvgImage
    Friend Class Program
        Private Shared Sub Main(ByVal args As String())
            'Create a Presentation instance
            Dim presentation As Presentation = New Presentation()
            'Load a PowerPoint document
            presentation.LoadFromFile("Sample.pptx")

            'Convert the PowerPoint document to SVG and save the results into a queue of byte arrays
            Dim svgBytes As Queue(Of Byte()) = presentation.SaveToSVG()
            Dim count = svgBytes.Count
            'Iterate through the byte arrays in the queue
            For i = 0 To count - 1
                'Remove and return the byte array at the beginning of the queue
                Dim bt As Byte() = svgBytes.Dequeue()
                'Specify the output file name
                Dim fileName = String.Format("ToSVG-{0}.svg", i)
                'Create a FileStream instance
                Dim fs As FileStream = New FileStream(fileName, FileMode.Create)
                'Save the byte array to a SVG file
                fs.Write(bt, 0, bt.Length)
            Next
        End Sub
    End Class
End Namespace

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.

In this document, I will introduce you how to add Spire.PDFViewer controls to Toolbox for WPF application.

How To

Right-click on the blank part of the Toolbox - "Add Tab" - name the new Tab "Spire WPF Controls":

Right-click on the blank part below "Spire WPF Controls" - "Choose Items" - "WPF Components" - "Browse" to the "Bin" folder - find the file "Spire.PdfViewer.Wpf.dll" - "Open".

Click "OK". Then you have added controls to Toolbox successfully.

There are three ways to add Spire.PDFViewer controls to Toolbox for Windows Forms application.

In this document, these ways are introduced.

The First Solution

Set the CheckBox below to the CheckState "Checked" during installing Spire.PDFViewer.

After installment is completed, controls will be added to the Toolbox.

The Second Solution

If you have already installed Spire.PDFViewer, you can also add controls this way:

"Start" -"Programs" -"e-iceblue" -"Spire.PDFViewer" : Click "Add Controls into VS Toolbox".

Click "Add" to add controls.

The Third Solution

Right-click on the blank part of the Toolbox - "Add Tab" - name the new Tab "Spire Controls" :

Right-click on the blank part below "Spire Controls" - "Choose Items" - ".NET Framework Components" - "Browse" to the "Bin" folder – find the file "Spire.PdfViewer.Forms.dll"- "Open".

Click “OK”. Then you have added controls to Toolbox successfully.

In this document, I will introduce you how to add Spire.DataExport controls to Toolbox for Windows Forms application.

How To

If you have already installed Spire.DataExport, you can add controls this way:

"Start" - "Programs" - "e-iceblue" - "Spire.DataExport" : Click "Add Controls into VS Toolbox".

Click "Add" to add controls.

How To

Right-click on the blank part of the Toolbo - "Add Tab" - name the new Tab "Spire Controls":

Right-click on the blank part below "Spire Controls"- "Choose Items" - ".NET Framework Components" - "Browse” to the "Bin" folde - find the file "Spire.DataExport.dll" -"Open".

Click "OK". Then you have added controls to Toolbox successfully.

In this document, I will introduce you how to add Spire.DocViewer controls to Toolbox for WPF application.

How To

Right-click on the blank part of the Toolbox - "Add Tab" - name the new Tab "Spire WPF Controls":

Right-click on the blank part below "Spire WPF Controls" - "Choose Items" - "WPF Components" - "Browse" to the "Bin" folder - find the file "Spire.DocViewer.Wpf.dll" - "Open".

Click "OK". Then you have added controls to Toolbox successfully.

There are three ways to add Spire.DocViewer controls to Toolbox for Windows Forms application.

In this document, these ways are introduced. Hoping this document can be helpful to you.

The First Solution

Set the CheckBox below to the CheckState "Checked" during installing Spire.DocViewer.

After installment is completed, controls will be added to the Toolbox.

The Second Solution

If you have already installed Spire.DocViewer, you can also add controls this way:

"Start" - "Programs" - "e-iceblue" - "Spire.DocViewer" : Click "Add Controls into VS Toolbox".

Click "Add" to add controls.

The Third Solution

Right-click on the blank part of the Toolbox - "Add Tab" - name the new Tab "Spire Controls":

Right-click on the blank part below "Spire Controls" - "Choose Items" - ".NET Framework Components" - "Browse" to the "Bin" folder - find the file "Spire.DocViewer.Forms.dll" - "Open"

Click "OK". Then you have added controls to Toolbox successfully.