SpreadsheetLight 3.4.2

.NET Framework This package is compatible with all versions of .NET Framework.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package SpreadsheetLight --version 3.4.2                

                    
                

            
NuGet\Install-Package SpreadsheetLight -Version 3.4.2
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="SpreadsheetLight" Version="3.4.2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add SpreadsheetLight --version 3.4.2                

                    
                

            
#r "nuget: SpreadsheetLight, 3.4.2"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// Install SpreadsheetLight as a Cake Addin
#addin nuget:?package=SpreadsheetLight&version=3.4.2

// Install SpreadsheetLight as a Cake Tool
#tool nuget:?package=SpreadsheetLight&version=3.4.2

SpreadsheetLight is an open source Open XML spreadsheet library for .NET Framework written in C#, and is released under the MIT License. You can create new Open XML spreadsheets, or work with existing Open XML spreadsheets that are compatible with Microsoft Excel 2007/2010/2013 and LibreOffice Calc.

No Office/Excel Interop needed. You do not need Microsoft Office/Excel to be installed.

Dependency: Open XML SDK 2.0 (not 2.5)

Product Compatible and additional computed target framework versions.
.NET Framework net is compatible. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

NuGet packages (21)

Showing the top 5 NuGet packages that depend on SpreadsheetLight:

Package Downloads
FastReport.Data.Excel

Represents a connection to Excel data. Shared Plugin for all versions of FastReport product: FastReport .NET, FastReport.Core, FastReport.OpenSource, FastReport.WPF, FastReport.Avalonia. Requirements: Any FastReport 2025.1.2.0+ package, NuGet Client 3.4.4+
SpreadsheetHelper

.NET Spreadsheet Object Wrapper for SpreadsheetLight
AutomationFramework_NetCore

AT Net Core Automation Framework
TechTools.Utils

Utilitarios con funciones que se utilizan en varios proyectos de desarrollo de software
MagiQL.Framework.Renderers.SpreadsheetGenerator

MagiQL :: MagiQL.Framework.Renderers.SpreadsheetGenerator

GitHub repositories (3)

Showing the top 3 popular GitHub repositories that depend on SpreadsheetLight:

Repository Stars
FastReports/FastReport
Free Open Source Reporting tool for .NET6/.NET Core/.NET Framework that helps your application generate document-like reports
Kinovea/Kinovea
Video solution for sport analysis. Capture, inspect, compare, annotate and measure technical performances.
Tadelsucht/BulkPDF
BulkPDF is a free and easy to use open source software, which allows to automatically fill an existing PDF form with differen values. Only a spreadsheet (Microsoft Excel 2007/2010/2013, LibreOffice or OpenOffice Calc) with the desired values is required.
Version Downloads Last updated
3.5.0 1,394,729 11/14/2020
3.4.11 339,935 7/14/2019
3.4.10 7,864 7/5/2019
3.4.9 512,303 4/1/2017
3.4.8 80,074 10/21/2016
3.4.7 4,610 10/9/2016
3.4.6 20,792 10/3/2016
3.4.5.1 5,998 9/26/2016
3.4.5 4,039 9/26/2016
3.4.4 337,847 4/26/2014
3.4.3 5,231 3/1/2014
3.4.2 2,216 2/22/2014
3.4.1 24,305 8/31/2013
3.4.0 28,273 7/27/2013
3.3.1 4,353 6/7/2013
3.3.0 6,964 5/18/2013
3.2.9 3,154 5/12/2013
1.0.0 5,325 4/24/2013

You can read the full list of changes at http://spreadsheetlight.com/version-history/ Note that source code is only available up to minor releases, meaning Major.Minor.0 versions.

Version 3.4.2
- You can now get row/column grouping levels. See GetRowGroupLevel() and GetColumnGroupLevel() functions.
- You can now get a list of the shared cell formulas in the currently selected worksheet. See GetSharedCellFormulas() function.
- Cell formulas are now more correctly maintained when copying/inserting/deleting cells/rows/columns.
- Catered for situation where cell reference ranges aren't in top-left to bottom-right format (such as E1:A7). See SLTool for translating reference sequences to SLCellPointRange and vice versa. Don't worry, you probably wouldn't have known about this anyway...
- You can now draw borders on a cell range! And border grids! Try out the DrawBorder() and DrawBorderGrid() functions.
- You can now merge cells and set style/border properties at the same time! No more manual border drawing on merged cells! Woohoo! See MergeWorksheetCells() function overloads.
- You can now make SpreadsheetLight throw up, I mean, throw exceptions! When there are exceptions, of course. See ThrowExceptionsIfAny property. Not sure how much help this is though...
- You can now forcibly get a boolean value if it looks like it's a boolean but actually stored as text. See the GetCellValueAsBoolean() functions.
- Breaking change: SLCellFormula.Reference data type changed from string to List<SLCellPointRange> (but you shouldn't have been using this anyway...)
- Bug fix: The properties "count" and "uniqueCount" removed from shared strings table part. It seems a high number of shared strings will cause the calculation to render a corrupt file. See when writing the shared strings table for details.
- Bug fix: Outline (grouping) levels of rows and columns now limited to 0 to 7 (was allowed to go to 8 previously. See GroupRows() and GroupColumns() in RowColumnFunctions.cs)

Version 3.4.1
- Removed optional argument use (specifically IsStylish) so that developers using Visual Studio 2008 (.NET Framework 3.5) can still compile the source code.
- Optimised GetWorksheetStatistics(). It's now faster and less memory intensive.
- Bug fix: autofitting rows with a smaller initial height now correctly autofit to content
- Bug fix (?): SLStyle.MergeStyle() now takes on the new style object's format code regardless.