Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
- import org.apache.poi.ss.usermodel.*;
- import java.io.File;
- import java.io.IOException;
- import java.util.Iterator;
- public class ExcelReader {
- public static final String XLSX_FILE_PATH = "./arquivo-excel.xlsx";
- public static void main(String[] args) throws IOException, InvalidFormatException {
- //Criando um Workbook de Uma Arquivo Excel (.xlsx ou .xls)
- Workbook workbook = WorkbookFactory.create(new File(XLSX_FILE_PATH));
- //Visualizando Todas as Sheets presentes na planilha
- for(Sheet sheet: workbook) {
- System.out.println("=> " + sheet.getSheetName());
- }
- // Visualizando os valores das células da primeira aba da planilha
- Sheet sheet = workbook.getSheetAt(0);
- for (Row row: sheet) {
- for(Cell cell: row) {
- String cellValue = dataFormatter.formatCellValue(cell);
- System.out.print(cellValue + "t");
- }
- System.out.println();
- }
- workbook.close();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement