How to Auto Filter in a Spreadsheet using Java (Video)

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 now possible to use a similar package in Java applications.

This video is a step-by-step tutorial on how to automatically filter data in a spreadsheet using GcExcel Java.

We have data that we need to filter in a spreadsheet. We want the spreadsheet to automatically filter data with any weights less than 72.

Let's see how to do this using GcExcel.

Steps:

1. Initialize the workbook.

2. Get the 0th worksheet in the workbook.

3. Add a range of data that contains the weight column.

4. Set the data to range of cells in worksheet.

5. Set the Auto Filter property of the worksheet range to -- filter 4th column -- with values less than 72.

6. Save the workbook.

7. Run the application. Notice the weight column is filtered less than 72!

If you have any questions or comments, please leave them in the comment thread below!

Happy coding!