一、java使用poi.xssf 写入内容到excel表格中
public class TestExcel {//创建一个excel工作簿public static String outputFile = "C:\\test.xlsx";public static void main(String[] args) {try {XSSFWorkbook workbook = new XSSFWorkbook();XSSFSheet sheet = workbook.createSheet("我是第一张表");XSSFRow row = sheet.createRow(0);XSSFCell cell = row.createCell(0);// 制作样式XSSFCellStyle xssfCellStyle = workbook.createCellStyle();//两种设置颜色的方式xssfCellStyle.setFillBackgroundColor((short)4);//xssfCellStyle.setFillBackgroundColor(IndexedColors.GREEN.getIndex());//设置字体格式XSSFFont font = workbook.createFont();font.setBold(true);font.setColor(IndexedColors.RED1.getIndex());font.setFontName("宋体");//必须加这个 setFillPattern 要不然这里设置的样式不生效xssfCellStyle.setFillPattern(FillPatternType.THIN_VERT_BANDS);//字体格式加到样式里面xssfCellStyle.setFont(font);cell.setCellValue("这是第一个字段");cell.setCellStyle(xssfCellStyle);FileOutputStream fileOutputStream = new FileOutputStream(outputFile);workbook.write(fileOutputStream);fileOutputStream.flush();fileOutputStream.close();}catch (Exception e){System.out.println(e.getMessage());}}}
二、java使用poi.xssf 读取 表格里面的数据
import org.apache.poi.xssf.usermodel.XSSFCell;import org.apache.poi.xssf.usermodel.XSSFRow;import org.apache.poi.xssf.usermodel.XSSFSheet;import org.apache.poi.xssf.usermodel.XSSFWorkbook;import java.io.FileInputStream;public class TestReadContentFromExcel {//获取本地的excelpublic static String filePath = "C:\\test.xlsx";public static void main(String[] args) {try {XSSFWorkbook xssfWorkbook = new XSSFWorkbook(new FileInputStream(filePath));XSSFSheet sheet = xssfWorkbook.getSheetAt(0);XSSFRow row = sheet.getRow(0);XSSFCell cell = row.getCell(0);System.out.println("左上角的值是："+ cell);}catch (Exception e){System.out.println(e.getMessage());}}}
