3.75 out of 5
3.75
2 reviews on Udemy

Apache POI tutorial

Java + Apache POI
Instructor:
Vitalii Serdiuk
20 students enrolled
English [Auto-generated]
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.

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.

Intro

1
Intro

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.

Short theoretical introduction

1
XLS vs XLSX
2
Dependencies

Course

1
1 - Creating an empty .xls file

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.

2
2 - Creating an empty .xlsx file

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.

3
3 - Adding data to .xlsx file

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

4
4 - Adding simple formatting to .xlsx file

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.

5
5 - Adding an autofilter to .xlsx file

The lecture shows how to add an autofilter

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

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

7
7 - Format as table

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.

8
8 - Set sheet active

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.

9
9 - Hide sheet

The lecture shows how hide a sheet

10
10 - Protect sheet with password

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.

11
11 - Hide columns

The lecture shows how to hide columns

12
12 - Hide row

The lecture shows how to hide row

13
13 - Merge cells

The lecture shows how to merge cells

14
14 - Add formula to cell

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

15
15 - Create chart

The lecture shows how to create a line chart

16
16 - Register formula

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

17
17 - Get value from formula

The lecture shows how to get formula value

18
18 - CSV to XLSX

The lecture shows how to convert .csv to .xlsx

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
3.8
3.8 out of 5
2 Ratings

Detailed Rating

Stars 5
0
Stars 4
1
Stars 3
1
Stars 2
0
Stars 1
0
1442ab7fcc209d70f5dc6c68b79d2e49
30-Day Money-Back Guarantee

Includes

1 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion