Apache POI tutorial
4.0 (2 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
15 students enrolled

Apache POI tutorial

Java + Apache POI
4.0 (2 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
15 students enrolled
Created by Vitalii Serdiuk
Last updated 9/2018
English
English [Auto-generated]
Current price: $11.99 Original price: $29.99 Discount: 60% off
3 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • The course describes how to use the Apache POI for creating the .xls or .xlsx file, adding data to the Excel file, adding formatting (lines, phones, background color, table style) to the Excel file, evaluating formulas and building charts.
Requirements
  • Java core
Description

The course shows the basics of using the Apache POI. During the course you will find information how to create .xls or .xlsx file, how to add data to Excel file, how to add formatting (font, background, border, table style), how to manage sheets (make sheet active, hide sheet, protect sheet with the password), how to add formula to a cell, how to get value from cell formula value, how to create chart, how to convert .csv file to .xlsx file.

Who this course is for:
  • The course is for developers who have no experience with the Apache POI.
Course content
Expand all 21 lectures 59:59
+ Intro
1 lecture 00:58

The Apache POI is a great tool for Java developers for simple work with Excel files. You will learn how to create .xls or .xlsx file, how to add data to Excel file, how to add formatting (style, font, background, border), how to execute formulas, how to create a chart, how to convert .csv file to .xlsx file.

Preview 00:58
+ Course
18 lectures 56:21

The lecture shows how to create a simple .xls file (demo.xls). The file is empty and has a single sheet with the name Tab1.

Preview 01:55

The lecture shows how to create a simple .xlsx file (demo.xlsx). The file is empty and has a single sheet with the name Tab1.

Preview 01:13

The lecture shows how to add data to an Excel (.xlsx) file.

Preview 05:54

The lecture shows how to add a simple formatting (font style, font size, font color, cell background color, border, border color, auto zooming) to a .xlsx file.

4 - Adding simple formatting to .xlsx file
07:09

The lecture shows how to add an autofilter

5 - Adding an autofilter to .xlsx file
02:07

The lecture shows how to add custom formatting for date and phone number cells

6 - Adding custom formatting for text, date, phone number cells
04:54

The Excel has a list of built-in table styles. All you need in excel is to use Format as table feature. The project shows how to format as a table with the Apache Poi.

7 - Format as table
07:05

From time to time there is a need to make an excel sheet active. By default when you open the .xlsx file the first sheet is open. The apache poi provides a possibility to make a sheet active. And it could be any sheet.

8 - Set sheet active
01:08

The lecture shows how hide a sheet

9 - Hide sheet
01:00

The apache poi provides the protect sheet feature. The goal of the feature is to reject users from accidentally or deliberately changing, moving, or deleting data in a worksheet, you can protect it with a password.

10 - Protect sheet with password
01:35

The lecture shows how to hide columns

11 - Hide columns
00:57

The lecture shows how to hide row

12 - Hide row
00:53

The lecture shows how to merge cells

13 - Merge cells
03:53

The Excel formulas is a powerful tool for manage data in the workbook. The lecture shows how to add formula to a cell.

14 - Add formula to cell
05:13

The lecture shows how to create a line chart

15 - Create chart
04:42

The lecture shows how to register formula if formula is not supported by the Apache Poi

16 - Register formula
03:49

The lecture shows how to get formula value

17 - Get value from formula
01:40

The lecture shows how to convert .csv to .xlsx

18 - CSV to XLSX
01:14