Click or drag to resize
PicoXLSX

PicoXLSX

PicoXLSX is a small .NET / C# library to create XLSX files (Microsoft Excel 2007 or newer) in an easy and native way

  • No dependencies (*
  • No need for an installation of Microsoft Office
  • No need for Office interop libraries
  • No need for 3rd party libraries
  • No need for an installation of the Microsoft Open Office XML SDK (OOXML)

See the Change Log for recent updates.

Requirements

PicoXLSX was created with .NET version 4.5. Newer versions like 4.6.1 are working and tested. Older versions like 3.5 and 4.0 may also work with minor or no changes. However, this was not tested yet.

*)The only requirement to compile the library besides .NET is the assembly WindowsBase. This assembly is a standard component in all Microsoft Windows systems (except Windows RT systems). If your IDE of choice supports referencing assemblies from the Global Assembly Cache (GAC) of Windows, select WindowsBase from there. If you want so select the DLL manually and Microsoft Visual Studio is installed on your system, the DLL can be found most likely under “c:\Program Files\Reference Assemblies\Microsoft\Framework\v3.0\WindowsBase.dll”, according to this MSDN Blog entry. Otherwise you find it in the GAC, under “c:\Windows\Microsoft.NET\assembly\GAC_MSIL\WindowsBase”

If you want to compile the documentation project (folder: Documentation; project file: shfbproj), you need also the Sandcastle Help File Builder (SHFB). It is also freely available. But you don’t need the documentation project to build the PicoXLSX library.

Installation

Using NuGet

By Package Manager:
Namespaces
NamespaceDescription
PicoXLSX
PicoXLSX is a library to generate XLSX files in an easy and native way