Do you need to generate Excel spreadsheets on your server on a monthly basis? Do you need to create Excel spreadsheets on your web server on the fly? Do you need to take the data in your database and put it in an Excel spreadsheet for your clients?
And do you want to write source code that does that just as easily as using Excel?
SpreadsheetLight makes it easy for you to create those spreadsheets. You can write code that does most of the common Excel tasks with SpreadsheetLight as easily as using Excel itself (usually with only a handful of lines of code!).
You also get full library source code, so you can quickly create custom functions without waiting for technical support. Or you know, you’re just plain curious (that’s fine too).
SpreadsheetLight comes with perpetual royalty-free licensing, so you don’t have to worry about renewal fees.
Easy to use
SpreadsheetLight is a spreadsheet software library that’s built on .NET Framework and the Open XML SDK from Microsoft. Simply add the SpreadsheetLight library and the Open XML SDK to your software project and immediately start using it.
There is no crippling of feature sets and you don’t need someone to send you an unlock code. Straightforward adding to your project and continue forward with a minimum of fuss.
Simple to learn
You get extensive documentation of SpreadsheetLight so it’s easy to figure out what to do and how to do them. There’s also a quick-start guide so your programmers can start generating spreadsheets within minutes.
*Technical: Most standard functions of generating spreadsheets can be accessed through one class, so your programmers don’t have to search around the library and waste time.
Lightweight yet powerful
SpreadsheetLight offers you
- Comprehensive styling abilities from font colours to gradient background fills.
- Support for named cell styles.
- Easy rich text formatting within a cell.
- Support for built-in or custom-created themes.
- Row/column inserting and deleting, while correctly modifying all your merged cells, formulas, tables and defined names.
- Freezing and splitting worksheet panes.
- Extensive post-insertion picture abilities from fills and outlines, to perspective shadows, to 3D rotations.
- Easily insert tables.
- Sort cell data by column and by row.
- Set conditional formatting (data bars, color scales, icon sets and cell highlighting galore!).
Pay once, use forever. It’s royalty free. You get unlimited developer/site/client/machine licenses. You can use it in a commercial product. You can integrate the included source code in your own projects (subject to the MIT License).
You don’t have to worry about renewing licenses or copyright. Isn’t that a relief?
Simple purchasing process
You pay with your credit card or PayPal (payment information is not stored anywhere on the site). You go to a page to download the software library. You sign up in a form with your email address so you can be notified of updates (this is the only form you’ll ever fill in. Promise!)
That’s it! Send the software library to your programmers. Your coffee’s not even cold yet.
- The Hello World. This takes you through the basics of setting cell values. [Excel file]
- How to modify an existing spreadsheet. [Existing Excel file] [Resulting Excel file]
- How to format numbers and dates. [Excel file]
- How to set text alignment. [Excel file]
- How to set font settings. [Excel file]
- How to set borders. [Excel file]
- How to set pattern fills and gradients (even fancy ones!). [Excel file]
- How to style your rows, columns and cells. And even copy styles around! [Excel file]
- How to merge and unmerge cells. [Excel file]
- How to use rich text. [Excel file]
- How to modify existing styles (of rows, columns and cells). [Excel file]
- How to use named cell styles (such as Good, Bad, Neutral, Check Cell, Heading 1 and more). [Excel file]
- How to create new themes to style your spreadsheet! [Microsoft Office themed Excel file] [Newly themed Excel file]
- How to insert and delete rows and columns. [Excel file]
- How to copy entire rows and columns. [Excel file]
- How to hide rows and columns. [Excel file]
- How to set row heights and column widths. [Excel file]
- How to add, copy, rename, move and delete worksheets. [Excel file]
- How to freeze and split worksheet panes. [Excel file]
- How to insert pictures (with tons of fancy styling. We have 3D settings!). [Excel file]
- How to set defined names. Defined names are what used to be called named cells and named ranges. [Excel file]
- How to insert tables. [Excel file]
- How to sort data. [Excel file]
- How to set data bar conditional formats. [Excel file]
- How to set color scale conditional formats. [Excel file]
- How to set icon set conditional formats. [Excel file]
- How to set conditional formatting highlights. [Excel file]
- How to save to a web stream (useful for ASP.NET applications). [Excel file]
Not sure if SpreadsheetLight suits your needs? Download the MSDN-style documentation* (right-click and choose the “save as” option if you hit trouble) of all the available classes and functions and enumerations and whatnots. (Did you know the SLDocument class does most of your tasks? This means you don’t need to learn about too many new classes before getting started.)
As you’re writing your code, SpreadsheetLight provides you with extensive documentation on its functions and parameters, so it’s easy for you. The idea is so you don’t have to trawl through tons of documentation if you don’t want to.
* The documentation is in a CHM file. You might have to go to the file properties and choose Unblock under the General tab (in Windows) so you can view it.
- Have a minimum working blank spreadsheet with 2 lines of code. Alright 3 lines of code if you want to set a value.
- Save the spreadsheet as a file, or send it over the Internet (with ASP.NET).
- Strongly typed data parameters for setting and getting cell values.
- Support for date epochs of 1 January 1900 and 1 January 1904.
- Use one of 20 built-in themes, or create your own custom themes.
- Comprehensive support for styles from fonts to borders to gradient coloured backgrounds.
- Support for 47 named cell styles (the Good, the Bad and the Ug… I mean Neutral).
- Support for rich text formatting in cells.
- Hide and style rows and columns.
- Set row heights and column widths.
- Insert and delete rows and columns (and keeping the cell references of merged cells, formulas, tables and defined names correct).
- Freeze and split worksheet panes.
- Merge cells.
- Insert tables.
- Sort data by column and by row.
- Conditionally format any cell range.
- Defined names (what is previously known as named cells and named ranges).
- Insert pictures, with extensive support for post-picture-insertion manipulations (including inner/outer/perspective shadows, colour fills, outlines, bevelling, and 3D rotations).
- Classes, functions and properties are documented in detail, so you can just explore without having to read a manual (even though a quick start guide is provided).
- .NET Framework 3.5 and above
- Open XML SDK 2.0 (is already included for convenience)
Although the Open XML SDK assembly (DocumentFormat.OpenXml.dll) is included, it’s recommended that you install the Open XML SDK. The SDK is freely available from Microsoft.
You can get SpreadsheetLight at just USD 400.
Included in your purchase are:
- The SpreadsheetLight class library DLL
- Class, function and property documentation (in an XML file)
- The main Open XML SDK class library and its documentation
- A quick start guide (in a PDF file)
- Source code (in C#) of the SpreadsheetLight library (complete with relevant comments for nasty code sections)
- One year of unlimited updates*
- One year of unlimited technical support via email
With the documentation (in the XML file), you can also generate MSDN-like documentation for your own use. Or you can use this one.
The C# source code is provided under the MIT License (see within purchase). Basically it means you’re allowed to use the source code in commercial projects.
* Sign up with your email address at the end of purchase so I can send you the updates.
100% Money Back Guarantee
I offer you a 1 year guarantee. Within one year of your purchase, if for any reason, you’re not satisfied with SpreadsheetLight, let me know, and I’ll give you a full refund. No harm, no hassle.
Also, within one year of your purchase, you get unlimited technical support via email. Just contact me, and I’ll help you out with your problem.
My goal is for you to get results.
After your purchase is processed (you can pay with PayPal or your credit card), you will be sent to a download page where you can immediately download SpreadsheetLight. There will also be a form for you to enter your email address. Your email address will only be used to notify you of any software updates.
Your purchase information (whether it’s PayPal account information or credit card information) is not stored anywhere on this site.
Download SpreadsheetLight, and then enter your email address for notification of software updates.
Thank you and I wish you smooth sailing for your software projects.