从excel中读取时间

最新推荐文章于 2024-07-10 09:50:01 发布

nyoj_lvy

最新推荐文章于 2024-07-10 09:50:01 发布

阅读量642

点赞数

分类专栏： Groovy基础文章标签： excel

本文链接：https://blog.csdn.net/u013803499/article/details/54585327

版权

Groovy基础专栏收录该内容

10 篇文章 0 订阅

订阅专栏

package com.cheche365.cheche.core.model

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

/**
 * Created by Chenqc on 2017/1/17.
 */
class Festival {

    private final static String FILE_NAME = "节假日.xls"
    public static List<String> FESTIVAL_DATE = new ArrayList<>();

    static {

        FileInputStream fis = new FileInputStream('C:\\Users\\Administrator\\Desktop\\' + FILE_NAME)
        HSSFWorkbook hssfWorkbook = new HSSFWorkbook(fis)
        HSSFSheet sheet = hssfWorkbook.getSheetAt(0)
        1.upto(sheet.lastRowNum) {
            HSSFRow row = sheet.getRow(it)

            HSSFCell cell = row.getCell(0)
            if (cell != null) {
                FESTIVAL_DATE.add(cell.getStringCellValue())
            }
        }
    }

    public Festival() {

    }


    public static void main(String[] args) {
        println FESTIVAL_DATE
    }
}