poi如何获取excel里面所有的工作簿
java判断excel有多少列数
java判断excel有多少行数
java获取excel部分数据并创建新的excel文件
package test;
import java.io.*;
import java.util.ArrayList;
import java.util.List;
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;
import org.apache.poi.ss.usermodel.Row;
public class Excel {
public static void main(String[] args) throws IOException {
StringBuffer sb = new StringBuffer();
List<String> list = new ArrayList<>();
FileInputStream inp = new FileInputStream("E:\\testhd\\xxxx\\xxx.xls");
HSSFWorkbook wb = new HSSFWorkbook(inp);
int numberOfSheets = wb.getNumberOfSheets();//获取所有的Sheet
for (int Sheets = 0; Sheets <numberOfSheets ; Sheets++) {
HSSFSheet sheet = wb.getSh