package lessons;

import java.io.File;
import java.io.IOException;

import jxl.BooleanCell;
import jxl.Cell;
import jxl.CellType;
import jxl.DateCell;
import jxl.LabelCell;
import jxl.NumberCell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

/**
 * @author 北京-宏哥
 * 
 * @公眾號:北京宏哥
 * 
 * 《手把手教你》系列技巧篇（六十八）-java+ selenium自動化測試 - 讀寫excel文件 -下篇（詳細教程） 
 *
 * 2022年2月15日
 */

public class OperateExcle {
    
    public static void main(String[] args) {     
        //從指定位置的文件創建工作簿對象；根據計算機上的位置更改文件的路徑。
        Workbook wrk1;
        try {
        
            wrk1 = Workbook.getWorkbook(new File(".\\Files\\test-data1.xls"));

            //獲取工作簿中第一個工作表的引用
            Sheet sheet1 = wrk1.getSheet(0);

           //使用工作表的getCel(int col, int row)方法獲取對單元的引用
            Cell cell1 = sheet1.getCell(0, 0);
            Cell cell2 = sheet1.getCell(1, 0);
            Cell cell3 = sheet1.getCell(2, 0);
            Cell cell4 = sheet1.getCell(3, 0);

            DateCell dCell = null;
            NumberCell nCell = null;
            BooleanCell bCell = null;
            LabelCell lCell = null;

            // 檢查單元格內容的類型，並將該對象轉換為適當的引用類型
            if (cell1.getType() == CellType.DATE)
                dCell = (DateCell) cell1;

            if (cell2.getType() == CellType.NUMBER)
                nCell = (NumberCell) cell2;

            if (cell3.getType() == CellType.BOOLEAN)
                bCell = (BooleanCell) cell3;

            if (cell4.getType() == CellType.LABEL)
                lCell = (LabelCell) cell4;

            // 顯示單元格內容
            System.out.println("Value of Date Cell is: " + dCell.getDate());
            System.out.println("Value of Number Cell is: " + nCell.getValue());
            System.out.println("Value of Boolean Cell is: " + bCell.getValue());
            System.out.println("Value of Label Cell is: " + lCell.getString());

        } catch (BiffException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }

    }


}

package lessons;

import java.io.File;
import java.io.FileInputStream;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

/**
 * @author 北京-宏哥
 * 
 * @公眾號:北京宏哥
 * 
 * 《手把手教你》系列技巧篇（六十八）-java+ selenium自動化測試 - 讀寫excel文件 -下篇（詳細教程） 
 *
 * 2022年2月15日
 */
public class ReadDiffExcle {

    public static void main(String[] args) { 
        File f = new File(".\\Files\\test-data1.xls"); 
        try { 
                FileInputStream is = new FileInputStream(f); 
                @SuppressWarnings("resource")
                HSSFWorkbook wbs = new HSSFWorkbook(is); 
                HSSFSheet childSheet = wbs.getSheetAt(0); 
                // System.out.println(childSheet.getPhysicalNumberOfRows()); 
                System.out.println("有行數" + childSheet.getLastRowNum()); 
                for (int j = 0; j < childSheet.getLastRowNum(); j++) { 
                        HSSFRow row = childSheet.getRow(j); 
                        // System.out.println(row.getPhysicalNumberOfCells()); 
                        // System.out.println("有列數" + row.getLastCellNum()); 
                        if (null != row) { 
                                for (int k = 0; k < row.getLastCellNum(); k++) { 
                                        HSSFCell cell = row.getCell(k); 
                                        if (null != cell) { 
                                                switch (cell.getCellType()) { 
                                                case NUMERIC: // 數字 
                                                        System.out.print(cell.getNumericCellValue() 
                                                                        + "   "); 
                                                        break; 
                                                case STRING: // 字符串 
                                                        System.out.print(cell.getStringCellValue() 
                                                                        + "   "); 
                                                        break; 
                                                case BOOLEAN: // Boolean 
                                                        System.out.print(cell.getBooleanCellValue() 
                                                                        + "   "); 
                                                        break; 
                                                case FORMULA: // 公式 
                                                        System.out.print(cell.getCellFormula() + "   "); 
                                                        break; 
                                                case BLANK: // 空值 
                                                        System.out.print(" "); 
                                                        break; 
                                                case ERROR: // 故障 
                                                        System.out.print(" "); 
                                                        break; 
                                                default: 
                                                        System.out.print("未知類型   "); 
                                                        break; 
                                                } 
                                        } else { 
                                                System.out.print("-   "); 
                                        } 
                                } 
                        } 
                        System.out.println(); 
                } 
        } catch (Exception e) { 
                e.printStackTrace(); 
        } 
} 

}