Documents for Excel, Java Edition | How to Add a Pivot Table to a Spreadsheet

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 2018, and with this launch, it's now possible to use a similar package in Java applications.

In this video, we’ll add a table to a spreadsheet.

You can add a table structure on data using built-in styling, or your own custom styles. Suppose you want to calculate the total row count in a table, and the average weight.

Let’s see do this with GcExcel.

Step 1:

Initialize the workbook.

Step 2:

Add a range of data.

Step 3:

Add the data to the worksheet.

Step 4:

Set the table over the range of data.

Step 5:

Set formulas over the table to calculate total rows count and average weight.

Step 6:

Save the workbook and run the application.

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.

Custom Code Your Spreadsheets in Java

Download the latest version of GrapeCity Documents for Excel, Java Edition

Download Now!