page 76

Subscribe to this RSS feed

.NET (1317)

Children categories

Spire.DataExport for .NET (33)

View items...

Spire.Presentation for .NET (204)

View items...

Spire.Spreadsheet for .NET (1)

View items...

Spire.PDFViewer for MAUI (1)

View items...

How to Set Word Table Column Width

2012-03-15 09:31:47 Written by Koohji

By using Spire.Doc, developers can create Word document with a table inside (Click to learn how to create table in Word document). But when users create table in Word document, they would not only create table with blank cells. They need set formats or sometimes set table size like column width. This article will show you how to set Word table column width.

Make sure Spire.Doc and Visual Studio are correctly installed on system. Follow the simple steps below to set Word table column width.

Step 1: Create a C# windows form application in Visual Studio. Add Spire.Doc.dll as reference. The default setting of Spire.Doc.dll is placed under "C:\Program Files\e-iceblue\Spire.Doc\Bin". Select assembly Spire.Doc.dll and click OK to add it to the project.

[C#]

using System;
using Spire.Doc;
using Spire.Doc.Fields;
using Spire.Doc.Documents;

namespace TableWidth
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        private void button1_Click(object sender, EventArgs e)
        {
        }
    }
}

[VB.NET]

Imports Spire.Doc
Imports Spire.Doc.Fields
Imports Spire.Doc.Documents

Namespace TableWidth
	Public Partial Class Form1
		Inherits Form
		Public Sub New()
			InitializeComponent()
		End Sub
		Private Sub button1_Click(sender As Object, e As EventArgs)
		End Sub
	End Class
End Namespace

Step 2: Put the word document with table into the project folder. Use the following code to load it into project.

[C#]

Document doc = new Document();
            doc.LoadFromFile(@"..\..\Table.docx",FileFormat.Docx);

[VB.NET]

Dim doc As New Document()
doc.LoadFromFile("..\..\Table.docx", FileFormat.Docx)

Step 3: Because Spire.Doc doesn't have a direct method to set column width, we need set the first cell width of in each row.

[C#]

            for (int i = 0; i < document.Sections[0].Tables[0].Rows.Count; i++)
            {
                document.Sections[0].Tables[0].Rows[i].Cells[0].Width = 20;
            }

[VB.NET]

For i As Integer = 0 To document.Sections(0).Tables(0).Rows.Count - 1
	document.Sections(0).Tables(0).Rows(i).Cells(0).Width = 20
Next

Step 4: Save and Preview.

[C#]

document.SaveToFile(@"..\..\Sample.docx",FileFormat.Docx);

[VB.NET]

document.SaveToFile("..\..\Sample.docx", FileFormat.Docx)
System.Diagnostics.Process.Start("..\..\Test.pdf")

Now, the whole process is finished. Press F5 and click the button to run the project. The generated docx file can be found at the project debug folder. Check the effect.

Before Setting Width:

After Setting Width:

As a professional and powerful Word component, Spire.Doc doesn't need Microsoft Office Word Automation but also allows user to directly operate Word document, format and style and insert content to Word document.Click to learn more feature functions of Spire.Doc

Published in Table

Tagged under

doc net Table

PDF Overlay in Silverlight

2012-03-13 08:57:09 Written by Koohji

Demo
App.xaml
App.xaml.cs
App.xaml.vb
MainPage.xaml
MainPage.xaml.cs
MainPage.xaml.vb

The sample demonstrates how to make PDF overlay effect in Silverlight via Spire.PDF.

<Application xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
             xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" 
             x:Class="Overlay.App">
             
    <Application.Resources>
        
    </Application.Resources>
</Application>

using System;
using System.Windows;

namespace Overlay
{
    public partial class App : Application
    {

        public App()
        {
            this.Startup += this.Application_Startup;
            this.Exit += this.Application_Exit;
            this.UnhandledException += this.Application_UnhandledException;

            InitializeComponent();
        }

        private void Application_Startup(object sender, StartupEventArgs e)
        {
            this.RootVisual = new MainPage();
        }

        private void Application_Exit(object sender, EventArgs e)
        {

        }

        private void Application_UnhandledException(object sender, ApplicationUnhandledExceptionEventArgs e)
        {
            // If the app is running outside of the debugger then report the exception using
            // the browser's exception mechanism. On IE this will display it a yellow alert 
            // icon in the status bar and Firefox will display a script error.
            if (!System.Diagnostics.Debugger.IsAttached)
            {

                // NOTE: This will allow the application to continue running after an exception has been thrown
                // but not handled. 
                // For production applications this error handling should be replaced with something that will 
                // report the error to the website and stop the application.
                e.Handled = true;
                Deployment.Current.Dispatcher.BeginInvoke(delegate { ReportErrorToDOM(e); });
            }
        }

        private void ReportErrorToDOM(ApplicationUnhandledExceptionEventArgs e)
        {
            try
            {
                string errorMsg = e.ExceptionObject.Message + e.ExceptionObject.StackTrace;
                errorMsg = errorMsg.Replace('"', '\'').Replace("\r\n", @"\n");

                System.Windows.Browser.HtmlPage.Window.Eval("throw new Error(\"Unhandled Error in Silverlight Application " + errorMsg + "\");");
            }
            catch (Exception)
            {
            }
        }
    }
}

Imports System.Windows

Namespace Overlay
	Partial Public Class App
		Inherits Application

		Public Sub New()
			AddHandler Me.Startup, AddressOf Application_Startup
			AddHandler Me.Exit, AddressOf Application_Exit
			AddHandler Me.UnhandledException, AddressOf Application_UnhandledException

			InitializeComponent()
		End Sub

		Private Sub Application_Startup(ByVal sender As Object, ByVal e As StartupEventArgs)
			Me.RootVisual = New MainPage()
		End Sub

		Private Sub Application_Exit(ByVal sender As Object, ByVal e As EventArgs)

		End Sub

		Private Sub Application_UnhandledException(ByVal sender As Object, ByVal e As ApplicationUnhandledExceptionEventArgs)
			' If the app is running outside of the debugger then report the exception using
			' the browser's exception mechanism. On IE this will display it a yellow alert 
			' icon in the status bar and Firefox will display a script error.
			If Not Debugger.IsAttached Then

				' NOTE: This will allow the application to continue running after an exception has been thrown
				' but not handled. 
				' For production applications this error handling should be replaced with something that will 
				' report the error to the website and stop the application.
				e.Handled = True
				Deployment.Current.Dispatcher.BeginInvoke(Sub() ReportErrorToDOM(e))
			End If
		End Sub

		Private Sub ReportErrorToDOM(ByVal e As ApplicationUnhandledExceptionEventArgs)
			Try
				Dim errorMsg As String = e.ExceptionObject.Message + e.ExceptionObject.StackTrace
				errorMsg = errorMsg.Replace(""""c, "'"c).Replace(vbCrLf, vbLf)

				System.Windows.Browser.HtmlPage.Window.Eval("throw new Error(""Unhandled Error in Silverlight Application " & errorMsg & """);")
			Catch e1 As Exception
			End Try
		End Sub
	End Class
End Namespace

<UserControl x:Class="Overlay.MainPage"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
    xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
    mc:Ignorable="d"
    d:DesignHeight="300" d:DesignWidth="400" Loaded="UserControl_Loaded">

    <Grid x:Name="LayoutRoot" Background="White">
        <Button Content="Run" Height="23" HorizontalAlignment="Left" Margin="295,254,0,0" Name="button1" VerticalAlignment="Top" Width="75" Click="button1_Click" />
    </Grid>
</UserControl>

using System.Windows;
using System.Windows.Controls;
using System.IO;
using System.Reflection;
using System.Drawing;

using Spire.Pdf;
using Spire.Pdf.Graphics;

namespace Overlay
{
    public partial class MainPage : UserControl
    {
        private SaveFileDialog saveFileDialog = null;
        private PdfDocument pdfDoc = null;
        public MainPage()
        {
            InitializeComponent();
            this.saveFileDialog = new SaveFileDialog();
            this.saveFileDialog.Filter = "PDF Document(*.pdf)|*.pdf";
        }

        private void button1_Click(object sender, RoutedEventArgs e)
        {
            //create a page template
            PdfTemplate template = this.pdfDoc.Pages[3].CreateTemplate();
            PointF location = new PointF(20, -40);          
            //overlay the pdfDoc
            foreach (PdfPageBase page in this.pdfDoc.Pages)
            {
                page.Canvas.SetTransparency(0.25f, 0.25f, PdfBlendMode.Overlay);
                page.Canvas.DrawTemplate(template, location);
            }

            //save the pdfDoc
            bool? result = this.saveFileDialog.ShowDialog();
            if (result.HasValue && result.Value)
            {
                using (Stream stream = this.saveFileDialog.OpenFile())
                {
                    this.pdfDoc.SaveToStream(stream);
                }
            }
        }

        private void UserControl_Loaded(object sender, RoutedEventArgs e)
        {
            //load the pdf templates
            Assembly assembly = this.GetType().Assembly;

            foreach (string name in assembly.GetManifestResourceNames())
            {
                if (name.EndsWith("Sample3.pdf"))
                {
                    this.pdfDoc = new PdfDocument(assembly.GetManifestResourceStream(name));
                }
            }
        }
    }
}

Imports System.Windows
Imports System.Windows.Controls
Imports System.IO
Imports System.Reflection
Imports System.Drawing

Imports Spire.Pdf
Imports Spire.Pdf.Graphics

Namespace Overlay
	Partial Public Class MainPage
		Inherits UserControl
		Private saveFileDialog As SaveFileDialog = Nothing
		Private pdfDoc As PdfDocument = Nothing
		Public Sub New()
			InitializeComponent()
			Me.saveFileDialog = New SaveFileDialog()
			Me.saveFileDialog.Filter = "PDF Document(*.pdf)|*.pdf"
		End Sub

		Private Sub button1_Click(ByVal sender As Object, ByVal e As RoutedEventArgs)
			'create a page template
			Dim template As PdfTemplate = Me.pdfDoc.Pages(3).CreateTemplate()
                        Dim location As PointF=New PointF(20,-40);
                        'overlay the pdfDoc
			For Each page As PdfPageBase In Me.pdfDoc.Pages
				page.Canvas.SetTransparency(0.25f, 0.25f, PdfBlendMode.Overlay)
				page.Canvas.DrawTemplate(template, location)
			Next page

			'save the pdfDoc
			Dim result? As Boolean = Me.saveFileDialog.ShowDialog()
			If result.HasValue AndAlso result.Value Then
				Using stream As Stream = Me.saveFileDialog.OpenFile()
					Me.pdfDoc.SaveToStream(stream)
				End Using
			End If
		End Sub

		Private Sub UserControl_Loaded(ByVal sender As Object, ByVal e As RoutedEventArgs)
			'load the pdf templates
			Dim [assembly] As System.Reflection.Assembly = Me.GetType().Assembly

			For Each name As String In [assembly].GetManifestResourceNames()
				If name.EndsWith("Sample3.pdf") Then
					Me.pdfDoc = New PdfDocument([assembly].GetManifestResourceStream(name))
				End If
			Next name
		End Sub
	End Class
End Namespace

Published in Drawing

Demo
App.xaml
App.xaml.cs
App.xaml.vb
MainPage.xaml
MainPage.xaml.cs
MainPage.xaml.vb

The sample demonstrates how to Copy Excel Worksheet in Silverlight via Spire.XLS.

<Application xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
             xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" 
             x:Class="copySheet.App">
             
    <Application.Resources>
        
    </Application.Resources>
</Application>

using System;
using System.Windows;

namespace copySheet
{
    public partial class App : Application
    {

        public App()
        {
            this.Startup += this.Application_Startup;
            this.Exit += this.Application_Exit;
            this.UnhandledException += this.Application_UnhandledException;

            InitializeComponent();
        }

        private void Application_Startup(object sender, StartupEventArgs e)
        {
            this.RootVisual = new MainPage();
        }

        private void Application_Exit(object sender, EventArgs e)
        {

        }

        private void Application_UnhandledException(object sender, ApplicationUnhandledExceptionEventArgs e)
        {
            // If the app is running outside of the debugger then report the exception using
            // the browser's exception mechanism. On IE this will display it a yellow alert 
            // icon in the status bar and Firefox will display a script error.
            if (!System.Diagnostics.Debugger.IsAttached)
            {

                // NOTE: This will allow the application to continue running after an exception has been thrown
                // but not handled. 
                // For production applications this error handling should be replaced with something that will 
                // report the error to the website and stop the application.
                e.Handled = true;
                Deployment.Current.Dispatcher.BeginInvoke(delegate { ReportErrorToDOM(e); });
            }
        }

        private void ReportErrorToDOM(ApplicationUnhandledExceptionEventArgs e)
        {
            try
            {
                string errorMsg = e.ExceptionObject.Message + e.ExceptionObject.StackTrace;
                errorMsg = errorMsg.Replace('"', '\'').Replace("\r\n", @"\n");

                System.Windows.Browser.HtmlPage.Window.Eval("throw new Error(\"Unhandled Error in Silverlight Application " + errorMsg + "\");");
            }
            catch (Exception)
            {
            }
        }
    }
}

Imports System.Windows

Namespace copySheet
	Partial Public Class App
		Inherits Application

		Public Sub New()
			AddHandler Me.Startup, AddressOf Application_Startup
			AddHandler Me.Exit, AddressOf Application_Exit
			AddHandler Me.UnhandledException, AddressOf Application_UnhandledException

			InitializeComponent()
		End Sub

		Private Sub Application_Startup(ByVal sender As Object, ByVal e As StartupEventArgs)
			Me.RootVisual = New MainPage()
		End Sub

		Private Sub Application_Exit(ByVal sender As Object, ByVal e As EventArgs)

		End Sub

		Private Sub Application_UnhandledException(ByVal sender As Object, ByVal e As ApplicationUnhandledExceptionEventArgs)
			' If the app is running outside of the debugger then report the exception using
			' the browser's exception mechanism. On IE this will display it a yellow alert 
			' icon in the status bar and Firefox will display a script error.
			If Not Debugger.IsAttached Then

				' NOTE: This will allow the application to continue running after an exception has been thrown
				' but not handled. 
				' For production applications this error handling should be replaced with something that will 
				' report the error to the website and stop the application.
				e.Handled = True
				Deployment.Current.Dispatcher.BeginInvoke(Sub() ReportErrorToDOM(e))
			End If
		End Sub

		Private Sub ReportErrorToDOM(ByVal e As ApplicationUnhandledExceptionEventArgs)
			Try
				Dim errorMsg As String = e.ExceptionObject.Message + e.ExceptionObject.StackTrace
				errorMsg = errorMsg.Replace(""""c, "'"c).Replace(vbCrLf, vbLf)

				System.Windows.Browser.HtmlPage.Window.Eval("throw new Error(""Unhandled Error in Silverlight Application " & errorMsg & """);")
			Catch e1 As Exception
			End Try
		End Sub
	End Class
End Namespace

<UserControl x:Class="copySheet.MainPage"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
    xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
    mc:Ignorable="d"
    d:DesignHeight="300" d:DesignWidth="400">

    <Grid x:Name="LayoutRoot" Background="White" Loaded="LayoutRoot_Loaded">
        <Button Content="Run" Height="23" HorizontalAlignment="Left" Margin="296,262,0,0" Name="button1" VerticalAlignment="Top" Width="75" Click="button1_Click" />
    </Grid>
</UserControl>

using System.Windows;
using System.Windows.Controls;
using System.Reflection;
using System.IO;

using Spire.Xls;

namespace copySheet
{
    public partial class MainPage : UserControl
    {
        //create a workbook
        private Workbook workbook = null;

        //create a SaveFileDialog to save the workbook
        private SaveFileDialog saveFileDialog = null;
        public MainPage()
        {
            InitializeComponent();
            this.workbook = new Workbook();
            this.saveFileDialog = new SaveFileDialog();
            this.saveFileDialog.Filter = "Excel Documents(*.xls)|*.xls";
        }

        private void button1_Click(object sender, RoutedEventArgs e)
        {
            //create a worksheet into the workbook
            Worksheet sheetDest = this.workbook.CreateEmptySheet("Sheet2");

            //copy the first worksheet to the new worksheet
            sheetDest.CopyFrom(this.workbook.Worksheets[0]);

            //save the workbook
            bool? result = this.saveFileDialog.ShowDialog();
            if (result.HasValue && result.Value)
            {
                using (Stream saveStr = this.saveFileDialog.OpenFile())
                {
                    this.workbook.SaveToStream(saveStr);
                }
            }
        }

        private void LayoutRoot_Loaded(object sender, RoutedEventArgs e)
        {
            //load the Excel template
            Assembly assembly = this.GetType().Assembly;
            foreach (string name in assembly.GetManifestResourceNames())
            {
                if (name.EndsWith("parts.xls"))
                {
                    using (Stream fileStr = assembly.GetManifestResourceStream(name))
                    {
                        this.workbook.LoadFromStream(fileStr);
                    }
                }
            }
        }
    }
}

Imports System.Windows
Imports System.Windows.Controls
Imports System.Reflection
Imports System.IO

Imports Spire.Xls

Namespace copySheet
	Partial Public Class MainPage
		Inherits UserControl
		'create a workbook
		Private workbook As Workbook = Nothing

		'create a SaveFileDialog to save the workbook
		Private saveFileDialog As SaveFileDialog = Nothing
		Public Sub New()
			InitializeComponent()
			Me.workbook = New Workbook()
			Me.saveFileDialog = New SaveFileDialog()
			Me.saveFileDialog.Filter = "Excel Documents(*.xls)|*.xls"
		End Sub

		Private Sub button1_Click(ByVal sender As Object, ByVal e As RoutedEventArgs)
			'create a worksheet into the workbook
			Dim sheetDest As Worksheet = Me.workbook.CreateEmptySheet("Sheet2")

			'copy the first worksheet to the new worksheet
			sheetDest.CopyFrom(Me.workbook.Worksheets(0))

			'save the workbook
			Dim result? As Boolean = Me.saveFileDialog.ShowDialog()
			If result.HasValue AndAlso result.Value Then
				Using saveStr As Stream = Me.saveFileDialog.OpenFile()
					Me.workbook.SaveToStream(saveStr)
				End Using
			End If
		End Sub

		Private Sub LayoutRoot_Loaded(ByVal sender As Object, ByVal e As RoutedEventArgs)
			'load the Excel template
			Dim [assembly] As System.Reflection.Assembly = Me.GetType().Assembly
			For Each name As String In [assembly].GetManifestResourceNames()
				If name.EndsWith("parts.xls") Then
					Using fileStr As Stream = [assembly].GetManifestResourceStream(name)
						Me.workbook.LoadFromStream(fileStr)
					End Using
				End If
			Next name
		End Sub
	End Class
End Namespace

Published in Page Setup

Word Hyperlink in Silverlight

2012-03-13 08:38:01 Written by Koohji

Demo
App.xaml
App.xaml.cs
App.xaml.vb
MainPage.xaml
MainPage.xaml.cs
MainPage.xaml.vb

The sample demonstrates how to insert hyperlink into Word for Silverlight via Spire.Doc.

<Application xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
             xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" 
             x:Class="Hyperlink_doc.App">
             
    <Application.Resources>
        
    </Application.Resources>
</Application>

using System;
using System.Windows;

namespace Hyperlink_doc
{
    public partial class App : Application
    {

        public App()
        {
            this.Startup += this.Application_Startup;
            this.Exit += this.Application_Exit;
            this.UnhandledException += this.Application_UnhandledException;

            InitializeComponent();
        }

        private void Application_Startup(object sender, StartupEventArgs e)
        {
            this.RootVisual = new MainPage();
        }

        private void Application_Exit(object sender, EventArgs e)
        {

        }

        private void Application_UnhandledException(object sender, ApplicationUnhandledExceptionEventArgs e)
        {
            // If the app is running outside of the debugger then report the exception using
            // the browser's exception mechanism. On IE this will display it a yellow alert 
            // icon in the status bar and Firefox will display a script error.
            if (!System.Diagnostics.Debugger.IsAttached)
            {

                // NOTE: This will allow the application to continue running after an exception has been thrown
                // but not handled. 
                // For production applications this error handling should be replaced with something that will 
                // report the error to the website and stop the application.
                e.Handled = true;
                Deployment.Current.Dispatcher.BeginInvoke(delegate { ReportErrorToDOM(e); });
            }
        }

        private void ReportErrorToDOM(ApplicationUnhandledExceptionEventArgs e)
        {
            try
            {
                string errorMsg = e.ExceptionObject.Message + e.ExceptionObject.StackTrace;
                errorMsg = errorMsg.Replace('"', '\'').Replace("\r\n", @"\n");

                System.Windows.Browser.HtmlPage.Window.Eval("throw new Error(\"Unhandled Error in Silverlight Application " + errorMsg + "\");");
            }
            catch (Exception)
            {
            }
        }
    }
}

Imports System.Windows

Namespace Hyperlink_doc
	Partial Public Class App
		Inherits Application

		Public Sub New()
			AddHandler Me.Startup, AddressOf Application_Startup
			AddHandler Me.Exit, AddressOf Application_Exit
			AddHandler Me.UnhandledException, AddressOf Application_UnhandledException

			InitializeComponent()
		End Sub

		Private Sub Application_Startup(ByVal sender As Object, ByVal e As StartupEventArgs)
			Me.RootVisual = New MainPage()
		End Sub

		Private Sub Application_Exit(ByVal sender As Object, ByVal e As EventArgs)

		End Sub

		Private Sub Application_UnhandledException(ByVal sender As Object, ByVal e As ApplicationUnhandledExceptionEventArgs)
			' If the app is running outside of the debugger then report the exception using
			' the browser's exception mechanism. On IE this will display it a yellow alert 
			' icon in the status bar and Firefox will display a script error.
			If Not Debugger.IsAttached Then

				' NOTE: This will allow the application to continue running after an exception has been thrown
				' but not handled. 
				' For production applications this error handling should be replaced with something that will 
				' report the error to the website and stop the application.
				e.Handled = True
				Deployment.Current.Dispatcher.BeginInvoke(Sub() ReportErrorToDOM(e))
			End If
		End Sub

		Private Sub ReportErrorToDOM(ByVal e As ApplicationUnhandledExceptionEventArgs)
			Try
				Dim errorMsg As String = e.ExceptionObject.Message + e.ExceptionObject.StackTrace
				errorMsg = errorMsg.Replace(""""c, "'"c).Replace(vbCrLf, vbLf)

				System.Windows.Browser.HtmlPage.Window.Eval("throw new Error(""Unhandled Error in Silverlight Application " & errorMsg & """);")
			Catch e1 As Exception
			End Try
		End Sub
	End Class
End Namespace

<UserControl x:Class="Hyperlink_doc.MainPage"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
    xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
    mc:Ignorable="d"
    d:DesignHeight="300" d:DesignWidth="400">

    <Grid x:Name="LayoutRoot" Background="White" Loaded="LayoutRoot_Loaded">
        <Button Content="Run" Height="23" HorizontalAlignment="Left" Margin="279,260,0,0" Name="button1" VerticalAlignment="Top" Width="75" Click="button1_Click" />
    </Grid>
</UserControl>

using System.Windows;
using System.Windows.Controls;
using System.IO;
using System.Reflection;

using Spire.Doc;
using Spire.Doc.Documents;

namespace Hyperlink_doc
{
    public partial class MainPage : UserControl
    {
        private SaveFileDialog saveFileDialog = null;
        private Document document = null;
        public MainPage()
        {
            InitializeComponent();
            this.saveFileDialog = new SaveFileDialog();
            this.saveFileDialog.Filter = "Word Document(*.doc)|*.doc";
        }

        private void button1_Click(object sender, RoutedEventArgs e)
        {
            //get the first section
            Section section= this.document.Sections[0];

            //insert hyperlinks
            InsertHyperlink(section);

            //save the word template through a saveFileDialog
            bool? result = this.saveFileDialog.ShowDialog();
            if (result.HasValue && result.Value)
            {
                using (Stream saveStr = this.saveFileDialog.OpenFile())
                {
                    this.document.SaveToStream(saveStr, FileFormat.Doc);
                }
            }

        }

        private void LayoutRoot_Loaded(object sender, RoutedEventArgs e)
        {
            //load the word template
            Assembly assembly = this.GetType().Assembly;
            foreach (string name in assembly.GetManifestResourceNames())
            {
                if (name.EndsWith("iceblue.doc"))
                {
                    using (Stream fileStr = assembly.GetManifestResourceStream(name))
                    {
                        this.document = new Document(fileStr);
                    }
                }
            }
        }

        private void InsertHyperlink(Section section)
        {
            Paragraph paragraph
              = section.AddParagraph();
            paragraph.AppendText("Want to Learn More:");
            paragraph.ApplyStyle(BuiltinStyle.Heading2);
            paragraph = section.AddParagraph();
            paragraph.AppendHyperlink("www.e-iceblue.com", "www.e-iceblue.com", HyperlinkType.WebLink);

            paragraph = section.AddParagraph();
            paragraph.AppendText("Contact US");
            paragraph.ApplyStyle(BuiltinStyle.Heading2);
            paragraph = section.AddParagraph();
            paragraph.AppendHyperlink("mailto:support@e-iceblue.com", "support@e-iceblue.com", HyperlinkType.EMailLink);
        }
    }
}

Imports System.Windows
Imports System.Windows.Controls
Imports System.IO
Imports System.Reflection

Imports Spire.Doc
Imports Spire.Doc.Documents

Namespace Hyperlink_doc
	Partial Public Class MainPage
		Inherits UserControl
		Private saveFileDialog As SaveFileDialog = Nothing
		Private document As Document = Nothing
		Public Sub New()
			InitializeComponent()
			Me.saveFileDialog = New SaveFileDialog()
			Me.saveFileDialog.Filter = "Word Document(*.doc)|*.doc"
		End Sub

		Private Sub button1_Click(ByVal sender As Object, ByVal e As RoutedEventArgs)
			'get the first section
			Dim section As Section= Me.document.Sections(0)

			'insert hyperlinks
			InsertHyperlink(section)

			'save the word template through a saveFileDialog
			Dim result? As Boolean = Me.saveFileDialog.ShowDialog()
			If result.HasValue AndAlso result.Value Then
				Using saveStr As Stream = Me.saveFileDialog.OpenFile()
					Me.document.SaveToStream(saveStr, FileFormat.Doc)
				End Using
			End If

		End Sub

		Private Sub LayoutRoot_Loaded(ByVal sender As Object, ByVal e As RoutedEventArgs)
			'load the word template
			Dim [assembly] As System.Reflection.Assembly = Me.GetType().Assembly
			For Each name As String In [assembly].GetManifestResourceNames()
				If name.EndsWith("iceblue.doc") Then
					Using fileStr As Stream = [assembly].GetManifestResourceStream(name)
						Me.document = New Document(fileStr)
					End Using
				End If
			Next name
		End Sub

		Private Sub InsertHyperlink(ByVal section As Section)
			Dim paragraph As Paragraph = section.AddParagraph()
			paragraph.AppendText("Want to Learn More:")
			paragraph.ApplyStyle(BuiltinStyle.Heading2)
			paragraph = section.AddParagraph()
			paragraph.AppendHyperlink("www.e-iceblue.com", "www.e-iceblue.com", HyperlinkType.WebLink)

			paragraph = section.AddParagraph()
			paragraph.AppendText("Contact US")
			paragraph.ApplyStyle(BuiltinStyle.Heading2)
			paragraph = section.AddParagraph()
			paragraph.AppendHyperlink("mailto:support@e-iceblue.com", "support@e-iceblue.com", HyperlinkType.EMailLink)
		End Sub
	End Class
End Namespace

Published in Formating

C#/VB.NET: Rename Excel Sheets and Set Tab Colors

2022-02-24 03:05:00 Written by Koohji

An Excel file can contain dozens of sheets, and sometimes you may need to rename these sheets to make the whole workbook more organized. Meanwhile, setting different tab colors also seems to be a good way to highlight certain important sheets. This article will introduce how to programmatically rename Excel sheets and set tab colors using Spire.XLS for .NET.

Install Spire.XLS for.NET

To begin with, you need to add the DLL files included in the Spire.XLS for .NET package as references in your .NET project. The DLL files can be either downloaded from this link or installed via NuGet.

Package Manager

PM> Install-Package Spire.XLS

Rename Excel Sheets and Set Tab Colors

Spire.XLS for .NET offers a simple solution for you to rename sheets and set tab colors in Excel. The detailed steps are as follows.

Create a Workbook object.
Load a sample Excel file using Workbook.LoadFromFile() method.
Get a specified worksheet using Workbook.Worksheets[int] property.
Rename the specified worksheet using Worksheet.Name property.
Set tab color for the specified worksheet using Worksheet.TabColor property.
Save the document to another file using Workbook.SaveToFile() method.

C#
VB.NET

using Spire.Xls;
using System.Drawing;

namespace RenameWorksheet
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create a Workbook object
            Workbook workbook = new Workbook();

            //Load a sample Excel file
            workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\input.xlsx");

            //Get the specified worksheet
            Worksheet worksheet = workbook.Worksheets[0];
            Worksheet worksheet1 = workbook.Worksheets[1];
            Worksheet worksheet2 = workbook.Worksheets[2];

            //Rename Excel worksheet
            worksheet.Name = "Data";
            worksheet1.Name = "Chart";
            worksheet2.Name = "Summary";

            //Set tab color
            worksheet.TabColor = Color.DarkGreen;
            worksheet1.TabColor = Color.Gold;
            worksheet2.TabColor = Color.Blue;

            //Save to file
            workbook.SaveToFile("Rename.xlsx", ExcelVersion.Version2010);
        }
    }
}

C#/VB.NET: Rename Excel Sheets and Set Tab Colors

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.

Published in Worksheet

Tagged under

xls net Worksheet

Export PDF Document to images

2012-03-05 07:29:25 Written by Administrator

Demo
C# source
VB.Net source

The sample demonstrates how to export PDF pages as images by PdfDocumentViewer Component.

Download PDFViewer.pdf

using System;
using System.Drawing;
using System.IO;
using System.Windows.Forms;

using Spire.PdfViewer.Forms;

namespace Spire.PdfView.Demos.Export
{
    class Program
    {
        private static PdfDocumentViewer viewer = null;

        [STAThread]
        static void Main(string[] args)
        {
            Application.EnableVisualStyles();
            Application.SetCompatibleTextRenderingDefault(false);

            viewer = new PdfDocumentViewer();
            viewer.LoadFromFile("PDFViewer.pdf");

            //form and child components
            Form mainForm = new Form();
            mainForm.Text = "Spire.PdfView Demo - Export";
            mainForm.Size = new System.Drawing.Size(800, 600);
            mainForm.StartPosition = FormStartPosition.CenterScreen;

            TableLayoutPanel table = new TableLayoutPanel();
            table.ColumnCount = 3;
            table.ColumnStyles.Add(new ColumnStyle(SizeType.Percent, 50));
            table.ColumnStyles.Add(new ColumnStyle(SizeType.Absolute, 20));
            table.ColumnStyles.Add(new ColumnStyle(SizeType.Percent, 50));
            table.RowCount = 2;
            table.RowStyles.Add(new RowStyle(SizeType.Percent, 100));
            table.RowStyles.Add(new RowStyle(SizeType.Absolute, 30));

            table.Controls.Add(viewer, 0, 0);
            table.SetColumnSpan(viewer, 3);
            viewer.Dock = DockStyle.Fill;

            //Export current page to one image
            Button button = new Button();
            button.Text = "Export to one image";
            button.Size = new Size(180, 24);
            button.TextAlign = ContentAlignment.MiddleCenter;
            table.Controls.Add(button, 0, 1);
            button.Dock = DockStyle.Right;
            button.Click += ExportToOneImage;

            //Export current pdf document to multiple images
            button = new Button();
            button.Text = "Export to multiple images";
            button.Size = new Size(180, 24);
            button.TextAlign = ContentAlignment.MiddleCenter;
            table.Controls.Add(button, 2, 1);
            button.Dock = DockStyle.Left;
            button.Click += ExportToMultipleImages;

            mainForm.Controls.Add(table);
            table.Dock = DockStyle.Fill;

            Application.Run(mainForm);
        }

        private static void ExportToOneImage(object sender, EventArgs e)
        {
            if (viewer.PageCount > 0)
            {
                SaveFileDialog dialog = new SaveFileDialog();
                dialog.Filter = "PNG Format(*.png)|*.png";
                if (dialog.ShowDialog() == DialogResult.OK)
                {
                    int currentPage = viewer.CurrentPageNumber;
                    Bitmap image = viewer.SaveAsImage(currentPage - 1);
                    image.Save(dialog.FileName);
                }
            }
        }

        private static void ExportToMultipleImages(object sender, EventArgs e)
        {
            if (viewer.PageCount > 0)
            {
                FolderBrowserDialog dialog = new FolderBrowserDialog();
                if (dialog.ShowDialog() == DialogResult.OK)
                {
                    int currentPage = viewer.CurrentPageNumber;
                    Bitmap[] images = viewer.SaveAsImage(0, currentPage - 1);
                    for (int i = 0; i < images.Length; i++)
                    {
                        String fileName = Path.Combine(dialog.SelectedPath, String.Format("PDFViewer-{0}.png", i));
                        images[i].Save(fileName);
                    }
                }
            }
        }
    }
}

Imports System.Drawing
Imports System.IO
Imports System.Windows.Forms

Imports Spire.PdfViewer.Forms

Namespace Spire.PdfView.Demos.Export
    Friend NotInheritable Class Program
        Private Shared viewer As PdfDocumentViewer = Nothing

         _
        Shared Sub Main()
            Application.EnableVisualStyles()
            Application.SetCompatibleTextRenderingDefault(False)

            viewer = New PdfDocumentViewer()
            viewer.LoadFromFile("PDFViewer.pdf")

            'form and child components
            Dim mainForm As New Form()
            mainForm.Text = "Spire.PdfView Demo - Export"
            mainForm.Size = New System.Drawing.Size(800, 600)
            mainForm.StartPosition = FormStartPosition.CenterScreen

            Dim table As New TableLayoutPanel()
            table.ColumnCount = 3
            table.ColumnStyles.Add(New ColumnStyle(SizeType.Percent, 50))
            table.ColumnStyles.Add(New ColumnStyle(SizeType.Absolute, 20))
            table.ColumnStyles.Add(New ColumnStyle(SizeType.Percent, 50))
            table.RowCount = 2
            table.RowStyles.Add(New RowStyle(SizeType.Percent, 100))
            table.RowStyles.Add(New RowStyle(SizeType.Absolute, 30))

            table.Controls.Add(viewer, 0, 0)
            table.SetColumnSpan(viewer, 3)
            viewer.Dock = DockStyle.Fill

            'Export current page to one image
            Dim button As New Button()
            button.Text = "Export to one image"
            button.Size = New Size(180, 24)
            button.TextAlign = ContentAlignment.MiddleCenter
            table.Controls.Add(button, 0, 1)
            button.Dock = DockStyle.Right
            AddHandler button.Click, AddressOf ExportToOneImage

            'Export current pdf document to multiple images
            button = New Button()
            button.Text = "Export to multiple images"
            button.Size = New Size(180, 24)
            button.TextAlign = ContentAlignment.MiddleCenter
            table.Controls.Add(button, 2, 1)
            button.Dock = DockStyle.Left
            AddHandler button.Click, AddressOf ExportToMultipleImages

            mainForm.Controls.Add(table)
            table.Dock = DockStyle.Fill

            Application.Run(mainForm)
        End Sub

        Private Shared Sub ExportToOneImage(ByVal sender As Object, ByVal e As EventArgs)
            If viewer.PageCount > 0 Then
                Dim dialog As New SaveFileDialog()
                dialog.Filter = "PNG Format(*.png)|*.png"
                If dialog.ShowDialog() = DialogResult.OK Then
                    Dim currentPage As Integer = viewer.CurrentPageNumber
                    Dim image As Bitmap = viewer.SaveAsImage(currentPage - 1)
                    image.Save(dialog.FileName)
                End If
            End If
        End Sub

        Private Shared Sub ExportToMultipleImages(ByVal sender As Object, ByVal e As EventArgs)
            If viewer.PageCount > 0 Then
                Dim dialog As New FolderBrowserDialog()
                If dialog.ShowDialog() = DialogResult.OK Then
                    Dim currentPage As Integer = viewer.CurrentPageNumber
                    Dim images As Bitmap() = viewer.SaveAsImage(0, currentPage - 1)
                    For i As Integer = 0 To images.Length - 1
                        Dim fileName As [String] = Path.Combine(dialog.SelectedPath, [String].Format("PDFViewer-{0}.png", i))
                        images(i).Save(fileName)
                    Next
                End If
            End If
        End Sub
    End Class
End Namespace

Published in PDF Document Viewer

Tagged under

C#/VB.NET: Create, Fill, or Remove Fillable Forms in PDF

2022-06-17 05:46:00 Written by Administrator

The ability to create fillable PDF forms that end users can fill out (without having to print) can be a real benefit to making your business efficient. With these documents, users can download them, fill them out, save them, and send them back to you. No more printing and scanning. In this article, you will learn how to create, fill, or remove fillable forms in PDF in C# and VB.NET by using Spire.PDF for .NET.

Create Fillable Form Fields in a PDF Document
Fill Form Fields in an Existing PDF Document
Remove a Particular Field or All Fields from an Existing PDF Document

Spire.PDF for .NET offers a series of useful classes under the Spire.Pdf.Fields namespace, allowing programmers to create and edit various types of form fields including text box, check box, combo box, list box, and radio button. The table below lists some of the core classes involved in this tutorial.

Class	Description
PdfForm	Represents interactive form of the PDF document.
PdfField	Represents field of the PDF document's interactive form.
PdfTextBoxField	Represents text box field in the PDF form.
PdfCheckBoxField	Represents check box field in the PDF form.
PdfComboBoxField	Represents combo box field in the PDF Form.
PdfListBoxField	Represents list box field of the PDF form.
PdfListFieldItem	Represents an item of a list field.
PdfRadioButtonListField	Represents radio button field in the PDF form.
PdfRadioButtonListItem	Represents an item of a radio button list.
PdfButtonField	Represents button field in the PDF form.
PdfSignatureField	Represents signature field in the PDF form.

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 DLLs files can be either downloaded from this link or installed via NuGet.

Package Manager

PM> Install-Package Spire.PDF

Create Fillable Form Fields in a PDF Document

To create a PDF form, initialize an instance of the corresponding field class. Set its size and position in the document through the Bounds property, and then add it to PDF using PdfFormFieldCollection.Add() method. The following are the main steps to create various types of form fields in a PDF document using Spire.PDF for .NET.

Create a PdfDocument object.
Add a page using PdfDocuemnt.Pages.Add() method.
Create a PdfTextBoxField object, set the properties of the field including Bounds, Font and Text, and then add it to the document using PdfFormFieldCollection.Add() method.
Repeat the step 3 to add check box, combo box, list box, radio button, signature field and button to the document.
Save the document to a PDF file using PdfDocument.SaveToFile() method.

C#
VB.NET

using Spire.Pdf;
using Spire.Pdf.Actions;
using Spire.Pdf.Fields;
using Spire.Pdf.Graphics;
using System.Drawing;

namespace CreateFillableFormsInPdf
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create a PdfDocument object
            PdfDocument doc = new PdfDocument();

            //Add a page
            PdfPageBase page = doc.Pages.Add();

            //Initialize x and y coordinates
            float baseX = 100;
            float baseY = 30;

            //Create two brush objects
            PdfSolidBrush brush1 = new PdfSolidBrush(new PdfRGBColor(Color.Blue));
            PdfSolidBrush brush2 = new PdfSolidBrush(new PdfRGBColor(Color.Black));

            //Create a font 
            PdfFont font = new PdfFont(PdfFontFamily.TimesRoman, 12f, PdfFontStyle.Regular);

            //Add a textbox 
            page.Canvas.DrawString("TextBox:", font, brush1, new PointF(10, baseY));
            RectangleF tbxBounds = new RectangleF(baseX, baseY, 150, 15);
            PdfTextBoxField textBox = new PdfTextBoxField(page, "textbox");
            textBox.Bounds = tbxBounds;
            textBox.Text = "Hello World";
            textBox.Font = font;
            doc.Form.Fields.Add(textBox);
            baseY += 25;

            //add two checkboxes 
            page.Canvas.DrawString("CheckBox:", font, brush1, new PointF(10, baseY));
            RectangleF checkboxBound1 = new RectangleF(baseX, baseY, 15, 15);
            PdfCheckBoxField checkBoxField1 = new PdfCheckBoxField(page, "checkbox1");
            checkBoxField1.Bounds = checkboxBound1;
            checkBoxField1.Checked = false;
            page.Canvas.DrawString("Option 1", font, brush2, new PointF(baseX + 20, baseY));

            RectangleF checkboxBound2 = new RectangleF(baseX + 70, baseY, 15, 15);
            PdfCheckBoxField checkBoxField2 = new PdfCheckBoxField(page, "checkbox2");
            checkBoxField2.Bounds = checkboxBound2;
            checkBoxField2.Checked = false;
            page.Canvas.DrawString("Option 2", font, brush2, new PointF(baseX + 90, baseY));
            doc.Form.Fields.Add(checkBoxField1);
            doc.Form.Fields.Add(checkBoxField2);
            baseY += 25;

            //Add a listbox
            page.Canvas.DrawString("ListBox:", font, brush1, new PointF(10, baseY));
            RectangleF listboxBound = new RectangleF(baseX, baseY, 150, 50);
            PdfListBoxField listBoxField = new PdfListBoxField(page, "listbox");
            listBoxField.Items.Add(new PdfListFieldItem("Item 1", "item1"));
            listBoxField.Items.Add(new PdfListFieldItem("Item 2", "item2"));
            listBoxField.Items.Add(new PdfListFieldItem("Item 3", "item3")); ;
            listBoxField.Bounds = listboxBound;
            listBoxField.Font = font;
            listBoxField.SelectedIndex = 0;
            doc.Form.Fields.Add(listBoxField);
            baseY += 60;

            //Add two radio buttons
            page.Canvas.DrawString("RadioButton:", font, brush1, new PointF(10, baseY));
            PdfRadioButtonListField radioButtonListField = new PdfRadioButtonListField(page, "radio");
            PdfRadioButtonListItem radioItem1 = new PdfRadioButtonListItem("option1");
            RectangleF radioBound1 = new RectangleF(baseX, baseY, 15, 15);
            radioItem1.Bounds = radioBound1;
            page.Canvas.DrawString("Option 1", font, brush2, new PointF(baseX + 20, baseY));

            PdfRadioButtonListItem radioItem2 = new PdfRadioButtonListItem("option2");
            RectangleF radioBound2 = new RectangleF(baseX + 70, baseY, 15, 15);
            radioItem2.Bounds = radioBound2;
            page.Canvas.DrawString("Option 2", font, brush2, new PointF(baseX + 90, baseY));
            radioButtonListField.Items.Add(radioItem1);
            radioButtonListField.Items.Add(radioItem2);
            radioButtonListField.SelectedIndex = 0;
            doc.Form.Fields.Add(radioButtonListField);
            baseY += 25;

            //Add a combobox
            page.Canvas.DrawString("ComboBox:", font, brush1, new PointF(10, baseY));
            RectangleF cmbBounds = new RectangleF(baseX, baseY, 150, 15);
            PdfComboBoxField comboBoxField = new PdfComboBoxField(page, "combobox");
            comboBoxField.Bounds = cmbBounds;
            comboBoxField.Items.Add(new PdfListFieldItem("Item 1", "item1"));
            comboBoxField.Items.Add(new PdfListFieldItem("Item 2", "itme2"));
            comboBoxField.Items.Add(new PdfListFieldItem("Item 3", "item3"));
            comboBoxField.Items.Add(new PdfListFieldItem("Item 4", "item4"));
            comboBoxField.SelectedIndex = 0;
            comboBoxField.Font = font;
            doc.Form.Fields.Add(comboBoxField);
            baseY += 25;

            //Add a signature field
            page.Canvas.DrawString("Signature Field:", font, brush1, new PointF(10, baseY));
            PdfSignatureField sgnField = new PdfSignatureField(page, "sgnField");
            RectangleF sgnBounds = new RectangleF(baseX, baseY, 150, 80);
            sgnField.Bounds = sgnBounds;
            doc.Form.Fields.Add(sgnField);
            baseY += 90;

            //Add a button
            page.Canvas.DrawString("Button:", font, brush1, new PointF(10, baseY));
            RectangleF btnBounds = new RectangleF(baseX, baseY, 50, 15);
            PdfButtonField buttonField = new PdfButtonField(page, "button");
            buttonField.Bounds = btnBounds;
            buttonField.Text = "Submit";
            buttonField.Font = font;
            PdfSubmitAction submitAction = new PdfSubmitAction("https://www.e-iceblue.com/getformvalues.php");
            submitAction.DataFormat = SubmitDataFormat.Html;
            buttonField.Actions.MouseDown = submitAction;
            doc.Form.Fields.Add(buttonField);

            //Save to file
            doc.SaveToFile("FillableForms.pdf", FileFormat.PDF);
        }
    }
}

C#/VB.NET: Create, Fill, or Remove Fillable Forms in PDF

Fill Form Fields in an Existing PDF Document

In order to fill out a form, we must first get all the form fields from the PDF document, determine the type of a certain field, and then input a value or select a value from a predefined list. The following are the steps to fill form fields in an existing PDF document using Spire.PDF for .NET.

Create a PdfDocument object.
Load a sample PDF document using PdfDocument.LoadFromFile() method.
Get the form from the document through PdfDocument.Form property.
Get the form widget collection through PdfFormWidget.FieldsWidget property.
Loop through the form widget collection to get a specific PdfField.
Determine if the PdfField is a certain field type such as text box. If yes, set the text of the text box through PdfTextBoxFieldWidget.Text property.
Repeat the sixth step to fill radio button, check box, combo box, and list box with values.
Save the document to a PDF file using PdfDocument.SaveToFile() method.

C#
VB.NET

using Spire.Pdf;
using Spire.Pdf.Fields;
using Spire.Pdf.Widget;

namespace FillFormFields
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create a PdfDocument object
            PdfDocument doc = new PdfDocument();

            //Load a template containing forms
            doc.LoadFromFile(@"C:\Users\Administrator\Desktop\FormsTemplate.pdf");

            //Get the form from the document
            PdfFormWidget form = (PdfFormWidget)doc.Form;

            //Get the form widget collection
            PdfFormFieldWidgetCollection formWidgetCollection = form.FieldsWidget;

            //Loop through the widgets
            for (int i = 0; i < formWidgetCollection.Count; i++)
            {
                //Get a specific field
                PdfField field = formWidgetCollection[i];

                //Determine if the field is a text box
                if (field is PdfTextBoxFieldWidget)
                {
                    if (field.Name == "name")
                    {
                        //Set the text of text box
                        PdfTextBoxFieldWidget textBoxField = (PdfTextBoxFieldWidget)field;
                        textBoxField.Text = "Kaila Smith";
                    }
                }

                //Determine if the field is a radio button
                if (field is PdfRadioButtonListFieldWidget)
                {
                    if (field.Name == "gender")
                    {
                        //Set the selected index of radio button
                        PdfRadioButtonListFieldWidget radioButtonListField = (PdfRadioButtonListFieldWidget)field;
                        radioButtonListField.SelectedIndex = 1;
                    }
                }

                //Determine if the field is a combo box
                if (field is PdfComboBoxWidgetFieldWidget)
                {
                    if (field.Name == "country")
                    {
                        //Set the selected index of combo box
                        PdfComboBoxWidgetFieldWidget comboBoxField = (PdfComboBoxWidgetFieldWidget)field;
                        int[] index = { 0 };
                        comboBoxField.SelectedIndex = index;
                    }
                }

                //Determine if the field is a check box
                if (field is PdfCheckBoxWidgetFieldWidget)
                {
                    //Set the "Checked" status of check box
                    PdfCheckBoxWidgetFieldWidget checkBoxField = (PdfCheckBoxWidgetFieldWidget)field;
                    switch (checkBoxField.Name)
                    {
                        case "travel":
                            checkBoxField.Checked = true;
                            break;
                        case "movie":
                            checkBoxField.Checked = true;
                            break;
                    }
                }

                //Determine if the field is a list box
                if (field is PdfListBoxWidgetFieldWidget)
                {
                    if (field.Name == "degree")
                    {
                        //Set the selected index of list box
                        PdfListBoxWidgetFieldWidget listBox = (PdfListBoxWidgetFieldWidget)field;
                        int[] index = { 1 };
                        listBox.SelectedIndex = index;
                    }
                }
            }

            //Save to file
            doc.SaveToFile("FillFormFields.pdf", FileFormat.PDF);
        }
    }
}

C#/VB.NET: Create, Fill, or Remove Fillable Forms in PDF

Remove a Particular Field or All Fields from an Existing PDF Document

A form field in a PDF document can be accessed by its index or name and removed by PdfFieldCollection.Remove() method. The following are the steps to remove a particular field or all fields from an existing PDF document using Sprie.PDF for .NET.

Create a PdfDocument object.
Load a PDF document using PdfDocument.LoadFromFile() method.
Get the form widget collection from the document.
Loop through the widget collection to get a specific PdfField. Remove the field one by one using PdfFieldCollection.Remove() method.
To remove a certain form field, get it from the document through PdfFormWidget.FieldsWidget["fieldName"] property and then call the PdfFieldCollectiont.Remove() method.
Save the document to a PDF file using PdfDocument.SaveToFile() method.

C#
VB.NET

using Spire.Pdf;
using Spire.Pdf.Fields;
using Spire.Pdf.Widget;

namespace RemoveFormFields
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create a PdfDocument object
            PdfDocument doc = new PdfDocument();

            //Load a PDF file
            doc.LoadFromFile(@"C:\Users\Administrator\Desktop\FormsTemplate.pdf");

            //Get the form fields from the document
            PdfFormWidget formWidget = doc.Form as PdfFormWidget;

            //Loop through the widgets
            for (int i = formWidget.FieldsWidget.List.Count - 1; i >= 0; i--)
            {
                //Get a specific field
                PdfField field = formWidget.FieldsWidget.List[i] as PdfField;

                //Remove the field
                formWidget.FieldsWidget.Remove(field);
            }

            //Get a specific field by its name
            //PdfField field = formWidget.FieldsWidget["name"];
            //Remove the field
            //formWidget.FieldsWidget.Remove(field);

            //Save to file
            doc.SaveToFile("DeleteAllFields.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.

Published in Form Field

Tagged under

pdf net FormField

PDF Page Lable in Silverlight

2012-02-21 06:35:27 Written by Koohji

Demo
App.xaml
App.xaml.cs
App.xaml.vb
MainPage.xaml
MainPage.xaml.cs
MainPage.xaml.vb

The sample demonstrates how to set PDF Page Label in Silverlight.

<Application xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
             xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" 
             x:Class="PageLabel.App">
             
    <Application.Resources>
        
    </Application.Resources>
</Application>

using System;
using System.Windows;

namespace PageLabel
{
    public partial class App : Application
    {

        public App()
        {
            this.Startup += this.Application_Startup;
            this.Exit += this.Application_Exit;
            this.UnhandledException += this.Application_UnhandledException;

            InitializeComponent();
        }

        private void Application_Startup(object sender, StartupEventArgs e)
        {
            this.RootVisual = new MainPage();
        }

        private void Application_Exit(object sender, EventArgs e)
        {

        }

        private void Application_UnhandledException(object sender, ApplicationUnhandledExceptionEventArgs e)
        {
            // If the app is running outside of the debugger then report the exception using
            // the browser's exception mechanism. On IE this will display it a yellow alert 
            // icon in the status bar and Firefox will display a script error.
            if (!System.Diagnostics.Debugger.IsAttached)
            {

                // NOTE: This will allow the application to continue running after an exception has been thrown
                // but not handled. 
                // For production applications this error handling should be replaced with something that will 
                // report the error to the website and stop the application.
                e.Handled = true;
                Deployment.Current.Dispatcher.BeginInvoke(delegate { ReportErrorToDOM(e); });
            }
        }

        private void ReportErrorToDOM(ApplicationUnhandledExceptionEventArgs e)
        {
            try
            {
                string errorMsg = e.ExceptionObject.Message + e.ExceptionObject.StackTrace;
                errorMsg = errorMsg.Replace('"', '\'').Replace("\r\n", @"\n");

                System.Windows.Browser.HtmlPage.Window.Eval("throw new Error(\"Unhandled Error in Silverlight Application " + errorMsg + "\");");
            }
            catch (Exception)
            {
            }
        }
    }
}

Imports System.Net
Imports System.Windows
Imports System.Windows.Controls
Imports System.Windows.Documents
Imports System.Windows.Input
Imports System.Windows.Media
Imports System.Windows.Media.Animation
Imports System.Windows.Shapes

Namespace PageLabel
	Partial Public Class App
		Inherits Application

		Public Sub New()
			AddHandler Me.Startup, AddressOf Application_Startup
			AddHandler Me.Exit, AddressOf Application_Exit
			AddHandler Me.UnhandledException, AddressOf Application_UnhandledException

			InitializeComponent()
		End Sub

		Private Sub Application_Startup(ByVal sender As Object, ByVal e As StartupEventArgs)
			Me.RootVisual = New MainPage()
		End Sub

		Private Sub Application_Exit(ByVal sender As Object, ByVal e As EventArgs)

		End Sub

		Private Sub Application_UnhandledException(ByVal sender As Object, ByVal e As ApplicationUnhandledExceptionEventArgs)
			' If the app is running outside of the debugger then report the exception using
			' the browser's exception mechanism. On IE this will display it a yellow alert 
			' icon in the status bar and Firefox will display a script error.
			If Not Debugger.IsAttached Then

				' NOTE: This will allow the application to continue running after an exception has been thrown
				' but not handled. 
				' For production applications this error handling should be replaced with something that will 
				' report the error to the website and stop the application.
				e.Handled = True
				Deployment.Current.Dispatcher.BeginInvoke(Sub() ReportErrorToDOM(e))
			End If
		End Sub

		Private Sub ReportErrorToDOM(ByVal e As ApplicationUnhandledExceptionEventArgs)
			Try
				Dim errorMsg As String = e.ExceptionObject.Message + e.ExceptionObject.StackTrace
				errorMsg = errorMsg.Replace(""""c, "'"c).Replace(vbCrLf, vbLf)

				System.Windows.Browser.HtmlPage.Window.Eval("throw new Error(""Unhandled Error in Silverlight Application " & errorMsg & """);")
			Catch e1 As Exception
			End Try
		End Sub
	End Class
End Namespace

<UserControl x:Class="PageLabel.MainPage"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
    xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
    mc:Ignorable="d"
    d:DesignHeight="300" d:DesignWidth="400">

    <Grid x:Name="LayoutRoot" Background="White" Loaded="LayoutRoot_Loaded">
        <Button Content="Run" Height="23" HorizontalAlignment="Left" Margin="288,258,0,0" Name="button1" VerticalAlignment="Top" Width="75" Click="button1_Click" />
    </Grid>
</UserControl>

using System.Windows;
using System.Windows.Controls;
using System.IO;
using System.Reflection;

using Spire.Pdf;
using Spire.Pdf.Graphics;

namespace PageLabel
{
    public partial class MainPage : UserControl
    {
        //create a saveFileDialog to save the PDF file
        private SaveFileDialog saveFileDialog = null;

        //create a pdf document
        private PdfDocument pdfDoc = new PdfDocument();

        private string text = "This is the first page"; 
        public MainPage()
        {
            InitializeComponent();

            //initialize the saveFileDialog
            this.saveFileDialog = new SaveFileDialog();
            this.saveFileDialog.Filter = "PDF Document (*.pdf)|*.pdf";
        }

        private void LayoutRoot_Loaded(object sender, RoutedEventArgs e)
        {
           
        }

        private void button1_Click(object sender, RoutedEventArgs e)
        {
            //create a margin
            PdfMargins margin = new PdfMargins(62f, 50.8f, 62f, 50.8f);

            //add one section to the PDF file
            PdfSection section = this.pdfDoc.Sections.Add();

            //draw the label and text of the first page
            DrawTextandLabel(section, margin);

            ////draw the label and text of the second page
            this.text = "This is the second page";
            DrawTextandLabel(section, margin);

            //draw the label and text of the third page
            this.text = "This is the third page";
            DrawTextandLabel(section, margin);

            //save the PDF file
            bool? result = this.saveFileDialog.ShowDialog();
            if (result.HasValue && result.Value)
            {
                using (Stream stream = this.saveFileDialog.OpenFile())
                {
                    this.pdfDoc.SaveToStream(stream);
                }
            }
        }

        private void DrawTextandLabel(PdfSection section, PdfMargins margin)
        {
            //set the label of the PDF file
            section.PageNumber = new PdfPageNumber();
            section.PageNumber.NumberStyle = PdfNumberStyle.Numeric;
            section.PageNumber.Prefix = "page ";
            section.PageSettings.Size = PdfPageSize.A4;
            section.PageSettings.Margins.All = 0;

            //draw the content 
            PdfPageBase page = section.Pages.Add();
            float x = margin.Left;
            float y = margin.Top + 8;
            float width = page.Canvas.ClientSize.Width - margin.Left - margin.Right;
            PdfFont font1 = new PdfFont(PdfFontFamily.Courier, 16f);
            PdfBrush brush1 = PdfBrushes.Black;
            PdfPen pen1 = new PdfPen(brush1, 0.75f);
            PdfStringFormat format = new PdfStringFormat();
            format.MeasureTrailingSpaces = true;
            page.Canvas.DrawString(this.text, font1, brush1, x, y, format);
        }
    }
}

Imports System.Windows
Imports System.Windows.Controls
Imports System.IO
Imports System.Reflection

Imports Spire.Pdf
Imports Spire.Pdf.Graphics

Namespace PageLabel
	Partial Public Class MainPage
		Inherits UserControl
		'create a saveFileDialog to save the PDF file
		Private saveFileDialog As SaveFileDialog = Nothing

		'create a pdf document
		Private pdfDoc As New PdfDocument()

		Private text As String = "This is the first page"
		Public Sub New()
			InitializeComponent()

			'initialize the saveFileDialog
			Me.saveFileDialog = New SaveFileDialog()
			Me.saveFileDialog.Filter = "PDF Document (*.pdf)|*.pdf"
		End Sub

		Private Sub LayoutRoot_Loaded(ByVal sender As Object, ByVal e As RoutedEventArgs)

		End Sub

		Private Sub button1_Click(ByVal sender As Object, ByVal e As RoutedEventArgs)
			'create a margin
			Dim margin As New PdfMargins(62f, 50.8f, 62f, 50.8f)

			'add one section to the PDF file
			Dim section As PdfSection = Me.pdfDoc.Sections.Add()

			'draw the label and text of the first page
			DrawTextandLabel(section, margin)

			'//draw the label and text of the second page
			Me.text = "This is the second page"
			DrawTextandLabel(section, margin)

			'draw the label and text of the third page
			Me.text = "This is the third page"
			DrawTextandLabel(section, margin)

			'save the PDF file
			Dim result? As Boolean = Me.saveFileDialog.ShowDialog()
			If result.HasValue AndAlso result.Value Then
				Using stream As Stream = Me.saveFileDialog.OpenFile()
					Me.pdfDoc.SaveToStream(stream)
				End Using
			End If
		End Sub

		Private Sub DrawTextandLabel(ByVal section As PdfSection, ByVal margin As PdfMargins)
			'set the label of the PDF file
			section.PageNumber = New PdfPageNumber()
			section.PageNumber.NumberStyle = PdfNumberStyle.Numeric
			section.PageNumber.Prefix = "page "
			section.PageSettings.Size = PdfPageSize.A4
			section.PageSettings.Margins.All = 0

			'draw the content 
			Dim page As PdfPageBase = section.Pages.Add()
			Dim x As Single = margin.Left
			Dim y As Single = margin.Top + 8
			Dim width As Single = page.Canvas.ClientSize.Width - margin.Left - margin.Right
			Dim font1 As New PdfFont(PdfFontFamily.Courier, 16f)
			Dim brush1 As PdfBrush = PdfBrushes.Black
			Dim pen1 As New PdfPen(brush1, 0.75f)
			Dim format As New PdfStringFormat()
			format.MeasureTrailingSpaces = True
			page.Canvas.DrawString(Me.text, font1, brush1, x, y, format)
		End Sub
	End Class
End Namespace

Published in Page

Tagged under

Insert Image into Word in Silverlight

2012-02-21 06:26:23 Written by Koohji

Demo
App.xaml
App.xaml.cs
App.xaml.vb
MainPage.xaml
MainPage.xaml.cs
MainPage.xaml.vb

The sample demonstrates how to Insert Image into Word in Silverlight.

<pplication xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
             xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" 
             x:Class="doctest.App">
             
    <Application.Resources>
        
    </Application.Resources>
</Application>

using System;
using System.Windows;

namespace doctest
{
    public partial class App : Application
    {

        public App()
        {
            this.Startup += this.Application_Startup;
            this.Exit += this.Application_Exit;
            this.UnhandledException += this.Application_UnhandledException;

            InitializeComponent();
        }

        private void Application_Startup(object sender, StartupEventArgs e)
        {
            this.RootVisual = new MainPage();
        }

        private void Application_Exit(object sender, EventArgs e)
        {

        }

        private void Application_UnhandledException(object sender, ApplicationUnhandledExceptionEventArgs e)
        {
            // If the app is running outside of the debugger then report the exception using
            // the browser's exception mechanism. On IE this will display it a yellow alert 
            // icon in the status bar and Firefox will display a script error.
            if (!System.Diagnostics.Debugger.IsAttached)
            {

                // NOTE: This will allow the application to continue running after an exception has been thrown
                // but not handled. 
                // For production applications this error handling should be replaced with something that will 
                // report the error to the website and stop the application.
                e.Handled = true;
                Deployment.Current.Dispatcher.BeginInvoke(delegate { ReportErrorToDOM(e); });
            }
        }

        private void ReportErrorToDOM(ApplicationUnhandledExceptionEventArgs e)
        {
            try
            {
                string errorMsg = e.ExceptionObject.Message + e.ExceptionObject.StackTrace;
                errorMsg = errorMsg.Replace('"', '\'').Replace("\r\n", @"\n");

                System.Windows.Browser.HtmlPage.Window.Eval("throw new Error(\"Unhandled Error in Silverlight Application " + errorMsg + "\");");
            }
            catch (Exception)
            {
            }
        }
    }
}

Imports System.Windows

Namespace doctest
	Partial Public Class App
		Inherits Application

		Public Sub New()
			AddHandler Me.Startup, AddressOf Application_Startup
			AddHandler Me.Exit, AddressOf Application_Exit
			AddHandler Me.UnhandledException, AddressOf Application_UnhandledException

			InitializeComponent()
		End Sub

		Private Sub Application_Startup(ByVal sender As Object, ByVal e As StartupEventArgs)
			Me.RootVisual = New MainPage()
		End Sub

		Private Sub Application_Exit(ByVal sender As Object, ByVal e As EventArgs)

		End Sub

		Private Sub Application_UnhandledException(ByVal sender As Object, ByVal e As ApplicationUnhandledExceptionEventArgs)
			' If the app is running outside of the debugger then report the exception using
			' the browser's exception mechanism. On IE this will display it a yellow alert 
			' icon in the status bar and Firefox will display a script error.
			If Not Debugger.IsAttached Then

				' NOTE: This will allow the application to continue running after an exception has been thrown
				' but not handled. 
				' For production applications this error handling should be replaced with something that will 
				' report the error to the website and stop the application.
				e.Handled = True
				Deployment.Current.Dispatcher.BeginInvoke(Sub() ReportErrorToDOM(e))
			End If
		End Sub

		Private Sub ReportErrorToDOM(ByVal e As ApplicationUnhandledExceptionEventArgs)
			Try
				Dim errorMsg As String = e.ExceptionObject.Message + e.ExceptionObject.StackTrace
				errorMsg = errorMsg.Replace(""""c, "'"c).Replace(vbCrLf, vbLf)

				System.Windows.Browser.HtmlPage.Window.Eval("throw new Error(""Unhandled Error in Silverlight Application " & errorMsg & """);")
			Catch e1 As Exception
			End Try
		End Sub
	End Class
End Namespace

<UserControl x:Class="doctest.MainPage"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
    xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
    mc:Ignorable="d"
    d:DesignHeight="300" d:DesignWidth="400">

    <Grid x:Name="LayoutRoot" Background="White" Loaded="LayoutRoot_Loaded">
        <Button Content="Button" Height="23" HorizontalAlignment="Left" Margin="296,244,0,0" Name="button1" VerticalAlignment="Top" Width="75" Click="button1_Click" />
    </Grid>
</UserControl>

using System;
using System.Windows;
using System.Windows.Controls;
using System.IO;
using System.Reflection;

using Spire.Doc;
using Spire.Doc.Documents;

namespace doctest
{
    public partial class MainPage : UserControl
    {
        private SaveFileDialog saveFileDialog = null;

        public MainPage()
        {
            InitializeComponent();
            this.saveFileDialog = new SaveFileDialog();
            this.saveFileDialog.Filter = "Word Documents(*.doc)|*.doc";
        }

        private void LayoutRoot_Loaded(object sender, RoutedEventArgs e)
        {

        }

        private void button1_Click(object sender, RoutedEventArgs e)
        {
            //load the doc template
            Assembly assembly = this.GetType().Assembly;
            Document doc = new Document();
            foreach (string name in assembly.GetManifestResourceNames())
            {
                if (name.EndsWith("test.doc"))
                {
                    using (Stream fileStr = assembly.GetManifestResourceStream(name))
                    {
                        doc.LoadFromStream(fileStr, FileFormat.Doc);
                    }
                }
            }

            //get the second paragraph of the first section in doc
            Section section = doc.Sections[0];
            Paragraph paragraph = section.Paragraphs[2];

            //get the picture
            Stream imageStr = Application.GetResourceStream(new Uri("/doctest;component/sunset.jpg", UriKind.Relative)).Stream;

            //insert the picture
            paragraph.AppendPicture(imageStr);

            //save the doc template
            bool? result = this.saveFileDialog.ShowDialog();
            if (result.HasValue && result.Value)
            {
                using (Stream str = this.saveFileDialog.OpenFile())
                {
                    doc.SaveToStream(str, FileFormat.Doc);
                }
            }
        }
    }
}

Imports System.Windows
Imports System.Windows.Controls
Imports System.IO
Imports System.Reflection

Imports Spire.Doc
Imports Spire.Doc.Documents

Namespace doctest
	Partial Public Class MainPage
		Inherits UserControl
		Private saveFileDialog As SaveFileDialog = Nothing

		Public Sub New()
			InitializeComponent()
			Me.saveFileDialog = New SaveFileDialog()
			Me.saveFileDialog.Filter = "Word Documents(*.doc)|*.doc"
		End Sub

		Private Sub LayoutRoot_Loaded(ByVal sender As Object, ByVal e As RoutedEventArgs)

		End Sub

		Private Sub button1_Click(ByVal sender As Object, ByVal e As RoutedEventArgs)
			'load the doc template
			Dim [assembly] As System.Reflection.Assembly = Me.GetType().Assembly
			Dim doc As New Document()
			For Each name As String In [assembly].GetManifestResourceNames()
				If name.EndsWith("test.doc") Then
					Using fileStr As Stream = [assembly].GetManifestResourceStream(name)
						doc.LoadFromStream(fileStr, FileFormat.Doc)
					End Using
				End If
			Next name

			'get the second paragraph of the first section in doc
			Dim section As Section = doc.Sections(0)
			Dim paragraph As Paragraph = section.Paragraphs(2)

			'get the picture
			Dim imageStr As Stream = Application.GetResourceStream(New Uri("/doctest;component/sunset.jpg", UriKind.Relative)).Stream

			'insert the picture
			paragraph.AppendPicture(imageStr)

			'save the doc template
			Dim result? As Boolean = Me.saveFileDialog.ShowDialog()
			If result.HasValue AndAlso result.Value Then
				Using str As Stream = Me.saveFileDialog.OpenFile()
					doc.SaveToStream(str, FileFormat.Doc)
				End Using
			End If
		End Sub
	End Class
End Namespace

Published in Context

Tagged under

Demo
App.xaml
App.xaml.cs
App.xaml.vb
MainPage.xaml
MainPage.xaml.cs
MainPage.xaml.vb

The sample demonstrates how to Design Excel Cell Borders in Silverlight via Spire.XLS.

<Application xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
             xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" 
             x:Class="Border_xls.App">
             
    <Application.Resources>
        
    </Application.Resources>
</Application>

using System;
using System.Windows;

namespace Border_xls
{
    public partial class App : Application
    {

        public App()
        {
            this.Startup += this.Application_Startup;
            this.Exit += this.Application_Exit;
            this.UnhandledException += this.Application_UnhandledException;

            InitializeComponent();
        }

        private void Application_Startup(object sender, StartupEventArgs e)
        {
            this.RootVisual = new MainPage();
        }

        private void Application_Exit(object sender, EventArgs e)
        {

        }

        private void Application_UnhandledException(object sender, ApplicationUnhandledExceptionEventArgs e)
        {
            // If the app is running outside of the debugger then report the exception using
            // the browser's exception mechanism. On IE this will display it a yellow alert 
            // icon in the status bar and Firefox will display a script error.
            if (!System.Diagnostics.Debugger.IsAttached)
            {

                // NOTE: This will allow the application to continue running after an exception has been thrown
                // but not handled. 
                // For production applications this error handling should be replaced with something that will 
                // report the error to the website and stop the application.
                e.Handled = true;
                Deployment.Current.Dispatcher.BeginInvoke(delegate { ReportErrorToDOM(e); });
            }
        }

        private void ReportErrorToDOM(ApplicationUnhandledExceptionEventArgs e)
        {
            try
            {
                string errorMsg = e.ExceptionObject.Message + e.ExceptionObject.StackTrace;
                errorMsg = errorMsg.Replace('"', '\'').Replace("\r\n", @"\n");

                System.Windows.Browser.HtmlPage.Window.Eval("throw new Error(\"Unhandled Error in Silverlight Application " + errorMsg + "\");");
            }
            catch (Exception)
            {
            }
        }
    }
}

Imports System.Windows

Namespace Border_xls
	Partial Public Class App
		Inherits Application

		Public Sub New()
			AddHandler Me.Startup, AddressOf Application_Startup
			AddHandler Me.Exit, AddressOf Application_Exit
			AddHandler Me.UnhandledException, AddressOf Application_UnhandledException

			InitializeComponent()
		End Sub

		Private Sub Application_Startup(ByVal sender As Object, ByVal e As StartupEventArgs)
			Me.RootVisual = New MainPage()
		End Sub

		Private Sub Application_Exit(ByVal sender As Object, ByVal e As EventArgs)

		End Sub

		Private Sub Application_UnhandledException(ByVal sender As Object, ByVal e As ApplicationUnhandledExceptionEventArgs)
			' If the app is running outside of the debugger then report the exception using
			' the browser's exception mechanism. On IE this will display it a yellow alert 
			' icon in the status bar and Firefox will display a script error.
			If Not Debugger.IsAttached Then

				' NOTE: This will allow the application to continue running after an exception has been thrown
				' but not handled. 
				' For production applications this error handling should be replaced with something that will 
				' report the error to the website and stop the application.
				e.Handled = True
				Deployment.Current.Dispatcher.BeginInvoke(Sub() ReportErrorToDOM(e))
			End If
		End Sub

		Private Sub ReportErrorToDOM(ByVal e As ApplicationUnhandledExceptionEventArgs)
			Try
				Dim errorMsg As String = e.ExceptionObject.Message + e.ExceptionObject.StackTrace
				errorMsg = errorMsg.Replace(""""c, "'"c).Replace(vbCrLf, vbLf)

				System.Windows.Browser.HtmlPage.Window.Eval("throw new Error(""Unhandled Error in Silverlight Application " & errorMsg & """);")
			Catch e1 As Exception
			End Try
		End Sub
	End Class
End Namespace

<UserControl x:Class="Border_xls.MainPage"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
    xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
    mc:Ignorable="d"
    d:DesignHeight="300" d:DesignWidth="400" Loaded="UserControl_Loaded">

    <Grid x:Name="LayoutRoot" Background="White">
        <Button Content="Button" Height="23" HorizontalAlignment="Left" Margin="241,247,0,0" Name="button1" VerticalAlignment="Top" Width="75" Click="button1_Click" />
    </Grid>
</UserControl>

using System.Windows;
using System.Windows.Controls;
using System.Windows.Media;
using System.IO;
using System.Reflection;

using Spire.Xls;

namespace Border_xls
{
    public partial class MainPage : UserControl
    {
        private SaveFileDialog saveFiledialog = null;
        private Workbook workbook = new Workbook();
        public MainPage()
        {
            InitializeComponent();
            this.saveFiledialog = new SaveFileDialog();
            this.saveFiledialog.Filter = "Excel Document(*.xls)|*.xls";
        }

        private void UserControl_Loaded(object sender, RoutedEventArgs e)
        {
            //load the xls template
            Assembly assembly = this.GetType().Assembly;
            foreach (string name in assembly.GetManifestResourceNames())
            {
                if(name.EndsWith("data.xls"))
                {
                    using(Stream fileStr=assembly.GetManifestResourceStream(name))
                    {
                        this.workbook.LoadFromStream(fileStr);
                    }
                }
            }
        }

        private void button1_Click(object sender, RoutedEventArgs e)
        {
            //get the first worksheet of the workbook
            Worksheet worksheet = this.workbook.Worksheets[0];

            //set the border of the first three rows
            worksheet.Range["A1:F3"].Style.Borders.Color = Color.FromArgb(255, 255,0, 0);
            worksheet.Range["A1:F3"].Style.Borders.LineStyle = LineStyleType.Thin;
            worksheet.Range["A1:F3"].Style.Borders[BordersLineType.DiagonalDown].LineStyle = LineStyleType.None;
            worksheet.Range["A1:F3"].Style.Borders[BordersLineType.DiagonalUp].LineStyle = LineStyleType.None;

            //set the border of the fourth,fifth,sixth and seventh rows
            worksheet.Range["A4:F7"].Style.Borders.Color = Color.FromArgb(255, 0, 0, 255);
            worksheet.Range["A4:F7"].Style.Borders.LineStyle = LineStyleType.Double;
            worksheet.Range["A4:F7"].Style.Borders[BordersLineType.DiagonalDown].LineStyle = LineStyleType.None;
            worksheet.Range["A4:F7"].Style.Borders[BordersLineType.DiagonalUp].LineStyle = LineStyleType.None;

            //set the border of other rows
            worksheet.Range["A8:F19"].Style.Borders.Color = Color.FromArgb(255, 0, 0, 0);
            worksheet.Range["A8:F19"].Style.Borders.LineStyle = LineStyleType.Medium;
            worksheet.Range["A8:F19"].Style.Borders[BordersLineType.DiagonalDown].LineStyle = LineStyleType.None;
            worksheet.Range["A8:F19"].Style.Borders[BordersLineType.DiagonalUp].LineStyle = LineStyleType.None;

            //save the workbook
            bool? result = this.saveFiledialog.ShowDialog();
            if (result.HasValue && result.Value)
            {
                using (Stream stream = this.saveFiledialog.OpenFile())
                {
                    this.workbook.SaveToStream(stream);
                }
            }
        }
    }
}

Imports System.Windows
Imports System.Windows.Controls
Imports System.Windows.Media
Imports System.IO
Imports System.Reflection

Imports Spire.Xls

Namespace Border_xls
	Partial Public Class MainPage
		Inherits UserControl
		Private saveFiledialog As SaveFileDialog = Nothing
		Private workbook As New Workbook()
		Public Sub New()
			InitializeComponent()
			Me.saveFiledialog = New SaveFileDialog()
			Me.saveFiledialog.Filter = "Excel Document(*.xls)|*.xls"
		End Sub

		Private Sub UserControl_Loaded(ByVal sender As Object, ByVal e As RoutedEventArgs)
			'load the xls template
			Dim [assembly] As System.Reflection.Assembly = Me.GetType().Assembly
			For Each name As String In [assembly].GetManifestResourceNames()
				If name.EndsWith("data.xls") Then
					Using fileStr As Stream=[assembly].GetManifestResourceStream(name)
						Me.workbook.LoadFromStream(fileStr)
					End Using
				End If
			Next name
		End Sub

		Private Sub button1_Click(ByVal sender As Object, ByVal e As RoutedEventArgs)
			'get the first worksheet of the workbook
			Dim worksheet As Worksheet = Me.workbook.Worksheets(0)

			'set the border of the first three rows
			worksheet.Range("A1:F3").Style.Borders.Color = Color.FromArgb(255, 255,0, 0)
			worksheet.Range("A1:F3").Style.Borders.LineStyle = LineStyleType.Thin
			worksheet.Range("A1:F3").Style.Borders(BordersLineType.DiagonalDown).LineStyle = LineStyleType.None
			worksheet.Range("A1:F3").Style.Borders(BordersLineType.DiagonalUp).LineStyle = LineStyleType.None

			'set the border of the fourth,fifth,sixth and seventh rows
			worksheet.Range("A4:F7").Style.Borders.Color = Color.FromArgb(255, 0, 0, 255)
			worksheet.Range("A4:F7").Style.Borders.LineStyle = LineStyleType.Double
			worksheet.Range("A4:F7").Style.Borders(BordersLineType.DiagonalDown).LineStyle = LineStyleType.None
			worksheet.Range("A4:F7").Style.Borders(BordersLineType.DiagonalUp).LineStyle = LineStyleType.None

			'set the border of other rows
			worksheet.Range("A8:F19").Style.Borders.Color = Color.FromArgb(255, 0, 0, 0)
			worksheet.Range("A8:F19").Style.Borders.LineStyle = LineStyleType.Medium
			worksheet.Range("A8:F19").Style.Borders(BordersLineType.DiagonalDown).LineStyle = LineStyleType.None
			worksheet.Range("A8:F19").Style.Borders(BordersLineType.DiagonalUp).LineStyle = LineStyleType.None

			'save the workbook
			Dim result? As Boolean = Me.saveFiledialog.ShowDialog()
			If result.HasValue AndAlso result.Value Then
				Using stream As Stream = Me.saveFiledialog.OpenFile()
					Me.workbook.SaveToStream(stream)
				End Using
			End If
		End Sub
	End Class
End Namespace

Published in Misc

Tagged under

News Category

.NET (1317)

Children categories

Spire.XLS for .NET (383)

Spire.Doc for .NET (337)

Spire.DataExport for .NET (33)

Spire.PDF for .NET (290)

Spire.PDFViewer for .NET (19)

Spire.Barcode for .NET (16)

Spire.DocViewer for .NET (8)

Spire.Presentation for .NET (204)

Spire.Spreadsheet for .NET (1)

Spire.Email for .NET (19)

Spire.OCR for .NET (5)

Spire.PDFViewer for MAUI (1)

How to Set Word Table Column Width

PDF Overlay in Silverlight

Copy Excel Worksheet in Silverlight

Word Hyperlink in Silverlight

C#/VB.NET: Rename Excel Sheets and Set Tab Colors

Install Spire.XLS for.NET

Rename Excel Sheets and Set Tab Colors

Apply for a Temporary License

Export PDF Document to images

C#/VB.NET: Create, Fill, or Remove Fillable Forms in PDF

Install Spire.PDF for .NET

Create Fillable Form Fields in a PDF Document

Fill Form Fields in an Existing PDF Document

Remove a Particular Field or All Fields from an Existing PDF Document

Apply for a Temporary License

PDF Page Lable in Silverlight

Insert Image into Word in Silverlight

Design Excel Cell Borders in Silverlight

More...

PDF Header and Footer in Silverlight

Paginate PDF File in C#/VB.NET

C#/VB.NET: Add Background Color or Background Image to PDF

Word Footer in Silverlight