.NET (1323)
Children categories
When sharing Excel files with other people or sending files out of your organization, you may want to protect sensitive data from being changed, moved, or deleted. The easiest way to prevent accidental or deliberate changes in the contents is to restrict editing on a worksheet or password protect an entire workbook. In this article, you will learn how to protect and unprotect a workbook or a worksheet in C# and VB.NET using Spire.XLS for .NET.
- Password Protect an Entire Workbook
- Protect a Worksheet with a Specific Protection Type
- Allow Users to Edit Ranges in a Protected Worksheet
- Lock Specific Cells in a Worksheet
- Unprotect a Password Protected Worksheet
- Remove or Reset Password of an Encrypted Workbook
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.
PM> Install-Package Spire.XLS
Password Protect an Entire Workbook in C# and VB.NET
By encrypting an Excel document with a password, you ensure that only you and authorized individuals can read or edit it. The following are the steps to password protect a workbook using Spire.XLS for .NET.
- Create a Workbook object.
- Load an Excel file using Workbook.LoadFromFile() method.
- Protect the workbook using a password using Workbook.Protect() method.
- Save the workbook to another Excel file using Workbook.SaveToFile() method.
- C#
- VB.NET
using Spire.Xls;
namespace PasswordProtectWorkbook
{
class Program
{
static void Main(string[] args)
{
//Create a Workbook object
Workbook workbook = new Workbook();
//Load an Excel file
workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\sample.xlsx");
//Protect workbook with a password
workbook.Protect("psd-123");
//Save the workbook to another Excel file
workbook.SaveToFile("Encrypted.xlsx", ExcelVersion.Version2016);
}
}
}
Protect a Worksheet with a Specific Protection Type in C# and VB.NET
If you wish to grant people permission to read your Excel document but restrict the types of modifications they are allowed to make on a worksheet, you can protect the worksheet with a specific protection type. The table below lists a variety of pre-defined protection types under the SheetProtectionType enumeration.
| Protection Type | Allow users to |
| Content | Modify or insert content. |
| DeletingColumns | Delete columns. |
| DeletingRows | Delete rows. |
| Filtering | Set filters. |
| FormattingCells | Format cells. |
| FormattingColumns | Format columns. |
| FormattingRows | Format rows. |
| InsertingColumns | Insert columns. |
| InsertingRows | Insert rows. |
| InsertingHyperlinks | Insert hyperlinks . |
| LockedCells | Select locked cells. |
| UnlockedCells | Select unlocked cells. |
| Objects | Modify drawing objects. |
| Scenarios | Modify saved scenarios. |
| Sorting | Sort data. |
| UsingPivotTables | Use pivot table and pivot chart. |
| All | Do any operations listed above on the protected worksheet. |
| None | Do nothing on the protected worksheet. |
The following are the steps to protect a worksheet with a specific protection type using Spire.XLS for .NET.
- Create a Workbook object.
- Load an Excel file using Workbook.LoadFromFile() method.
- Get a specific worksheet through Workbook.Worksheets[index] property.
- Protect the worksheet with a protection type using Worksheet.Protect(string password, SheetProtectionType options) method.
- Save the workbook to another Excel file using Workbook.SaveToFile() method.
- C#
- VB.NET
using Spire.Xls;
namespace ProtectWorksheetWithSpecificProtectionType
{
class Program
{
static void Main(string[] args)
{
//Create a Workbook object
Workbook workbook = new Workbook();
//Load an Excel file
workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\sample.xlsx");
//Get a specific worksheet
Worksheet worksheet = workbook.Worksheets[0];
//Protect the worksheet with the permission password and the specific protect type
worksheet.Protect("psd-permission", SheetProtectionType.None);
//Save the workbook to another Excel file
workbook.SaveToFile("ProtectWorksheet.xlsx", ExcelVersion.Version2016);
}
}
}
Allow Users to Edit Ranges in a Protected Worksheet in C# and VB.NET
In certain cases, you may need to allow users to be able to edit selected ranges in a protected worksheet. The following steps demonstrate how to.
- Create a Workbook object.
- Load an Excel file using Workbook.LoadFromFile() method.
- Get a specific worksheet through Workbook.Worksheets[index] property.
- Specify editable cell ranges using Worksheet.AddAllowEditRange() method.
- Protect the worksheet with a protection type using Worksheet.Protect(string password, SheetProtectionType options) method.
- Save the workbook to another Excel file using Workbook.SaveToFile() method.
- C#
- VB.NET
using Spire.Xls;
namespace AllowEditRanges
{
class Program
{
static void Main(string[] args)
{
//Create a Workbook object
Workbook workbook = new Workbook();
//Load an Excel file
workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\sample.xlsx");
//Get the first worksheet
Worksheet sheet = workbook.Worksheets[0];
//Add ranges that allow editing
sheet.AddAllowEditRange("Range One", sheet.Range["A5:A6"]);
sheet.AddAllowEditRange("Range Two", sheet.Range["A8:B11"]);
//Protect the worksheet with a password and a protection type
sheet.Protect("psd-permission", SheetProtectionType.All);
//Save the workbook to another Excel file
workbook.SaveToFile("AllowEditRange.xlsx", ExcelVersion.Version2016);
}
}
}
Unprotect a Password Protected Worksheet in C# and VB.NET
To remove the protection of a password-protected worksheet, invoke the Worksheet.Unprotect() method and pass in the original password as a parameter. The detailed steps are as follows.
- Create a Workbook object.
- Load an Excel file using Workbook.LoadFromFile() method.
- Get a specific worksheet through Workbook.Worksheets[index] property.
- Remove the protection using Worksheet.Unprotect(string password) method.
- Save the workbook to another Excel file using Workbook.SaveToFile() method.
- C#
- VB.NET
using Spire.Xls;
namespace UnprotectWorksheet
{
class Program
{
static void Main(string[] args)
{
//Create a Workbook object
Workbook workbook = new Workbook();
//Load an Excel file containing protected worksheet
workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\ProtectedWorksheet.xlsx");
//Get the first worksheet
Worksheet sheet = workbook.Worksheets[0];
//Unprotect the worksheet using the specified password
sheet.Unprotect("psd-permission");
//Save the workbook to anther Excel file
workbook.SaveToFile("UnprotectWorksheet.xlsx", ExcelVersion.Version2016);
}
}
}
Remove or Reset Password of an Encrypted Workbook in C# and VB.NET
To remove or reset password of an encrypted workbook, you can use the Workbook.Unprotect() method and the Workbook.Protect() method, respectively. The following steps show you how to load an encrypted Excel document and delete or change the password of it.
- Create a Workbook object.
- Specify the open password through Workbook.OpenPassword property.
- Load the encrypted Excel file using Workbook.LoadFromFile() method.
- Remove the encryption using Workbook.Unprotect() method. Or change the password using Workbook.Protect() method.
- Save the workbook to another Excel file using Workbook.SaveToFile() method.
- C#
- VB.NET
using Spire.Xls;
namespace RemoveOrResetPassword
{
class Program
{
static void Main(string[] args)
{
//Create a Workbook object
Workbook workbook = new Workbook();
//Specify the open password
workbook.OpenPassword = "psd-123";
//Load an encrypted Excel file
workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\Encrypted.xlsx");
//Unprotect workbook
workbook.UnProtect();
//Reset password
//workbook.Protect("newpassword");
//Save the workbook to another Excel file
workbook.SaveToFile("Unprotect.xlsx", ExcelVersion.Version2016);
}
}
}
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.
The most important reason that people lock worksheet when perform tasks in Excel is to protect the original Excel file from editing or modifying by other people. Through Microsoft Excel, you can set the entire Excel worksheet by setting its property as Read Only or just set partial region area cells as Read Only via protecting worksheet. While how to lock worksheet with C#, VB.NET will be the core topic in this section.
Spire.XLS for .NET, as a fast and reliable excel component, enables you to lock your worksheet by setting Worksheet class property: Worksheet.Range.Style.Locked = true. By this component, you can lock any worksheet that you need. In this solution, worksheet one and worksheet two are locked as you view in below picture:
Now, before the detail code, you have to add Spire.Xls dll by download Spire.XLS for .NET.
using Spire.Xls;
namespace lock_excel_worksheet
{
class Program
{
static void Main(string[] args)
{
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"..\lock worksheet.xls");
workbook.Worksheets[0].Range.Style.Locked = true;
workbook.Worksheets[1].Range.Style.Locked = true;
workbook.Worksheets[0].Protect("", SheetProtectionType.All);
workbook.Worksheets[1].Protect("", SheetProtectionType.All);
workbook.SaveToFile("result.xls",ExcelVersion.Version97to2003);
}
}
}
Imports Spire.Xls
Namespace lock_excel_worksheet
Class Program
Private Shared Sub Main(ByVal args() As String)
Dim workbook As Workbook = New Workbook
workbook.LoadFromFile("..\lock worksheet.xls")
workbook.Worksheets(0).Range.Style.Locked = true
workbook.Worksheets(1).Range.Style.Locked = true
workbook.Worksheets(0).Protect("", SheetProtectionType.All)
workbook.Worksheets(1).Protect("", SheetProtectionType.All)
workbook.SaveToFile("result.xls",ExcelVersion.Version97to2003)
End Sub
End Class
End Namespace
Spire.XLS allows user to operate Excel document directly such as save to stream, save as web response, copy, lock/unlock worksheet, set up workbook properties, etc. As a professional .NET/Silverlight Excel component, it owns the ability of inserting content into Excel document, formatting cells and converting Excel documents to popular office file formats. Spire.XLS for .NET supports Excel 97-2003, Excel 2007 and Excel 2010.
Why Export Listview to CSV?
CSV file (Comma Separated Values, sometimes also called Comma Delimited) is a specially formatted plain text file which stores spreadsheet or basic database-style information in a very simple format, with one record on each line, and each field within that record separated by a comma. It is often used to exchange data between disparate applications. CSV has become a pseudo standard throughout the industry, even among non-Microsoft platforms because it is used in Microsoft Excel.
CSV files are often used as a simple way to transfer a large volume of spreadsheet or database information between programs, without worrying about special file types. For example, transferring a home-made address book from Excel into a database program such as Filemaker Pro could be done by exporting the file as a CSV from Excel, then importing that CSV into File maker.
How to Export Listview to CSV?
Spire.DataExport for .NET presents an easy solution for exporting Listvie to CSV. Spire.DataExport is a 100% pure .NET component suit for exporting data into MS Excel, MS Word, HTML, XML, PDF, MS Access, DBF, SQL Script, SYLK, DIF, CSV ,MS Clipboard format. Quickly and easily export data from Command, ListView, DataTable components. Save you much time and money by using Spire.DataExport.
Download Spire.DataExport (or Spire.Office) with .NET framework 2.0 (or above) together and use the code below to Export Listview to CSV:
this.txtExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
this.txtExport1.DataFormats.CultureName = "en-us";
this.txtExport1.DataFormats.Currency = "c";
this.txtExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
this.txtExport1.DataFormats.Float = "g";
this.txtExport1.DataFormats.Integer = "g";
this.txtExport1.DataFormats.Time = "H:mm";
this.txtExport1.DataEncoding = Spire.DataExport.Common.EncodingType.ASCII;
this.txtExport1.DataSource = ExportSource.ListView;
this.txtExport1.ListView = this.ListView1
txtExport1.ExportType = TextExportType.CSV;
txtExport1.FileName = "sample.csv";
txtExport1.SaveToFile();
Me.txtExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView
Me.txtExport1.DataFormats.CultureName = "en-us"
Me.txtExport1.DataFormats.Currency = "c"
Me.txtExport1.DataFormats.DateTime = "yyyy-M-d H:mm"
Me.txtExport1.DataFormats.Float = "g"
Me.txtExport1.DataFormats.Integer = "g"
Me.txtExport1.DataFormats.Time = "H:mm"
Me.txtExport1.DataEncoding = Spire.DataExport.Common.EncodingType.ASCII
Me.txtExport1.DataSource = Common.ExportSource.ListView
Me.txtExport1.ListView = Me.ListView1
txtExport1.ExportType = TextExportType.CSV
txtExport1.FileName = "sample.csv"
txtExport1.SaveToFile()
Why Export Listview to Office OpenXML?
Office OpenXML has its own advantages. Office OpenXML, or Extensible Markup Language is a set of rules for encoding documents in machine-readable form. The real power of Office OpenXML comes from the fact that with Office OpenXML, not only can you define your own set of tags, but the rules specified by those tags need not be limited to formatting rules. And the most benefit of Office OpenXML is that because you are writing your own markup language, you are not restricted to a limited set of tags defined by proprietary vendors. Furthermore, Office OpenXML allows you to define all sorts of tags with all sorts of rules, such as tags representing business rules or tags representing data description or data relationships.
How to Export Listview to Office OpenXML?
As a professional and powerful .NET component suit for data exporting, Spire.DataExport for .NET can export data from Database to MS Excel,MS Word, HTML, Office OpenXML, PDF, MS Access, DBF, SQL Script, SYLK, DIF, CSV ,MS Clipboard format and of course enable to export ListView to Office OpenXML.
Spire.DataExport for .NET offers an easy solution on Exporting listview to Office OpenXML. Download Spire.DataExport (or Spire.Office) with .NET framework 2.0 (or above) together and use the code below to Export Listview to Office OpenXML:
this.xmlExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
this.xmlExport1.DataFormats.CultureName = "zh-CN";
this.xmlExport1.DataFormats.Currency = "c";
this.xmlExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
this.xmlExport1.DataFormats.Float = "g";
this.xmlExport1.DataFormats.Integer = "g";
this.xmlExport1.DataFormats.Time = "H:mm";
this.xmlExport1.FileName = "sample.xml";
this.xmlExport1.DataSource = Common.ExportSource.ListView;
this.xmlExport1.ListView = this.listView1;
oleDbConnection1.Open();
try{
xmlExport1.SaveToFile();
}
Finally
{
oleDbConnection1.Close();
}
Me.xmlExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView
Me.xmlExport1.DataFormats.CultureName = "zh-CN"
Me.xmlExport1.DataFormats.Currency = "c"
Me.xmlExport1.DataFormats.DateTime = "yyyy-M-d H:mm"
Me.xmlExport1.DataFormats.Float = "g"
Me.xmlExport1.DataFormats.Integer = "g"
Me.xmlExport1.DataFormats.Time = "H:mm"
Me.xmlExport1.FileName = "sample.xml"
Me.xmlExport1.DataSource = Common.ExportSource.ListView
Me.xmlExport1.ListView = Me.listView1
oleDbConnection1.Open()
Try
xmlExport1.SaveToFile()
Finally
Me.oleDbConnection1.Close()
End Try
Why Export Listview to RTF?
RTF (Rich Text Format) is one of three core file formats which Microsoft supports natively along with DOC and DOCX. It's a cross-platform file extension supported by almost all word processors regardless of operating system. RTF word processing files are typically smaller, safer and can be used across a variety of operating systems. Main advantages of RTF:
- File Transparency
- No Risk of Viruses
- Smaller File Size for Text Documents
How to Export Listview to RTF?
Spire.DataExport for .NET as a professional .NET component suit for data exporting can easily help to export Listview to RTF. Download Spire.DataExport (or Spire.Office) with .NET framework 2.0 (or above) together and use the code below to Export Listview to RTF:
this.rtfExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
this.rtfExport1.DataFormats.CultureName = "en-us";
this.rtfExport1.DataFormats.Currency = "c";
this.rtfExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
this.rtfExport1.DataFormats.Float = "g";
this.rtfExport1.DataFormats.Integer = "g";
this.rtfExport1.DataFormats.Time = "H:mm";
this.rtfExport1.FileName = "sample.doc";
this.rtfExport1.RTFOptions.DataStyle.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World);
this.rtfExport1.RTFOptions.FooterStyle.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World);
this.rtfExport1.RTFOptions.HeaderStyle.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World);
this.rtfExport1.RTFOptions.TitleStyle.Alignment = Spire.DataExport.RTF.RtfTextAlignment.Center;
this.rtfExport1.RTFOptions.TitleStyle.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold);
this.rtfExport1.DataSource = ExportSource.ListView;
this.rtfExport1.ListView = this.ListView1
rtfExport1.SaveToFile();
Me.rtfExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView
Me.rtfExport1.DataFormats.CultureName = "en-us"
Me.rtfExport1.DataFormats.Currency = "c"
Me.rtfExport1.DataFormats.DateTime = "yyyy-M-d H:mm"
Me.rtfExport1.DataFormats.Float = "g"
Me.rtfExport1.DataFormats.Integer = "g"
Me.rtfExport1.DataFormats.Time = "H:mm"
Me.rtfExport1.FileName = "sample.doc"
Me.rtfExport1.RTFOptions.DataStyle.Font = New System.Drawing.Font("Arial", 10.0!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World)
Me.rtfExport1.RTFOptions.FooterStyle.Font = New System.Drawing.Font("Arial", 10.0!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World)
Me.rtfExport1.RTFOptions.HeaderStyle.Font = New System.Drawing.Font("Arial", 10.0!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World)
Me.rtfExport1.RTFOptions.TitleStyle.Alignment = Spire.DataExport.RTF.RtfTextAlignment.Center
Me.rtfExport1.RTFOptions.TitleStyle.Font = New System.Drawing.Font("Arial", 10.0!, System.Drawing.FontStyle.Bold)
Me.rtfExport1.DataSource = Common.ExportSource.ListView
Me.cellExport1.ListView = Me.ListView1
Me.cellExport1.SaveToFile()
Spire.DataExport for .NET, is a professional .NET component suit for data exporting. It allows programmers export data from database to MS Excel, MS Word, HTML, XML, PDF, MS Access, DBF, SQL Script, SYLK, DIF, CSV ,MS Clipboard format. Here we will introduce how to export data from listview to HTML.
As the predominant markup language for web pages, HTMLwhich stands for HyperText Markup Language is written in the form of HTML elements consisting of tags, enclosed in angle brackets (like ), within the web page content. It's the basic building-blocks of webpages. HTML has many advantages such as:
- Easy to use
- Loose syntax (although, being too flexible will not comply with standards)
- Supported on almost every browser, if not all browsers
- Free - You need not buy any software
- Easy to learn & code even for novice programmers
- Very similar to XML syntax, which is increasingly used for data storage
- Widely used; established on almost every website, if not all websites
Spire.DataExport presents an easy way to export data from Listview to HTML. Download Spire.DataExport (or Spire.Office) with .NET framework 2.0 (or above) together and use the code below to export data from Listview to HTML with C#/VB.NET.
Spire.DataExport.HTML.HTMLExport htmlExport1;
this.htmlExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
this.htmlExport1.DataFormats.CultureName = "zh-CN";
this.htmlExport1.DataFormats.Currency = "c";
this.htmlExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
this.htmlExport1.DataFormats.Float = "g";
this.htmlExport1.DataFormats.Integer = "g";
this.htmlExport1.DataFormats.Time = "H:mm";
this.htmlExport1.FileName = "sample.html";
this.htmlExport1.HtmlStyle = Spire.DataExport.HTML.HtmlStyle.MSMoney;
this.htmlExport1.HtmlTableOptions.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(222)), ((System.Byte)(231)), ((System.Byte)(222)));
this.htmlExport1.HtmlTableOptions.FontColor = System.Drawing.Color.Black;
this.htmlExport1.HtmlTableOptions.HeadersBackColor = System.Drawing.Color.FromArgb(((System.Byte)(206)), ((System.Byte)(198)), ((System.Byte)(181)));
this.htmlExport1.HtmlTableOptions.HeadersFontColor = System.Drawing.Color.Black;
this.htmlExport1.HtmlTableOptions.OddBackColor = System.Drawing.Color.FromArgb(((System.Byte)(255)), ((System.Byte)(251)), ((System.Byte)(240)));
this.htmlExport1.HtmlTextOptions.BackgroundColor = System.Drawing.Color.White;
this.htmlExport1.HtmlTextOptions.Font = new System.Drawing.Font("Arial", 8F);
this.htmlExport1.HtmlTextOptions.LinkActiveColor = System.Drawing.Color.Blue;
this.htmlExport1.HtmlTextOptions.LinkColor = System.Drawing.Color.Red;
this.htmlExport1.HtmlTextOptions.LinkVisitedColor = System.Drawing.Color.Purple;
this.htmlExport1.DataSource = Common.ExportSource.ListView;
this.htmlExport1.ListView = this.listView1;
htmlExport1.SaveToFile();
htmlExport1 As Spire.DataExport.HTML.HTMLExport
Me.htmlExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView
Me.htmlExport1.DataFormats.CultureName = "zh-CN"
Me.htmlExport1.DataFormats.Currency = "c"
Me.htmlExport1.DataFormats.DateTime = "yyyy-M-d H:mm"
Me.htmlExport1.DataFormats.Float = "g"
Me.htmlExport1.DataFormats.Integer = "g"
Me.htmlExport1.DataFormats.Time = "H:mm"
Me.htmlExport1.FileName = "sample.html"
Me.htmlExport1.HtmlStyle = Spire.DataExport.HTML.HtmlStyle.MSMoney
Me.htmlExport1.HtmlTableOptions.BackColor = System.Drawing.Color.FromArgb(CType(222, Byte), CType(231, Byte), CType(222, Byte))
Me.htmlExport1.HtmlTableOptions.FontColor = System.Drawing.Color.Black
Me.htmlExport1.HtmlTableOptions.HeadersBackColor = System.Drawing.Color.FromArgb(CType(206, Byte), CType(198, Byte), CType(181, Byte))
Me.htmlExport1.HtmlTableOptions.HeadersFontColor = System.Drawing.Color.Black
Me.htmlExport1.HtmlTableOptions.OddBackColor = System.Drawing.Color.FromArgb(CType(255, Byte), CType(251, Byte), CType(240, Byte))
Me.htmlExport1.HtmlTextOptions.BackgroundColor = System.Drawing.Color.White
Me.htmlExport1.HtmlTextOptions.Font = New System.Drawing.Font("Arial", 8.0!)
Me.htmlExport1.HtmlTextOptions.LinkActiveColor = System.Drawing.Color.Blue
Me.htmlExport1.HtmlTextOptions.LinkColor = System.Drawing.Color.Red
Me.htmlExport1.HtmlTextOptions.LinkVisitedColor = System.Drawing.Color.Purple
Me.htmlExport1.DataSource = Common.ExportSource.ListView
Me.htmlExport1.ListView = Me.listView1
htmlExport1.SaveToFile()
Because of safety, easy to transfer from one to another and also easy to use, PDf is now becoming No. 1 file format all over the world. Usually customers will need export data from database to PDF file format. Spire.DataExport for .NET is a .NET component suit, 100% pure managed by C# for data exporting from database such as ListView, datatable and SQL command into MS Excel,MS Word, HTML, XML, PDF, MS Access, DBF, SQL Script, SYLK, DIF, CSV ,MS Clipboard format.
Spire.DataExport for .Net provides a quick and easy solution to export data from Listview to PDF. With Spire.DataExport for .Net, users also have other rich options when export data from database.
Now Download Spire.DataExport (or Spire.Office) with .NET framework together and use the code below to export data from Listview to PDF with C#/VB.NET.
protected void Button1_Click(object sender, System.EventArgs e)
{
oleDbConnection1.Open();
this.cellExport1.ActionAfterExport = DataExport.Common.ActionType.None;
this.cellExport1.DataFormats.CultureName = "zh-CN";
this.cellExport1.DataFormats.Currency = "?#,###,##0.00";
this.cellExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
this.cellExport1.DataFormats.Float = "#,###,##0.00";
this.cellExport1.DataFormats.Integer = "#,###,##0";
this.cellExport1.DataFormats.Time = "H:mm";
this.cellExport1.SheetOptions.AggregateFormat.Font.Name = "Arial";
this.cellExport1.SheetOptions.CustomDataFormat.Font.Name = "Arial";
this.cellExport1.SheetOptions.DefaultFont.Name = "Arial";
this.cellExport1.SheetOptions.FooterFormat.Font.Name = "Arial";
this.cellExport1.SheetOptions.HeaderFormat.Font.Name = "Arial";
this.cellExport1.SheetOptions.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
this.cellExport1.SheetOptions.HyperlinkFormat.Font.Name = "Arial";
this.cellExport1.SheetOptions.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
this.cellExport1.SheetOptions.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
this.cellExport1.SheetOptions.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
this.cellExport1.SheetOptions.NoteFormat.Font.Bold = true;
this.cellExport1.SheetOptions.NoteFormat.Font.Name = "Tahoma";
this.cellExport1.SheetOptions.NoteFormat.Font.Size = 8F;
this.cellExport1.SheetOptions.TitlesFormat.Font.Bold = true;
this.cellExport1.SheetOptions.TitlesFormat.Font.Name = "Arial";
this.cellExport1.DataSource = DataExport.Common.ExportSource.ListView;
this.cellExport1.ListView = this.listView1;
Using(MemoryStream stream = new MemoryStream())
{
cellExport1.SaveToFile(stream);
this.oleDbConnection1.Close();
Workbook workbook = new Workbook(stream);
PdfConverter pdfConverter = new PdfConverter(workbook);
PdfDocument pdfDocument = new PdfDocument();
pdfDocument.PageSettings.Orientation = pdf.PdfPageOrientation.Landscape;
pdfDocument.PageSettings.Width = 970;
pdfDocument.PageSettings.Height = 850;
PdfConverterSettings settings = new PdfConverterSettings();
settings.TemplateDocument = pdfDocument;
pdfDocument = pdfConverter.Convert(settings);
pdfDocument.SaveToFile("test.pdf");
}
}
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
oleDbConnection1.Open()
Me.cellExport1.ActionAfterExport = DataExport.Common.ActionType.None
Me.cellExport1.DataFormats.CultureName = "zh-CN"
Me.cellExport1.DataFormats.Currency = "?#,###,##0.00"
Me.cellExport1.DataFormats.DateTime = "yyyy-M-d H:mm"
Me.cellExport1.DataFormats.Float = "#,###,##0.00"
Me.cellExport1.DataFormats.Integer = "#,###,##0"
Me.cellExport1.DataFormats.Time = "H:mm"
Me.cellExport1.SheetOptions.AggregateFormat.Font.Name = "Arial"
Me.cellExport1.SheetOptions.CustomDataFormat.Font.Name = "Arial"
Me.cellExport1.SheetOptions.DefaultFont.Name = "Arial"
Me.cellExport1.SheetOptions.FooterFormat.Font.Name = "Arial"
Me.cellExport1.SheetOptions.HeaderFormat.Font.Name = "Arial"
Me.cellExport1.SheetOptions.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue
Me.cellExport1.SheetOptions.HyperlinkFormat.Font.Name = "Arial"
Me.cellExport1.SheetOptions.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single
Me.cellExport1.SheetOptions.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left
Me.cellExport1.SheetOptions.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top
Me.cellExport1.SheetOptions.NoteFormat.Font.Bold = True
Me.cellExport1.SheetOptions.NoteFormat.Font.Name = "Tahoma"
Me.cellExport1.SheetOptions.NoteFormat.Font.Size = 8F
Me.cellExport1.SheetOptions.TitlesFormat.Font.Bold = True
Me.cellExport1.SheetOptions.TitlesFormat.Font.Name = "Arial"
Me.cellExport1.DataSource = DataExport.Common.ExportSource.ListView
Me.cellExport1.ListView = Me.listView1
Dim stream As New MemoryStream()
cellExport1.SaveToFile(stream)
stream.Close()
Me.oleDbConnection1.Close()
Dim workbook As New Workbook(stream)
Dim pdfConverter As New PdfConverter(workbook)
Dim pdfDocument As New PdfDocument()
pdfDocument.PageSettings.Orientation = pdf.PdfPageOrientation.Landscape
pdfDocument.PageSettings.Width = 970
pdfDocument.PageSettings.Height = 850
Dim settings As New PdfConverterSettings()
settings.TemplateDocument = pdfDocument
pdfDocument = pdfConverter.Convert(settings)
pdfDocument.SaveToFile("test.pdf")
End Sub
Spire.DataExport, as a 100% pure .NET component suit for data exporting from SQL Command, Listview and DataTable into MS Excel,MS Word, HTML, XML, PDF, MS Access, DBF, SQL Script, SYLK, DIF, CSV ,MS Clipboard format, quickly and easily! Here we will introduce how to export data from Listview to Excel with C#/VB.NET.
As an electronic spreadsheet program, MS Excel owns a lot of advantages such as it can be used for storing, organizing and manipulating data. Over several decades, Microsoft has updated, expanded and tweaked Excel to keep up with both modern technology and the needs of spreadsheet users. MS Excel has been the most popular data organizing program. So we may usually need export data from database into Excel, such as from ListView.
Spire.DataExport presents an easy way to export data from Listview to Excel. And it offers both C# and VB.Net language to realize it
Download Spire.DataExport (or Spire.Office) with .NET framework together and use the code below to export data from Listview to Excel with C# and VB.NET.
this.cellExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
this.cellExport1.AutoFitColWidth = true;
this.cellExport1.DataFormats.CultureName = "en-us";
this.cellExport1.DataFormats.Currency = "?#,###,##0.00";
this.cellExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
this.cellExport1.DataFormats.Float = "#,###,##0.00";
this.cellExport1.DataFormats.Integer = "#,###,##0";
this.cellExport1.DataFormats.Time = "H:mm";
this.cellExport1.FileName = "sample.xls";
this.cellExport1.SheetOptions.AggregateFormat.Font.Name = "Arial";
this.cellExport1.SheetOptions.CustomDataFormat.Font.Name = "Arial";
this.cellExport1.SheetOptions.DefaultFont.Name = "Arial";
this.cellExport1.SheetOptions.FooterFormat.Font.Name = "Arial";
this.cellExport1.SheetOptions.HeaderFormat.Font.Name = "Arial";
this.cellExport1.SheetOptions.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
this.cellExport1.SheetOptions.HyperlinkFormat.Font.Name = "Arial";
this.cellExport1.SheetOptions.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
this.cellExport1.SheetOptions.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
this.cellExport1.SheetOptions.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
this.cellExport1.SheetOptions.NoteFormat.Font.Bold = true;
this.cellExport1.SheetOptions.NoteFormat.Font.Name = "Tahoma";
this.cellExport1.SheetOptions.NoteFormat.Font.Size = 8F;
this.cellExport1.SheetOptions.TitlesFormat.Font.Bold = true;
this.cellExport1.SheetOptions.TitlesFormat.Font.Name = "Arial";
this.cellExport1.DataSource = ExportSource.ListView;
this.cellExport1.ListView = this.ListView1;
cellExport1.SaveToFile();
ListView to Excel with VB.NET Code
Me.cellExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView
Me.cellExport1.AutoFitColWidth = True
Me.cellExport1.DataFormats.CultureName = "en-us"
Me.cellExport1.DataFormats.Currency = "?#,###,##0.00"
Me.cellExport1.DataFormats.DateTime = "yyyy-M-d H:mm"
Me.cellExport1.DataFormats.Float = "#,###,##0.00"
Me.cellExport1.DataFormats.Integer = "#,###,##0"
Me.cellExport1.DataFormats.Time = "H:mm"
Me.cellExport1.FileName = "sample.xls"
Me.cellExport1.SheetOptions.AggregateFormat.Font.Name = "Arial"
Me.cellExport1.SheetOptions.CustomDataFormat.Font.Name = "Arial"
Me.cellExport1.SheetOptions.DefaultFont.Name = "Arial"
Me.cellExport1.SheetOptions.FooterFormat.Font.Name = "Arial"
Me.cellExport1.SheetOptions.HeaderFormat.Font.Name = "Arial"
Me.cellExport1.SheetOptions.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue
Me.cellExport1.SheetOptions.HyperlinkFormat.Font.Name = "Arial"
Me.cellExport1.SheetOptions.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single
Me.cellExport1.SheetOptions.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left
Me.cellExport1.SheetOptions.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top
Me.cellExport1.SheetOptions.NoteFormat.Font.Bold = True
Me.cellExport1.SheetOptions.NoteFormat.Font.Name = "Tahoma"
Me.cellExport1.SheetOptions.NoteFormat.Font.Size = 8.0!
Me.cellExport1.SheetOptions.TitlesFormat.Font.Bold = True
Me.cellExport1.SheetOptions.TitlesFormat.Font.Name = "Arial"
Me.cellExport1.DataSource = Common.ExportSource.ListView
Me.cellExport1.ListView = Me.ListView1
cellExport1.SaveToFile()
End Sub
Watermarks are text or images displayed fadedly or in gray color in the background of a Word document. They can be used to declare confidentiality, copyright, or other attributes of the document, or just as decorations to make the document more attractive. This article shows an easy way to insert watermarks in Word documents with the help of Spire.Doc for .NET, including text watermarks and image watermarks.
Install Spire.Doc for .NET
To begin with, you need to add the DLL files included in the Spire.Doc 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.Doc
Insert a Text Watermark in a Word Document
The detailed steps are as follows:
- Create an object of Document class.
- Load a Word document from disk using Document.LoadFromFile() method.
- Insert a text watermark in the document using custom method InsertTextWatermark().
- Save the document using Doucment.SaveToFile() method.
- C#
- VB.NET
using System;
using System.Drawing;
using Spire.Doc;
using Spire.Doc.Documents;
namespace InsertImageWatermark
{
internal class Program
{
static void Main(string[] args)
{
//Create an object of Document class
Document document = new Document();
//Load a Word document from disk
document.LoadFromFile(@"D:\Samples\Sample.docx");
//Insert a text watermark
InsertTextWatermark(document.Sections[0]);
//Save the document
document.SaveToFile("InsertTextWatermark.docx", FileFormat.Docx);
}
private static void InsertTextWatermark(Section section)
{
TextWatermark txtWatermark = new TextWatermark();
txtWatermark.Text = "DO NOT COPY";
txtWatermark.FontSize = 50;
txtWatermark.Color = Color.Blue;
txtWatermark.Layout = WatermarkLayout.Diagonal;
section.Document.Watermark = txtWatermark;
}
}
}
Insert an Image Watermark in a Word Document
The detailed steps are as follows:
- Create an object of Document class.
- Load a Word document from disk using Document.LoadFromFile() method.
- Insert an image watermark in the document using custom method InsertImageWatermark().
- Save the document using Document.SaveToFile() method.
- C#
- VB.NET
using System;
using System.Drawing;
using Spire.Doc;
using Spire.Doc.Documents;
namespace InsertWatermark
{
internal class Program
{
static void Main(string[] args)
{
//Create an object of Document class
Document document = new Document();
//Load a Word document from disk
document.LoadFromFile(@"D:\Samples\Sample.docx");
//Insert an image watermark
InsertImageWatermark(document);
//Save the document
document.SaveToFile("InsertImageWatermark.docx", FileFormat.Docx);
}
private static void InsertImageWatermark(Document document)
{
PictureWatermark picture = new PictureWatermark();
picture.Picture = Image.FromFile(@"D:\Samples\Watermark.png");
picture.Scaling = 200;
picture.IsWashout = false;
document.Watermark = picture;
}
}
}
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.
How to Split PDF Files in C# .NET (Complete Guide with Code Examples)
2022-06-28 07:52:00 Written by Koohji
Splitting PDF files programmatically is a crucial step for automating document management in many C# and .NET applications. Whether you need to extract specific pages, divide PDFs by defined ranges, or organize large reports, using code to segment PDFs saves time and improves accuracy.
This comprehensive guide shows how to programmatically split or divide PDF files in C# using the Spire.PDF for .NET library, with practical methods and clear code examples to help developers easily integrate PDF splitting into their applications.
Table of Contents
- Why Split a PDF Programmatically in C#?
- What You Need to Get Started
- Installing Spire.PDF for .NET Library
- How to Split PDF Files in C# (Methods and Code Examples)
- Split PDF in VB.NET
- Conclusion
- Frequently Asked Questions (FAQs)
Why Split a PDF Programmatically in C#?
Splitting PDFs through code offers significant advantages over manual processing. It enables:
- Automated report generation
- Faster document preparation in enterprise workflows
- Easy content extraction for archiving or redistribution
- Dynamic document handling based on user or system input
It also reduces the risk of human error and ensures consistency across repetitive tasks.
What You Need to Get Started
Before diving into the code, make sure you have:
- .NET Framework or .NET Core installed
- Visual Studio or another C# IDE
- Spire.PDF for .NET library installed
- Basic familiarity with C# programming
Installing Spire.PDF for .NET Library
Spire.PDF for .NET is a professional .NET library that enables developers to create, read, edit, and manipulate PDF files without Adobe Acrobat. It supports advanced PDF operations like splitting, merging, extracting text, adding annotations, and more.
You can install Spire.PDF for .NET NuGet Package via NuGet Package Manager:
Install-Package Spire.PDF
Or through the NuGet UI in Visual Studio:
- Right-click your project > Manage NuGet Packages
- Search for Spire.PDF
- Click Install
How to Split PDF Files in C# (Methods and Code Examples)
Breaking PDF by Every Page
When you want to break a PDF into multiple single-page files, the Split method is the easiest way. By specifying the output file name pattern, you can automatically save each page of the PDF as a separate file. This method simplifies batch processing or distributing pages individually.
using Spire.Pdf;
namespace SplitPDF
{
internal class Program
{
static void Main(string[] args)
{
PdfDocument pdf = new PdfDocument();
pdf.LoadFromFile("Sample.pdf");
// Split each page into separate PDF files.
// The first parameter is the output file pattern.
// {0} will be replaced by the page number starting from 1.
pdf.Split("Output/Page_{0}.pdf", 1);
pdf.Close();
}
}
}
Dividing PDF by Page Ranges
To divide a PDF into multiple sections based on specific page ranges, the InsertPageRange method is ideal. This example shows how to define page ranges using zero-based start and end page indices, and then extract those ranges into separate PDF files efficiently.
using Spire.Pdf;
namespace SplitPDF
{
internal class Program
{
static void Main(string[] args)
{
// Load the PDF
PdfDocument document = new PdfDocument();
document.LoadFromFile("Sample.pdf");
// Define two ranges — pages 1–6 and 7–13 (0-based index)
int[][] ranges = new int[][]
{
new int[] { 0, 5 },
new int[] { 6, 12 }
};
// Split the PDF into smaller files by the predefined page ranges
for (int i = 0; i < ranges.Length; i++)
{
int startPage = ranges[i][0];
int endPage = ranges[i][1];
PdfDocument rangePdf = new PdfDocument();
rangePdf.InsertPageRange(document, startPage, endPage);
rangePdf.SaveToFile($"Output/Pages_{startPage + 1}_to_{endPage + 1}.pdf");
rangePdf.Close();
}
document.Close();
}
}
}
Splitting PDF by Text or Keywords
To perform content-based PDF splitting, use the Find method of the PdfTextFinder class to locate pages containing specific keywords. Once identified, you can extract these pages and insert them into new PDF files using the InsertPage method. This approach enables precise page extraction based on document content instead of fixed page numbers.
using Spire.Pdf;
using Spire.Pdf.Texts;
using System.Collections.Generic;
namespace SplitPDF
{
internal class Program
{
static void Main(string[] args)
{
// Load the PDF document
PdfDocument document = new PdfDocument();
document.LoadFromFile("Sample.pdf");
// Create a new PDF to hold extracted pages
PdfDocument resultDoc = new PdfDocument();
string keyword = "Market";
// Loop through all pages to find the keyword
for (int i = 0; i < document.Pages.Count; i++)
{
PdfPageBase page = document.Pages[i];
PdfTextFinder finder = new PdfTextFinder(page);
// Set search options
finder.Options.Parameter = TextFindParameter.WholeWord;
finder.Options.Parameter = TextFindParameter.IgnoreCase;
// Find keyword on the page
List<PdfTextFragment> fragments = finder.Find(keyword);
// If keyword found, append the page to result PDF
if (fragments.Count > 0)
{
resultDoc.InsertPage(document, page);
}
}
// Save the result PDF
resultDoc.SaveToFile("Pages_With_Keyword.pdf");
// Dispose resources
document.Dispose();
resultDoc.Dispose();
}
}
}
Extracting Specific Pages from PDF
Sometimes you only need to extract one or a few individual pages from a PDF instead of splitting the whole document. This example demonstrates how to use the InsertPage method of the PdfDocument class to extract a specific page and save it as a new PDF. This method is useful for quickly pulling out important pages for review or distribution.
using Spire.Pdf;
namespace SplitPDF
{
internal class Program
{
static void Main(string[] args)
{
// Load the PDF file
PdfDocument pdf = new PdfDocument();
pdf.LoadFromFile("Sample.pdf");
// Create a new PDF to hold the extracted page
PdfDocument newPdf = new PdfDocument();
// Insert the third page (index 2, zero-based) from the PDF into the new PDF
newPdf.InsertPage(pdf, pdf.Pages[2]);
// Save the new PDF
newPdf.SaveToFile("ExtractPage.pdf");
newPdf.Close();
pdf.Close();
}
}
}
Split PDF in VB.NET
If you're working with VB.NET instead of C#, you don't need to worry about translating the code manually. You can easily convert the C# code examples in this article to VB.NET using our C# to VB.NET code converter. This tool ensures accurate syntax conversion, saving time and helping you stay focused on development.
Conclusion
Splitting PDF files programmatically in C# using Spire.PDF offers a reliable and flexible solution for automating document processing. Whether you're working with invoices, reports, or dynamic content, Spire.PDF supports various splitting methods—by page, page range, or keyword—allowing you to tailor the logic to fit any business or technical requirement.
Frequently Asked Questions (FAQs)
Q1: Is Spire.PDF free to use?
A1: Spire.PDF offers a free version suitable for small-scale or non-commercial use. For full functionality and advanced features, the commercial version is recommended.
Q2: Can I split encrypted PDFs?
A2: Yes, as long as you provide the correct password when loading the PDF files.
Q3: Does Spire.PDF support .NET Core?
A3: Yes, Spire.PDF is compatible with both .NET Framework and .NET Core.
Q4: Can I split and merge PDFs in the same project?
A4: Absolutely. Spire.PDF provides comprehensive support for both splitting and merging operations.
Get a Free License
To fully experience the capabilities of Spire.PDF for .NET without any evaluation limitations, you can request a free 30-day trial license.
