GrapeCity.ActiveReports.SpreadBuilder 2.0.0

There is a newer version of this package available.
See the version list below for details.
dotnet add package GrapeCity.ActiveReports.SpreadBuilder --version 2.0.0
NuGet\Install-Package GrapeCity.ActiveReports.SpreadBuilder -Version 2.0.0
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="GrapeCity.ActiveReports.SpreadBuilder" Version="2.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add GrapeCity.ActiveReports.SpreadBuilder --version 2.0.0
#r "nuget: GrapeCity.ActiveReports.SpreadBuilder, 2.0.0"
#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 GrapeCity.ActiveReports.SpreadBuilder as a Cake Addin
#addin nuget:?package=GrapeCity.ActiveReports.SpreadBuilder&version=2.0.0

// Install GrapeCity.ActiveReports.SpreadBuilder as a Cake Tool
#tool nuget:?package=GrapeCity.ActiveReports.SpreadBuilder&version=2.0.0

Introduction

GrapeCity ActiveReports is a unique collection of developer reporting tools that help consume, process, and visualize data in the form of compelling and easy-to-understand reports.

GrapeCity ActiveReports provides a lot of features for developers and end-users, like:

  • VisualStudio integration support.
  • PaaS support (like Azure Linux App Service).
  • Different possibilities to pivot and aggregate data.
  • Rich data visualization.
  • Popular export formats (like PDF/Excel/Word).
  • And a lot more (https://www.grapecity.com/activereportsnet).

Concept

This package includes the .NET and .NET Core assemblies for reading, manipulating and writing Excel files. So you can create Excel spreadsheets cell by cell.

Example:

// Create a Workbook and add a sheet to its Sheets collection
System.Drawing.Bitmap bitmap = new System.Drawing.Bitmap(1, 1);
System.Drawing.Graphics graphics = System.Drawing.Graphics.FromImage(bitmap);
GrapeCity.SpreadBuilder.Workbook sb = new GrapeCity.SpreadBuilder.Workbook((text, measurementParams) =>
{
    // required for auto-row height function only
    System.Drawing.FontStyle style = System.Drawing.FontStyle.Regular;
    if (measurementParams.FontBold) style |= System.Drawing.FontStyle.Bold;
    if (measurementParams.FontItalic) style |= System.Drawing.FontStyle.Italic;
    using (System.Drawing.Font gFont = new System.Drawing.Font(measurementParams.FontName, measurementParams.FontSize, style))
    {
        int maxWidth = (int)System.Math.Ceiling(measurementParams.MaxWidth);
        System.Drawing.SizeF size = graphics.MeasureString(text, gFont, maxWidth == 0 ? 999999 : maxWidth);
        return new System.Drawing.SizeF((float)System.Math.Ceiling(size.Width), (float)System.Math.Ceiling(size.Height));
    }
});
sb.Sheets.AddNew();
  
// Set up properties and values for columns, rows and cells as desired
sb.Sheets[0].Name = "Customer Call List";
sb.Sheets[0].Columns(0).Width = 2 * 1440;
sb.Sheets[0].Columns(1).Width = 1440;
sb.Sheets[0].Columns(2).Width = 1440;
sb.Sheets[0].Rows(0).Height = 1440 / 4;
  
// Header row
sb.Sheets[0].Cell(0,0).SetValue("Company Name");
sb.Sheets[0].Cell(0,0).FontBold = true;
sb.Sheets[0].Cell(0,1).SetValue("Contact Name");
sb.Sheets[0].Cell(0,1).FontBold = true;
sb.Sheets[0].Cell(0,2).SetValue("Phone");
sb.Sheets[0].Cell(0,2).FontBold = true;
  
// First row of data
sb.Sheets[0].Cell(1,0).SetValue("GrapeCity");
sb.Sheets[0].Cell(1,1).SetValue("Mortimer");
sb.Sheets[0].Cell(1,2).SetValue("(425) 880-2601");
  
// Save the Workbook to an Excel file
sb.Save("test.xls");

See also

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 was computed. 
.NET Framework net461 was computed.  net462 is compatible.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (12)

Showing the top 5 NuGet packages that depend on GrapeCity.ActiveReports.SpreadBuilder:

Package Downloads
GrapeCity.ActiveReports.Export.Excel

ActiveReports is a set of assemblies that enable you to create, render, print, and export reports in a .NET or .NET Core application. This package includes the core engine assemblies required to create and render pixel perfect, WYSIWYG, reports.

GrapeCity.ActiveReports.Export.Word

ActiveReports is a set of assemblies that enable you to create, render, print, and export reports in a .NET or .NET Core application. This package includes the core engine assemblies required to create and render pixel perfect, WYSIWYG, reports.

GrapeCity.ActiveReports.Web.Viewer

ActiveReports is a set of assemblies that enable you to create, render, print, and export reports in a .NET or .NET Core application. This package includes assemblies needed to display reports in report viewers. Multiple viewers are included for your convenience. Among them are viewers for Windows Forms, WPF, ASP.NET, Blazor, and JavaScript. These viewers are customizable and include printing and exporting features.

GrapeCity.ActiveReports.Web

ActiveReports is a set of assemblies that enable you to create, render, print, and export reports in a .NET or .NET Core application. This package includes assemblies needed to display reports in report viewers. Multiple viewers are included for your convenience. Among them are viewers for Windows Forms, WPF, ASP.NET, Blazor, and JavaScript. These viewers are customizable and include printing and exporting features.

GrapeCity.ActiveReports.Aspnet.Viewer

ActiveReports is a set of assemblies that enable you to create, render, print, and export reports in a .NET or .NET Core application. This package includes assemblies needed to display reports in report viewers. Multiple viewers are included for your convenience. Among them are viewers for Windows Forms, WPF, ASP.NET, Blazor, and JavaScript. These viewers are customizable and include printing and exporting features.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
2.1.0 1,225 2/28/2024
2.0.0 81,049 1/23/2023
1.0.4 36,874 10/10/2022
1.0.2 48,347 5/19/2022
1.0.1 36,168 1/17/2022