EXCEL Workbook Protection in C#, VB.NET
The sample demonstrates how to lock and unlock an excel workbook.
EXCEL VBA in C#, VB.NET
The sample demonstrates How to Use VBA in an excel workbook.
EXCEL Pagesetup in C#, VB.NET
The sample demonstrates how to work with page setup in an excel workbook.
EXCEL DataValidation in C#, VB.NET
The sample demonstrates how to write validation into spreadsheet.
EXCEL Write Filters in C#, VB.NET
The sample demonstrates how to create auto filters in an excel workbook.
EXCEL Group in C#, VB.NET
The sample demonstrates how to create group in an excel workbook..
EXCEL Freezepane in C#, VB.NET
The sample demonstrates how to freeze excel workbook.
EXCEL Write RichText in C#, VB.NET
The sample demonstrates how to write rich text into spreadsheet.
EXCEL Read RichText in C#, VB.NET
The sample demonstrates how to read rich text from spreadsheet.
Spire.XLS for .NET Quick Start
In this document, we will quickly help you finish a simple demo about Spire.XLS using Visual Studio. As usual, it’s a HelloWorld demo. Before you get started, please make sure the Spire.XLS and Visual Studio (2008 or later) are installed on your computer.
1. In Visual Studio, click File, New, and then Project, If you want to create a C# project, select Visual C#, Windows and choose Windows Forms Application and name the project HelloWorld. Click OK. If you want to create a Visual Basic project, select Visual Basic, Windows Forms Application and name the project HelloWorld. Click OK.
2. In Solution Explorer, right-click the project HelloWorld and click Add Reference. In the Browse tab, find the folder in which you installed the Spire.XLS, default is "C:\Program Files\e-iceblue\Spire.XLS", double-click the folder Bin. If the target framework of the project HelloWorld
- is .NET 2.0, double-click folder NET2.0
- is .NET 3.5, double-click folder NET3.5
- is .NET 4.0, double-click folder NET4.0
select assembly Spire.XLS.dll and click OK to add it to the project.
3. In Solution Explorer, double-click the file Form1.cs/Form1.vb to open the form design view, add a button into the form, and change its name to 'btnRun', change its text to 'Run'.
4. Double-click the button 'Run', you will see the code view and the following method has been added automatically:
private void btnRun_Click(object sender, EventArgs e)
Private Sub btnRun_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRun.Click
5. Add the following codes to the top of the file
using Spire.Xls;
Imports Spire.Xls
6. Add the following codes to the method btnRun_Click
//Creates workbook
Workbook workbook = new Workbook();
//Gets first worksheet
Worksheet sheet = workbook.Worksheets[0];
//Writes hello world to A1
sheet.Range["A1"].Text = "Hello,World!";
//Save workbook to disk
workbook.SaveToFile("Sample.xls");
try
{
System.Diagnostics.Process.Start(workbook.FileName);
}
catch { }
'Creates workbook
Dim workbook As Workbook = New Workbook()
'Gets first worksheet
Dim sheet As Worksheet = workbook.Worksheets(0)
'Writes hello world to A1
sheet.Range("A1").Text = "Hello,World!"
'Save workbook to disk
workbook.SaveToFile("Sample.xls")
Try
System.Diagnostics.Process.Start(workbook.FileName)
Catch
End Try
7. In Solution Explorer, right-click the project HelloWorld and click Debug, then Start new instance, you will see the opened window Form1, click the button 'Run', an Excel document will be created, edited and opened. The string "Hello, World" is filled in the cell A1.
