Videos Home / GrapeCity Documents Channel

How to Add Sparklines to a .NET Spreadsheet | Documents for Excel, .NET Edition

How to Add Sparklines to a .NET Spreadsheet | Documents for Excel, .NET Edition

Posted on 1/4/2019 4:46:21 PM

GrapeCity Documents for Excel, .NET Edition, is a fast, efficient spreadsheet API that enables you to generate, load, modify, and save spreadsheets.

In this video, we’ll add sparklines to a set of data in your .NET spreadsheet.

Import the necessary namespaces.

Then initialize the workbook.

Next, we’ll add our data and assign it to a range in the worksheet.

Next, create a table and add the range of data to the table.

Add a formula to sum up the columns.

Add a sparkline to column K. Specify the sparkline type and pass along the source data.

Finally, save the workbook. When we open the spreadsheet, we’ll see that the sparklines have been added in column K.

With GcExcel, you can command total control of your spreadsheets—with no dependencies on Excel.

If you have a comment or question about this tutorial, please leave your comments in the thread below.

Learn more:
https://www.grapecity.com/en/documents-api-excel

Related Videos

How to Programmatically Add Graphical Signatures to PDF Files Using JavaScript

11/17/2022 3:28:17 PM

Learn how to use GrapeCity Documents JavaScript PDF Viewer to add graphical signatures to your documents. This tutorial will show how to programmatically add PDF signatures to your web applications. ...

New Annotation and Form Designer Tools

11/17/2022 4:51:24 PM

In this video, GcPdfViewer introduces new annotations and form editor tools to work with PDF documents....

How to Edit PDF in Collaboration Mode Using a JavaScript PDF Viewer

11/17/2022 4:51:59 PM

Learn how to edit PDF documents in collaboration mode using a JavaScript PDF Viewer component from GrapeCity Documents. Our JavaScript viewer and .NET PDF API allow you to make the most of your PDF do...

How to Use GcWord Report Templates to Automate Document Creation

11/17/2022 5:02:34 PM

In this video, we will present a step-by-step guide to binding report templates created in Microsoft Word with data to generate reports using the GcWord Report Templates feature....

How to Convert HTML to a PDF | GrapeCity Documents for PDF

11/21/2022 8:08:06 PM

GcHTML is a package available with GcPdf and GcImaging products. This allows the conversion of HTML content to PDFs and Images. In this video, we’ll convert an HTML file to PDF using GcPdf....

How to Export a Spreadsheet to a PDF | Documents for Excel, .NET Edition

11/22/2022 4:23:51 PM

GrapeCity Documents for Excel, .NET Edition, is a fast, efficient spreadsheet API that enables you to generate, load, modify, and save spreadsheets in your .NET Standard 2.0 app. With GcExcel, you can...

How to Add a Custom Theme to Your .NET Spreadsheet | Documents for Excel, .NET Edition

11/22/2022 4:24:09 PM

GrapeCity Documents for Excel, .NET Edition, is a fast, efficient spreadsheet API that enables you to generate, load, modify, and save spreadsheets in your .NET Standard 2.0 app. With GcExcel, you can...

How to Add Comments to a .NET Spreadsheet | Documents for Excel, .NET Edition

11/22/2022 5:37:58 PM

GrapeCity Documents for Excel, .NET Edition is a fast, efficient spreadsheet API that enables you to generate, load, modify, and save spreadsheets in your .NET Standard 2.0 app. With GcExcel, you can ...

How to Add a Table to a .NET Spreadsheet | GcExcel Java

11/22/2022 5:38:27 PM

GrapeCity Documents for Excel, Java Edition (GcExcel Java) is a high-speed, feature-rich Excel document API based on VSTO. We released the GcExcel for .NET Version in April, and with this launch it's ...

How to Add a Chart to your Spreadsheet | GcExcel Java

11/22/2022 5:38:40 PM

GrapeCity Documents for Excel, Java Edition (GcExcel Java) is a high-speed, feature-rich Excel document API based on VSTO. We released the GcExcel for .NET Version in April, and with this launch it's ...

How to Add a Pivot Table to your Spreadsheet | GcExcel Java

11/22/2022 5:39:22 PM

GrapeCity Documents for Excel, Java Edition (GcExcel Java) is a high-speed, feature-rich Excel document API based on VSTO. We released the GcExcel for .NET Version in April, and with this launch, it's...

How to Add Sparklines to a Spreadsheet | GcExcel Java

11/22/2022 5:39:35 PM

GrapeCity Documents for Excel, Java Edition (GcExcel Java) is a high-speed, feature-rich Excel document API based on VSTO. We released the GcExcel for .NET Version in April, and with this launch it's ...

How to Auto Filter Data in a Java Spreadsheet Application

11/22/2022 5:39:47 PM

GrapeCity Documents for Excel, Java Edition (GcExcel Java) is a high-speed, feature-rich Excel document API based on VSTO. This video is a step-by-step tutorial on how to automatically filter data in ...

How to Programmatically Convert Word .DOCX to PDF Using .NET C#

11/22/2022 5:58:48 PM

This tutorial will show how to programmatically convert Word .DOCX to PDF in a desktop application. Using a powerful Microsot Word .NET API library from GrapeCity Documents, you will be able to conver...

How to Add Paragraph and Character Formatting | Word API for .NET Standard 2.0.

11/22/2022 5:59:24 PM

In this video, we’ll walk through adding a paragraph of text using GcWord. We’ll also add character formatting to different parts of the paragraph. Make sure you have necessary namespaces included ...

Add Slicer

12/1/2022 7:45:36 PM

Originally Published: 12-06-2018...

How to generate word docs in code

12/1/2022 7:47:11 PM

Originally Published: 12-04-2018...

Add Date Time Fields

12/1/2022 7:52:16 PM

Originally Published: 10-23-2018...

Load, Modify, and Add an Image

12/1/2022 7:54:53 PM

Originally Published: 10-23-2018...

GcExcel, Java Video Proof

12/1/2022 7:56:26 PM

Originally Published: 10-03-2018...

Conditional Formatting

12/8/2022 9:33:31 PM

Originally Published: 12-04-2018...

Using GcDataViewer to View Data Documents (xlsx, csv, json) in an ASP.NET Core Application

12/16/2022 9:02:29 PM

Learn about the powerful new data viewer capabilities of our JavaScript Data Viewer. We will add this viewer functionality to an ASP.NET Core application to view popular data document types such as Ex...

Adding a JavaScript Image Viewer Component to an ASP.NET Core Web Application

12/28/2022 6:40:16 PM

Learn about GCImageViewer, our powerful new JavaScript image viewer component. We will use this new control in Visual Studio 2022 to view and edit image files in an ASP.NET Core web application. The ...

Getting Started with ComponentOne Controls

2/21/2023 7:56:13 PM

Have you recently purchased ComponentOne? Or, just downloaded the latest version and aren't sure where to start? No matter how familiar you are with ComponentOne, this beginner-level training webinar ...

How to Add GrapeCity Documents for Excel, an Excel XLSX API Library, to Your Java App

3/9/2023 6:11:02 PM

In this tutorial, we will show you how to add GrapeCity Documents for Excel (GcExcel), a powerful Excel XLSX API library, to your Java application. Using IntelliJ, GcExcel Java Edition can be used in ...

How to Programmatically Convert HTML to PDF in .NET Core C#

3/10/2023 7:35:01 PM

In this tutorial, learn how to programmatically convert HTML documents to PDF format in your .NET Core C# applications. View the demos: https://www.grapecity.com/documents-api-pdf/demos/html Follow ...

How to Render HTML to PNG, SVG, JPEG, GIF in .NET 6 C# Apps

3/10/2023 9:18:16 PM

Learn how to render HTML in image types using this tutorial. We will show how to display HTL in PNG, SVG, JPEG, GIF. Follow along with the blog: https://www.grapecity.com/blogs/how-to-render-html-to-...