How to Add Sparklines to Your .NET Spreadsheet using GcExcel (Video)

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

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 parse, convert, and share spreadsheets, calculate formulas and format cells, then deploy to Azure and AWS.

In this video, we’ll add sparklines to a set of data in seven easy steps.

Step 1:

Import the necessary namespaces.

Step 2:

Then initialize the workbook.

Step 3:

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

Step 4:

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

Step 5:

Add a formula to sum up the columns.

Step 6:

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

Step 7:

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.

Jody Handley

comments powered by Disqus