- 浏览: 640725 次
- 性别:
- 来自: 北京
文章分类
最新评论
-
ssxszt:
...
解决PopUpManager弹出窗口RangeError: Error #2006: 提供的索引超出范围 -
lijiajia:
木子佳 写道楼主,想要源码学习,谢谢。kajiamuzi@16 ...
DataGrid和AdvancedDataGrid CheckBox全选功能 -
juedi:
很好,是我需要的东东
Flex异常处理设计 -
暖暖fh:
大神,我想要源码,这个功能我折腾了好我啊 fuhan247@1 ...
DataGrid和AdvancedDataGrid CheckBox全选功能 -
chenzi:
一样的代码,两台机器上面,完全不同的报错。。Flex实现htt ...
Flex使用Https协议
14. 自定义颜色
HSSF:
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 background HSSFCellStyle 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 palette FileOutputStream 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 freebsd.org) cell.setCellValue("Modified Palette"); //creating a custom palette for the workbook HSSFPalette palette = wb.getCustomPalette(); //replacing the standard red with freebsd.org red palette.setColorAtIndex(HSSFColor.RED.index, (byte) 153, //RGB red (0-255) (byte) 0, //RGB green (byte) 0 //RGB blue ); //replacing lime with freebsd.org gold palette.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 appear out = new FileOutputStream("modified_palette.xls"); wb.write(out); out.close();
XSSF:
XSSFWorkbook wb = new XSSFWorkbook(); XSSFSheet sheet = wb.createSheet(); XSSFRow row = sheet.createRow(0); XSSFCell cell = row.createCell( 0); cell.setCellValue("custom XSSF colors"); XSSFCellStyle style1 = wb.createCellStyle(); style1.setFillForegroundColor(new XSSFColor(new java.awt.Color(128, 0, 128))); style1.setFillPattern(CellStyle.SOLID_FOREGROUND);
15. 读取和重写工作薄
InputStream inp = new FileInputStream("workbook.xls"); //InputStream inp = new FileInputStream("workbook.xlsx"); Workbook wb = WorkbookFactory.create(inp); Sheet sheet = wb.getSheetAt(0); Row row = sheet.getRow(2); Cell cell = row.getCell(3); if (cell == null) cell = row.createCell(3); cell.setCellType(Cell.CELL_TYPE_STRING); cell.setCellValue("a test"); // Write the output to a file FileOutputStream fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut); fileOut.close();
16. 单元格内容换行
Workbook wb = new XSSFWorkbook(); //or new HSSFWorkbook(); Sheet sheet = wb.createSheet(); Row row = sheet.createRow(2); Cell cell = row.createCell(2); cell.setCellValue("Use \n with word wrap on to create a new line"); //to enable newlines you need set a cell styles with wrap=true CellStyle cs = wb.createCellStyle(); cs.setWrapText(true); cell.setCellStyle(cs); //increase row height to accomodate two lines of text row.setHeightInPoints((2*sheet.getDefaultRowHeightInPoints())); //adjust column width to fit the content sheet.autoSizeColumn((short)2); FileOutputStream fileOut = new FileOutputStream("ooxml-newlines.xlsx"); wb.write(fileOut); fileOut.close();
换行的步骤:
- 在需要换行的地方加上\n cell.setCellValue("Use \n with word wrap on to create a new line");
- 设置行高 row.setHeightInPoints((2*sheet.getDefaultRowHeightInPoints()));
- 设置列只适应宽度 sheet.autoSizeColumn((short)2);
17. 数据格式化
public void dataFormat() throws Exception{ Workbook wb = new HSSFWorkbook(); Sheet sheet = wb.createSheet("format sheet"); CellStyle style; DataFormat format = wb.createDataFormat(); Row row; Cell 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(1111.25); style = wb.createCellStyle(); style.setDataFormat(format.getFormat("#,###.0000")); cell.setCellStyle(style); FileOutputStream fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut); fileOut.close(); }
18. 设置打印区域
Workbook wb = new HSSFWorkbook(); Sheet sheet = wb.createSheet("Sheet1"); //sets the print area for the first sheet wb.setPrintArea(0, "$A$1:$C$2"); //Alternatively: wb.setPrintArea( 0, //sheet index 0, //start column 1, //end column 0, //start row 0 //end row ); FileOutputStream fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut); fileOut.close();
19. 设置页脚
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();
备注:只有在打印预览的时候页脚才显示出来。
20. 选中一个Sheet
Workbook wb = new HSSFWorkbook(); Sheet sheet = wb.createSheet("row sheet"); sheet.setSelected(true);
21. 设置方法倍率
Workbook wb = new HSSFWorkbook(); Sheet sheet1 = wb.createSheet("new sheet"); sheet1.setZoom(3,4); // 75 percent magnification
Zoom是一个分数,例如如果方法75%,那么分子为3,分母为4。
22. 设置打印时的页宽和页高
Workbook wb = new HSSFWorkbook(); Sheet sheet = wb.createSheet("format sheet"); PrintSetup 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();
23. 移动行
public void shiftRow() throws Exception{ Workbook wb = new HSSFWorkbook(); Sheet sheet = wb.createSheet("row sheet"); for(int i=0;i<20;i++){ Row row=sheet.createRow(i); Cell cell=row.createCell(0); cell.setCellValue(""+i); } // Shift rows 6 - 11 on the spreadsheet to the top (rows 0 - 5) //把第6-11行向上移动5行 sheet.shiftRows(5, 10,-5); FileOutputStream fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut); fileOut.close(); }
POI学习笔记四将会介绍poi更高级的一些知识点。
发表评论
-
转 接口滥用问题
2011-08-22 16:57 1415我们知道,大家提倡面向接口编程,但凡事都有个度,当滥用,那么面 ... -
Jakarta Commons Cookbook学习笔记(一)
2010-08-14 22:20 2024开发中需要写很多工具类,大多数是关于字符串、文件 ... -
Effective java 读书笔记第八章(1)
2010-05-13 19:30 1372将局部变量的作用域最小化 较早的程序设计语言(如 ... -
Junit4学习笔记一
2010-03-18 12:31 1520Junit4是Junit框架 ... -
打印JdbcTemplate执行sql
2010-03-09 22:55 11549有关log4j的基础知识请参考log4j详解与实战,本文主要讲 ... -
POI学习笔记(四)
2010-01-03 12:07 1612大时代 -
POI学习笔记(二)
2010-01-02 20:42 28577. 设置单元格的边框 public void cr ... -
POI学习笔记(一)
2009-12-29 12:53 7078项目中经常要解析和生成Excel文件,最常用的开源 ... -
XStream学习笔记四
2009-12-05 11:30 2580XStream生成xml文件和从xml文件中得到对象 pub ... -
XStream学习笔记三
2009-12-05 10:52 3102本篇主要讲解XStream的Converter 简单的Co ... -
XStream学习笔记二
2009-12-03 13:47 1688以下面的xml文件展开讨论。 <blog author ... -
XStream学习笔记一
2009-12-03 10:12 2455XStream是一个实现java对象和xml相互转化的开源组件 ... -
取得系统的环境变量
2009-11-30 15:59 1170System.getProperty("java.l ... -
BigDecimal 加法保留小数位数
2009-11-07 09:39 7429BigDecimal bg1=new BigDecimal( ...
相关推荐
POI学习笔记第二版更详细的POI学习笔记第二版更详细的
POI学习笔记 POI中文教程(简单的)
POI的学习笔记,总结的还行。希望大家会喜欢
百度地图学习笔记,有代码。图层 定位 地理编码 poi搜索
OA (ssh) 基本实现(poi 生成 Excel , struts2动态下载 mysql数据库文件) 学习笔记(含源代码) 借鉴 风中叶 老师的视频,写的文章,代码比较详实。 说了很多我的看法,和思考,做了充分的日志
[摘要]:本文通过整理与VC维相关的重要概念,对分(Dichotomy)、增长函数(Growth Function)、打散(Shatter)、Break Poi
Spring Boot 学习笔记 基础篇 #提升篇 15.SpringBoot之集成Shiro 16.SpringBoot之使用mybatis-generator自动生成代码 17.SpringBoot之使用lombok编码 18.SpringBoot之初始化数据 19.SpringBoot之使用POI开发Excel...
java学习过程中的随手笔记,包括常见的文件选择和保存窗口的实现,poi的excel处理
非常值得学习的资源,结合笔记更快上手。 有poi报表生成,访问分析等技术, 非常值得学习的资源,结合笔记更快上手。 有poi报表生成,访问分析等技术,