一、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 {
//获取本地的excel
public 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());
}
}
}