Xử lý tệp là một phần quan trọng của bất kỳ ngôn ngữ lập trình nào. Java cung cấp nhiều phương thức dựng sẵn khác nhau để tạo, đọc, cập nhật và xóa tệp. Các phương thức này được cung cấp bởi lớp Tệp có trong gói java. gói io. Để thực hiện các thao tác với tệp, Java sử dụng lớp luồng
Để thực hiện các thao tác trong trang tính excel bằng JAVA, sẽ rất hữu ích khi sử dụng tệp CSV vì tệp CSV có thể dễ dàng được sử dụng với Microsoft Excel, bảng tính Google và hầu hết tất cả các bảng tính khác có sẵn
Để tự ghi dữ liệu vào bảng excel bằng poi
1. Tạo một sổ làm việc trống
XSSFWorkbook workbook = new XSSFWorkbook[];
2. Tạo một trang tính và đặt tên cho nó.
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];
3. Tạo một hàng
Row row = sheet.createRow[rownum++];
4. Thêm các ô vào trang tính .
5. Lặp lại Các bước 3 và 4 để ghi dữ liệu đầy đủ.
Điều kiện tiên quyết. Thêm tất cả các tệp jar được tải xuống từ trang tải xuống Apache POI trong đường dẫn xây dựng của Chương trình Java.
Ví dụ
Java
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];0
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];1
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];2
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];3
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];2
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];5
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];2
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];0
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];2
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];2
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];2
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];4
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];2
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];6
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];2
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];8
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];2
Row row = sheet.createRow[rownum++];0
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];2
Row row = sheet.createRow[rownum++];2
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];1
Row row = sheet.createRow[rownum++];4
Row row = sheet.createRow[rownum++];5
Row row = sheet.createRow[rownum++];6
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];1
Row row = sheet.createRow[rownum++];8
Row row = sheet.createRow[rownum++];9
Row row = sheet.createRow[rownum++];8
Row row = sheet.createRow[rownum++];4
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];02
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];03
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];04
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];05
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];06
Row row = sheet.createRow[rownum++];8
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];08
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];09
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];10
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];09
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];12____313
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];14
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];1
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];09
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];17
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];09
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];19
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];20
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];21
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];22
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];23
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];1
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];09
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];26
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];09
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];28
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];1
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];09
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];31
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];09
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];33
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];20
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];35
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];13
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];37
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];1
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];09
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];20
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];20
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];22
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];23
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];20
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];13
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];26_______327
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];23
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];29
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];23
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];51
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];52
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];1
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];09
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];20______356
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];23
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];13
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];26______320
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];23
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];22
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];23
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];24
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];25
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];52
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];1
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];09
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];20
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];20
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];01
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];23
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];20
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];13
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];26_______106
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];23
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];08
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];23
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];25
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];52
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];1
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];09
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];20
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];15
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];23
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];13
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];26
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];19
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];23
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];21
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];23
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];24
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];25
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];52
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];1
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];09
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];20_______129
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];23
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];13
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];26
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];33
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];23
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];35
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];23
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];24
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];25
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];52
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];1
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];09
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];20_______143
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];23
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];13
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];26____147
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];23
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];49
XSSFSheet spreadsheet = workbook.createSheet[" Student Data "];23