POI操作Excel文档

POI操作Excel文档－基础篇（转）关键字: poi一．POI简介Jakarta POI 是apache的子项目，目标是处理ole2对象。

它提供了一组操纵Windows文档的Ja目前比较成熟的是HSSF接口，处理MS Excel（97-2002）对象。

它不象我们仅仅是用csv生成的没式的可以由Excel转换的东西，而是真正的Excel对象，你可以控制一些属性如sheet,cell等等二．HSSF概况HSSF 是Horrible SpreadSheet Format的缩写，也即“讨厌的电子表格格式”。

也许HSSF的名字滑稽，就本质而言它是一个非常严肃、正规的API。

通过HSSF，你可以用纯Java代码来读取、写入改Excel文件。

HSSF 为读取操作提供了两类API：usermodel和eventusermodel，即“用户模型”和“事件-用户模前者很好理解，后者比较抽象，但操作效率要高得多。

三．开始编码1 ．准备工作要求:JDK 1.4+POI开发包可以到 /dyn/closer.cgi/jakarta/poi/ 最新的POI工具包2 ． EXCEL 结构HSSFWorkbook excell 文档对象介绍HSSFSheet excell的表单HSSFRow excell的行HSSFCell excell的格子单元HSSFFont excell字体HSSFName 名称HSSFDataFormat 日期格式在poi1.7中才有以下2项：HSSFHeader sheet头HSSFFooter sheet尾和这个样式HSSFCellStyle cell样式辅助操作包括HSSFDateUtil 日期HSSFPrintSetup 打印HSSFErrorConstants 错误信息表3 ．具体用法实例（采用 usermodel ）如何读Excel读取Excel文件时，首先生成一个POIFSFileSystem对象，由POIFSFileSystem对象构造一个HSSFWorkbook，该HSSFWorkbook对象就代表了Excel文档。

下面代码读取上面生成的Excel文件写消息字串：代码1.POIFSFileSystem fs=newPOIFSFileSystem(new FileInputStream("d:\test.xls"));2.HSSFWorkbook wb = new HSSFWorkbook(fs);3.} catch (IOException e) {4. e.printStackTrace();5.}6.HSSFSheet sheet = wb.getSheetAt(0);7.HSSFRow row = sheet.getRow(0);8.HSSFCell cell = row.getCell((short) 0);9.String msg = cell.getStringCellValue();如何写excel，将excel的第一个表单第一行的第一个单元格的值写成“a test”。

代码1.POIFSFileSystem fs =new POIFSFileSystem(new FileInputStream("workbook.xls"));2.3. HSSFWorkbook wb = new HSSFWorkbook(fs);4.5. HSSFSheet sheet = wb.getSheetAt(0);6.7. HSSFRow row = sheet.getRow(0);8.9. HSSFCell cell = row.getCell((short)0);10.11. cell.setCellValue("a test");12.13. // Write the output to a file14.15. FileOutputStream fileOut = new FileOutputStream("workbook.xls");16.17. wb.write(fileOut);18.19.fileOut.close();4 ．可参考文档POI 主页：/poi/，初学者如何快速上手使用POI HSSF/poi/hssf/quick-guide.html 。

代码例子 /user1/6749/archives/2005/18347.html里面有很多例子代码，可以很方便上手。

四．使用心得POI HSSF 的usermodel包把Excel文件映射成我们熟悉的结构，诸如Workbook、Sheet、Row、Ce 它把整个结构以一组对象的形式保存在内存之中，便于理解，操作方便，基本上能够满足我们的要所以说这个一个不错的选择。

POI操作Excel文档－中级篇（转）1、遍历workbook代码1.// load源文件2.POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(filePath));3.HSSFWorkbook wb = new HSSFWorkbook(fs);4.for (int i = 0; i < wb.getNumberOfSheets(); i++) {5. HSSFSheet sheet = wb.getSheetAt(i);6. for (int i = sheet.getFirstRowNum(); i < sheet.getLastRowNum(); i ++) {7. HSSFRow row = sheet.getRow(i);8. if (row != null) {9.。

操作}10. }11. }12.// 目标文件13.FileOutputStream fos = new FileOutputStream(objectPath);14.//写文件15.swb.write(fos);16.fos.close();2、得到列和单元格代码1.HSSFRow row = sheet.getRow(i);2.HSSFCell cell = row.getCell((short) j);3、设置sheet名称和单元格内容为中文代码1.wb.setSheetName(n, "中文",HSSFCell.ENCODING_UTF_16);2.cell.setEncoding((short) 1);3.cell.setCellValue("中文");4、单元格内容未公式或数值，可以这样读写代码1.cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);2.cell.getNumericCellValue()5、设置列宽、行高代码1.sheet.setColumnWidth((short)column,(short)width);2.row.setHeight((short)height);6、添加区域，合并单元格代码1.Region region = new Region((short)rowFrom,(short)columnFrom,(short)rowTo,(short2.sheet.addMergedRegion(region);3.//得到所有区域4.sheet.getNumMergedRegions()7、常用方法根据单元格不同属性返回字符串数值代码1.public String getCellStringValue(HSSFCell cell) {2. String cellValue = "";3. switch (cell.getCellType()) {4. case HSSFCell.CELL_TYPE_STRING:5. cellValue = cell.getStringCellValue();6. if(cellValue.trim().equals("")||cellValue.trim().length()<=0)7. cellValue=" ";8. break;9. case HSSFCell.CELL_TYPE_NUMERIC:10. cellValue = String.valueOf(cell.getNumericCellValue());11. break;12. case HSSFCell.CELL_TYPE_FORMULA:13. cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);14. cellValue = String.valueOf(cell.getNumericCellValue());15. break;16. case HSSFCell.CELL_TYPE_BLANK:17. cellValue=" ";18. break;19. case HSSFCell.CELL_TYPE_BOOLEAN:20. break;21. case HSSFCell.CELL_TYPE_ERROR:22. break;23. default:24. break;25. }26. return cellValue;27. }8、常用单元格边框格式虚线HSSFCellStyle.BORDER_DOTTED实线HSSFCellStyle.BORDER_THIN代码1.public static HSSFCellStyle getCellStyle(short type)2. {3. HSSFWorkbook wb = new HSSFWorkbook();4. HSSFCellStyle style = wb.createCellStyle();5. style.setBorderBottom(type);//下边框6. style.setBorderLeft(type);//左边框7. style.setBorderRight(type);//右边框8. style.setBorderTop(type);//上边框9. return style;10. }9、设置字体和内容位置代码1.HSSFFont f = wb.createFont();2. f.setFontHeightInPoints((short) 11);//字号3. f.setBoldweight(HSSFFont.BOLDWEIGHT_NORMAL);//加粗4.style.setFont(f);5.style.setAlignment(HSSFCellStyle.ALIGN_CENTER);//左右居中6.style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);//上下居中7.style.setRotation(short rotation);//单元格内容的旋转的角度8.HSSFDataFormat df = wb.createDataFormat();9.style1.setDataFormat(df.getFormat("0.00%"));//设置单元格数据格式10.cell.setCellFormula(string);//给单元格设公式11.style.setRotation(short rotation);//单元格内容的旋转的角度12.cell.setCellStyle(style);10、插入图片论坛里看到的代码1.//先把读进来的图片放到一个ByteArrayOutputStream中，以便产生ByteArray2. ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();3. BufferedImage bufferImg = ImageIO.read(new File("ok.jpg"));4. ImageIO.write(bufferImg,"jpg",byteArrayOut);5.//读进一个excel模版6.FileInputStream fos = new FileInputStream(filePathName+"/stencil.xlt");7.fs = new POIFSFileSystem(fos);8.//创建一个工作薄9.HSSFWorkbook wb = new HSSFWorkbook(fs);10.HSSFSheet sheet = wb.getSheetAt(0);11.HSSFPatriarch patriarch = sheet.createDrawingPatriarch();12.HSSFClientAnchor anchor = new HSSFClientAnchor(0,0,1023,255,(short) 0,0,(short)13.patriarch.createPicture(anchor , wb.addPicture(byteArrayOut.toByteArray(),HSSFWPOI Excel整理(转)1.创建工作簿 (WORKBOOK)HSSFWorkbook wb = new HSSFWorkbook();FileOutputStream fileOut = new FileOutputStream("workbook.xls");wb.write(fileOut);fileOut.close();2.创建工作表（SHEET）HSSFWorkbook wb = new HSSFWorkbook();HSSFSheet sheet1 = wb.createSheet("new sheet");HSSFSheet sheet2 = wb.createSheet("second sheet");FileOutputStream fileOut = new FileOutputStream("workbook.xls");wb.write(fileOut);fileOut.close();3.创建单元格(CELL)HSSFWorkbook wb = new HSSFWorkbook();HSSFSheet sheet = wb.createSheet("new sheet");// Create a row and put some cells in it. Rows are 0 based.HSSFRow row = sheet.createRow((short)0);// Create a cell and put a value in it.HSSFCell cell = row.createCell((short)0);cell.setCellValue(1);// Or do it on one line.row.createCell((short)1).setCellValue(1.2);row.createCell((short)2).setCellValue("This is a string");row.createCell((short)3).setCellValue(true);// Write the output to a fileFileOutputStream fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut);fileOut.close();4.创建指定单元格式的单元格HSSFWorkbook wb = new HSSFWorkbook();HSSFSheet sheet = wb.createSheet("new sheet");// Create a row and put some cells in it. Rows are 0 based.HSSFRow row = sheet.createRow((short)0);// Create a cell and put a date value in it. The first cell is not styled// as a date.HSSFCell cell = row.createCell((short)0);cell.setCellValue(new Date());// we style the second cell as a date (and time). It is important to// create a new cell style from the workbook otherwise you can end up// modifying the built in style and effecting not only this cell but other cells.HSSFCellStyle cellStyle = wb.createCellStyle();cellStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("m/d/yy h:mm"));cell = row.createCell((short)1);cell.setCellValue(new Date());cell.setCellStyle(cellStyle);// Write the output to a fileFileOutputStream fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut);fileOut.close();5. 单元格的不同格式HSSFWorkbook wb = new HSSFWorkbook();HSSFSheet sheet = wb.createSheet("new sheet");HSSFRow row = sheet.createRow((short)2);row.createCell((short) 0).setCellValue(1.1);row.createCell((short) 1).setCellValue(new Date());row.createCell((short) 2).setCellValue("a string");row.createCell((short) 3).setCellValue(true);row.createCell((short) 4).setCellType(HSSFCell.CELL_TYPE_ERROR); // Write the output to a fileFileOutputStream fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut);fileOut.close();6.单元格的不通对齐方式public static void main(String[] args)throws IOException{HSSFWorkbook wb = new HSSFWorkbook();HSSFSheet sheet = wb.createSheet("new sheet");HSSFRow row = sheet.createRow((short) 2);createCell(wb, row, (short) 0, HSSFCellStyle.ALIGN_CENTER);createCell(wb, row, (short) 1,HSSFCellStyle.ALIGN_CENTER_SELECTION);createCell(wb, row, (short) 2, HSSFCellStyle.ALIGN_FILL);createCell(wb, row, (short) 3, HSSFCellStyle.ALIGN_GENERAL); createCell(wb, row, (short) 4, HSSFCellStyle.ALIGN_JUSTIFY); createCell(wb, row, (short) 5, HSSFCellStyle.ALIGN_LEFT);createCell(wb, row, (short) 6, HSSFCellStyle.ALIGN_RIGHT);// Write the output to a fileFileOutputStream fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut);fileOut.close();}/*** Creates a cell and aligns it a certain way.** @param wb the workbook* @param row the row to create the cell in* @param column the column number to create the cell in* @param align the alignment for the cell.*/private static void createCell(HSSFWorkbook wb, HSSFRow row, short column, short align){HSSFCell cell = row.createCell(column);cell.setCellValue("Align It");HSSFCellStyle cellStyle = wb.createCellStyle();cellStyle.setAlignment(align);cell.setCellStyle(cellStyle);}7.单元格的边框设置Working with bordersHSSFWorkbook wb = new HSSFWorkbook();HSSFSheet sheet = wb.createSheet("new sheet");// Create a row and put some cells in it. Rows are 0 based.HSSFRow row = sheet.createRow((short) 1);// Create a cell and put a value in it.HSSFCell cell = row.createCell((short) 1);cell.setCellValue(4);// Style the cell with borders all around.HSSFCellStyle style = wb.createCellStyle();style.setBorderBottom(HSSFCellStyle.BORDER_THIN);style.setBottomBorderColor(HSSFColor.BLACK.index);style.setBorderLeft(HSSFCellStyle.BORDER_THIN);style.setLeftBorderColor(HSSFColor.GREEN.index);style.setBorderRight(HSSFCellStyle.BORDER_THIN);style.setRightBorderColor(HSSFColor.BLUE.index);style.setBorderTop(HSSFCellStyle.BORDER_MEDIUM_DASHED);style.setTopBorderColor(HSSFColor.BLACK.index);cell.setCellStyle(style);// Write the output to a fileFileOutputStream fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut);fileOut.close();8.填充和颜色设置HSSFWorkbook wb = new HSSFWorkbook();HSSFSheet sheet = wb.createSheet("new sheet");// Create a row and put some cells in it. Rows are 0 based.HSSFRow row = sheet.createRow((short) 1);// Aqua backgroundHSSFCellStyle style = wb.createCellStyle();style.setFillBackgroundColor(HSSFColor.AQUA.index);style.setFillPattern(HSSFCellStyle.BIG_SPOTS);HSSFCell cell = row.createCell((short) 1);cell.setCellValue("X");cell.setCellStyle(style);// Orange "foreground", foreground being the fill foreground not the font color.style = wb.createCellStyle();style.setFillForegroundColor(HSSFColor.ORANGE.index);style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);cell = row.createCell((short) 2);cell.setCellValue("X");cell.setCellStyle(style);// Write the output to a fileFileOutputStream fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut);fileOut.close();9.合并单元格操作HSSFWorkbook wb = new HSSFWorkbook();HSSFSheet sheet = wb.createSheet("new sheet");HSSFRow row = sheet.createRow((short) 1);HSSFCell cell = row.createCell((short) 1);cell.setCellValue("This is a test of merging");sheet.addMergedRegion(new Region(1,(short)1,1,(short)2));// Write the output to a fileFileOutputStream fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut);fileOut.close();10.字体设置HSSFWorkbook wb = new HSSFWorkbook();HSSFSheet sheet = wb.createSheet("new sheet");// Create a row and put some cells in it. Rows are 0 based.HSSFRow row = sheet.createRow((short) 1);// Create a new font and alter it.HSSFFont font = wb.createFont();font.setFontHeightInPoints((short)24);font.setFontName("Courier New");font.setItalic(true);font.setStrikeout(true);// Fonts are set into a style so create a new one to use.HSSFCellStyle style = wb.createCellStyle();style.setFont(font);// Create a cell and put a value in it.HSSFCell cell = row.createCell((short) 1);cell.setCellValue("This is a test of fonts");cell.setCellStyle(style);// Write the output to a fileFileOutputStream fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut);fileOut.close();11.自定义颜色HSSFWorkbook wb = new HSSFWorkbook();HSSFSheet sheet = wb.createSheet();HSSFRow row = sheet.createRow((short) 0);HSSFCell cell = row.createCell((short) 0);cell.setCellValue("Default Palette");//apply some colors from the standard palette,// as in the previous examples.//we'll use red text on a lime backgroundHSSFCellStyle style = wb.createCellStyle();style.setFillForegroundColor(HSSFColor.LIME.index);style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);HSSFFont font = wb.createFont();font.setColor(HSSFColor.RED.index);style.setFont(font);cell.setCellStyle(style);//save with the default paletteFileOutputStream out = new FileOutputStream("default_palette.xls"); wb.write(out);out.close();//now, let's replace RED and LIME in the palette// with a more attractive combination// (lovingly borrowed from )cell.setCellValue("Modified Palette");//creating a custom palette for the workbookHSSFPalette palette = wb.getCustomPalette();//replacing the standard red with redpalette.setColorAtIndex(HSSFColor.RED.index,(byte) 153, //RGB red (0-255)(byte) 0, //RGB green(byte) 0 //RGB blue);//replacing lime with goldpalette.setColorAtIndex(HSSFColor.LIME.index, (byte) 255, (byte) 204, (byte) 102);//save with the modified palette// note that wherever we have previously used RED or LIME, the// new colors magically appearout = new FileOutputStream("modified_palette.xls");wb.write(out);out.close();12.读和重写EXCEL文件POIFSFileSystem fs =new POIFSFileSystem(new FileInputStream("workbook.xls")); HSSFWorkbook wb = new HSSFWorkbook(fs);HSSFSheet sheet = wb.getSheetAt(0);HSSFRow row = sheet.getRow(2);HSSFCell cell = row.getCell((short)3);if (cell == null)cell = row.createCell((short)3);cell.setCellType(HSSFCell.CELL_TYPE_STRING);cell.setCellValue("a test");// Write the output to a fileFileOutputStream fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut);fileOut.close();13.在EXCEL单元格中使用自动换行HSSFWorkbook wb = new HSSFWorkbook();HSSFSheet s = wb.createSheet();HSSFRow r = null;HSSFCell c = null;HSSFCellStyle cs = wb.createCellStyle();HSSFFont f = wb.createFont();HSSFFont f2 = wb.createFont();cs = wb.createCellStyle();cs.setFont( f2 );//Word Wrap MUST be turned oncs.setWrapText( true );r = s.createRow( (short) 2 );r.setHeight( (short) 0x349 );c = r.createCell( (short) 2 );c.setCellType( HSSFCell.CELL_TYPE_STRING );c.setCellValue( "Use \n with word wrap on to create a new line" );c.setCellStyle( cs );s.setColumnWidth( (short) 2, (short) ( ( 50 * 8 ) / ( (double) 1 / 20 ) ) );FileOutputStream fileOut = new FileOutputStream( "workbook.xls" ); wb.write( fileOut );fileOut.close();14.数字格式自定义HSSFWorkbook wb = new HSSFWorkbook();HSSFSheet sheet = wb.createSheet("format sheet");HSSFCellStyle style;HSSFDataFormat format = wb.createDataFormat();HSSFRow row;HSSFCell cell;short rowNum = 0;short colNum = 0;row = sheet.createRow(rowNum++);cell = row.createCell(colNum);cell.setCellValue(11111.25);style = wb.createCellStyle();style.setDataFormat(format.getFormat("0.0"));cell.setCellStyle(style);row = sheet.createRow(rowNum++);cell = row.createCell(colNum);cell.setCellValue(11111.25);style = wb.createCellStyle();style.setDataFormat(format.getFormat("#,##0.0000"));cell.setCellStyle(style);FileOutputStream fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut);fileOut.close();15.调整工作单位置HSSFWorkbook wb = new HSSFWorkbook();HSSFSheet sheet = wb.createSheet("format sheet");HSSFPrintSetup ps = sheet.getPrintSetup();sheet.setAutobreaks(true);ps.setFitHeight((short)1);ps.setFitWidth((short)1);// Create various cells and rows for spreadsheet.FileOutputStream fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut);fileOut.close();16.设置打印区域HSSFWorkbook wb = new HSSFWorkbook();HSSFSheet sheet = wb.createSheet("Sheet1");wb.setPrintArea(0, "$A$1:$C$2");//sets the print area for the first sheet//Alternatively://wb.setPrintArea(0, 0, 1, 0, 0) is equivalent to using the name reference (See the JavaDocs for more details)// Create various cells and rows for spreadsheet.FileOutputStream fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut);fileOut.close();17.标注脚注HSSFWorkbook wb = new HSSFWorkbook();HSSFSheet sheet = wb.createSheet("format sheet");HSSFFooter footer = sheet.getFooter()footer.setRight( "Page " + HSSFFooter.page() + " of " + HSSFFooter.numPages() );// Create various cells and rows for spreadsheet.FileOutputStream fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut);fileOut.close();18.使用方便的内部提供的函数HSSFWorkbook wb = new HSSFWorkbook();HSSFSheet sheet1 = wb.createSheet( "new sheet" );// Create a merged regionHSSFRow row = sheet1.createRow( (short) 1 );HSSFRow row2 = sheet1.createRow( (short) 2 );HSSFCell cell = row.createCell( (short) 1 );cell.setCellValue( "This is a test of merging" );Region region = new Region( 1, (short) 1, 4, (short) 4 );sheet1.addMergedRegion( region );// Set the border and border colors.final short borderMediumDashed = HSSFCellStyle.BORDER_MEDIUM_DASHED; HSSFRegionUtil.setBorderBottom( borderMediumDashed,region, sheet1, wb );HSSFRegionUtil.setBorderTop( borderMediumDashed,region, sheet1, wb );HSSFRegionUtil.setBorderLeft( borderMediumDashed,region, sheet1, wb );HSSFRegionUtil.setBorderRight( borderMediumDashed,region, sheet1, wb );HSSFRegionUtil.setBottomBorderColor(HSSFColor.AQUA.index, region, sheet1, wb);HSSFRegionUtil.setTopBorderColor(HSSFColor.AQUA.index, region, sheet1, wb);HSSFRegionUtil.setLeftBorderColor(HSSFColor.AQUA.index, region, sheet1, wb);HSSFRegionUtil.setRightBorderColor(HSSFColor.AQUA.index, region, sheet1, wb);// Shows some usages of HSSFCellUtilHSSFCellStyle style = wb.createCellStyle();style.setIndention((short)4);HSSFCellUtil.createCell(row, 8, "This is the value of the cell", style);HSSFCell cell2 = HSSFCellUtil.createCell( row2, 8, "This is the value of the cell");HSSFCellUtil.setAlignment(cell2, wb, HSSFCellStyle.ALIGN_CENTER); // Write out the workbookFileOutputStream fileOut = new FileOutputStream( "workbook.xls" ); wb.write( fileOut );fileOut.close();19.在工作单中移动行，调整行的上下位置HSSFWorkbook wb = new HSSFWorkbook();HSSFSheet sheet = wb.createSheet("row sheet");// Create various cells and rows for spreadsheet.// Shift rows 6 - 11 on the spreadsheet to the top (rows 0 - 5)sheet.shiftRows(5, 10, -5);FileOutputStream fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut);fileOut.close();20.选种指定的工作单HSSFWorkbook wb = new HSSFWorkbook();HSSFSheet sheet = wb.createSheet("row sheet");sheet.setSelected(true);// Create various cells and rows for spreadsheet.FileOutputStream fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut);fileOut.close();21.工作单的放大缩小HSSFWorkbook wb = new HSSFWorkbook();HSSFSheet sheet1 = wb.createSheet("new sheet");sheet1.setZoom(3,4); // 75 percent magnificationFileOutputStream fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut);fileOut.close();22.头注和脚注HSSFWorkbook wb = new HSSFWorkbook();HSSFSheet sheet = wb.createSheet("new sheet");HSSFHeader header = sheet.getHeader();header.setCenter("Center Header");header.setLeft("Left Header");header.setRight(HSSFHeader.font("Stencil-Normal", "Italic") +HSSFHeader.fontSize((short) 16) + "Right w/ Stencil-Normal Italic font and size 16");FileOutputStream fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut);fileOut.close();//-------------------------------以上实例代码均来自官方网站//-------------------------------POI中使用的颜色是用颜色索引来实现，如下：/** 颜色对照表数字代表颜色索引8： BLACK60： BROWN59： OLIVE_GREEN58： DARK_GREEN56： DARK_TEAL18： DARK_BLUE32： DARK_BLUE62： INDIGO63： GREY_80_PERCENT53： ORANGE19： DARK_YELLOW17： GREEN21： TEAL38： TEAL12： BLUE39： BLUE54： BLUE_GREY23： GREY_50_PERCENT10： RED52： LIGHT_ORANGE50： LIME57： SEA_GREEN49： AQUA48： LIGHT_BLUE20： VIOLET36： VIOLET55： GREY_40_PERCENT14： PINK33： PINK51： GOLD13： YELLOW34： YELLOW11： BRIGHT_GREEN35： BRIGHT_GREEN15： TURQUOISE35： TURQUOISE16： DARK_RED37： DARK_RED40： SKY_BLUE61： PLUM25： PLUM22： GREY_25_PERCENT45： ROSE43： LIGHT_YELLOW42： LIGHT_GREEN41： LIGHT_TURQUOISE27：LIGHT_TURQUOISE44： PALE_BLUE46： LAVENDER9： WHITE24： CORNFLOWER_BLUE26： LEMON_CHIFFON25： MAROON28： ORCHID29： CORAL30： ROYAL_BLUE31： LIGHT_CORNFLOWER_BLUE*///----------------------------------------------------你可以按上面的方法来自定义颜色/** 自定义颜色，去掉注释，贴加，其他则查看颜色对照表HSSFPalette palette = this.getCustomPalette();palette.setColorAtIndex(idx,i, //RGB red (0-255)j, //RGB greenk //RGB blue);*///---------------------------------------------------用以上的基础知识我们就可以制作复杂的多表头，控制元/。