poi解析excel遇到的问题

问题一

poi对excel版本问题可用

Workbook workbook;
workbook = WorkbookFactory.create(upload);
Sheet sheet=workbook.getSheetAt(0);

maven 引入以来如下

 <dependency>
		    <groupId>org.apache.poi</groupId>
		    <artifactId>poi</artifactId>
		    <version>3.15</version>
		</dependency>
		
		<dependency>
		    <groupId>org.apache.poi</groupId>
		    <artifactId>poi-ooxml-schemas</artifactId>
		    <version>3.15</version>
		</dependency>
		
		<dependency>
		    <groupId>org.apache.poi</groupId>
		    <artifactId>poi-ooxml</artifactId>
		    <version>3.15</version>
		</dependency>
		
		<dependency>
		    <groupId>org.apache.xmlbeans</groupId>
		    <artifactId>xmlbeans</artifactId>
		    <version>3.0.0</version>
		</dependency>
		
		<dependency>
		    <groupId>com.github.virtuald</groupId>
		    <artifactId>curvesapi</artifactId>
		    <version>1.05</version>
		</dependency>

问题二

poi不能直接解析excel中的纯数字需要把数字转换成字符串

如

Cell numcell=row.getCell(2);
numcell.setCellType(CellType.STRING);
Integer num=Integer.parseInt(numcell.getStringCellValue());

问题三

poi获取excel中的时间

Date time=timeCell.getDateCellValue();