Click or drag to resize
Hello World Sample

After installing a component (to download component, click here), it is installed in GAC (Global Assembly Cache).

To use GemBox.Spreadsheet follow these steps:

  • Create a new .NET project (or use the existing one).

  • Use Add Reference dialog to add a new reference to the DLL with GemBox.Spreadsheet name. It should be under .NET tab.

  • Import GemBox.Spreadsheet namespace: using GemBox.Spreadsheet; for C# or Import GemBox.Spreadsheet for VB.NET.

  • Set license key to use GemBox.Spreadsheet in a Free mode: SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY"); for C# or SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY") for VB.NET.

Now you can write your application specific spreadsheet code like the one below.

Example

Using GemBox.Spreadsheet component is easy and straightforward. The following code shows how to create a spreadsheet with a single 'Hello World!' cell:

// Create new empty Excel file.
ExcelFile ef = new ExcelFile();

// Create new worksheet and set cell A1 value to 'Hello World!'.
ef.Worksheets.Add("Test").Cells["A1"].Value = "Hello World!";

// Save to XLSX file.
ef.Save("Test.xlsx");