當麻許的碎念筆記

HSSFWorkbook workbook;

//讀取專案內中的sample.xls 的excel 檔案

using (FileStream file = new FileStream(AppDomain.CurrentDomain.BaseDirectory + "sample.xls", FileMode.Open, FileAccess.Read))

{

    workbook = new HSSFWorkbook(file);

}

//讀取Sheet1 工作表

var  sheet = workbook.GetSheet("Sheet1");

for (int row = 0; row <= sheet.LastRowNum; row++)

{

    if (sheet.GetRow(row) != null) //null is when the row only contains empty cells 

    {

        foreach (var c in sheet.GetRow(row).Cells)

        {

            //如果是數字型 就要取 NumericCellValue  這屬性的值

            if(c.CellType==CellType.NUMERIC)

                Response.Write(c.NumericCellValue.ToString("#"));

            //如果是字串型 就要取 StringCellValue  這屬性的值

            if(c.CellType==CellType.STRING)

                Response.Write(c.StringCellValue);

            //每個欄中間加上逗點

            Response.Write(",");

        }

        //每一行補上換行

        Response.Write("<br />");

    }

}