Oooh like the work, hate the location. I don't want people to need to deploy examples into production. . please move this to
jakarta-poi/examples/java.org.... create new ant target "examples" (also compiled-only examples are practically useless anyhow) >On 19 Feb 2002 22:42:15 -0000 [EMAIL PROTECTED] wrote. >glens 02/02/19 14:42:15 > > Added: src/java/org/apache/poi/hssf/usermodel/examples > CreateCells.java CreateDateCells.java > Log: > Examples galore. Well okay, only two. More to come... Really! > > Revision Changes Path > 1.1 jakarta-poi/src/java/org/apache/poi/hssf/usermodel/examples/CreateCells.java > > Index: CreateCells.java > =================================================================== > /* ==================================================================== > * The Apache Software License, Version 1.1 > * > * Copyright (c) 2002 The Apache Software Foundation. All rights > * reserved. > * > * Redistribution and use in source and binary forms, with or without > * modification, are permitted provided that the following conditions > * are met: > * > * 1. Redistributions of source code must retain the above copyright > * notice, this list of conditions and the following disclaimer. > * > * 2. Redistributions in binary form must reproduce the above copyright > * notice, this list of conditions and the following disclaimer in > * the documentation and/or other materials provided with the > * distribution. > * > * 3. The end-user documentation included with the redistribution, > * if any, must include the following acknowledgment: > * "This product includes software developed by the > * Apache Software Foundation (http://www.apache.org/)." > * Alternately, this acknowledgment may appear in the software itself, > * if and wherever such third-party acknowledgments normally appear. > * > * 4. The names "Apache" and "Apache Software Foundation" and > * "Apache POI" must not be used to endorse or promote products > * derived from this software without prior written permission. For > * written permission, please contact [EMAIL PROTECTED] > * > * 5. Products derived from this software may not be called "Apache", > * "Apache POI", nor may "Apache" appear in their name, without > * prior written permission of the Apache Software Foundation. > * > * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED > * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES > * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE > * DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR > * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, > * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT > * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF > * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND > * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, > * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT > * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF > * SUCH DAMAGE. > * ==================================================================== > * > * This software consists of voluntary contributions made by many > * individuals on behalf of the Apache Software Foundation. For more > * information on the Apache Software Foundation, please see > * <http://www.apache.org/>. > */ > > package org.apache.poi.hssf.usermodel.examples; > > import org.apache.poi.hssf.usermodel.HSSFWorkbook; > import org.apache.poi.hssf.usermodel.HSSFSheet; > import org.apache.poi.hssf.usermodel.HSSFRow; > import org.apache.poi.hssf.usermodel.HSSFCell; > > import java.io.FileOutputStream; > import java.io.IOException; > > /** > * Illustrates how to create cell values. > * > * @author Glen Stampoultzis (glens at apache.org) > */ > public class CreateCells > { > public static void main(String[] args) > throws IOException > { > 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 file > FileOutputStream fileOut = new FileOutputStream("workbook.xls"); > wb.write(fileOut); > fileOut.close(); > } > } > > > > 1.1 jakarta-poi/src/java/org/apache/poi/hssf/usermodel/examples/CreateDateCells.java > > Index: CreateDateCells.java > =================================================================== > /* ==================================================================== > * The Apache Software License, Version 1.1 > * > * Copyright (c) 2002 The Apache Software Foundation. All rights > * reserved. > * > * Redistribution and use in source and binary forms, with or without > * modification, are permitted provided that the following conditions > * are met: > * > * 1. Redistributions of source code must retain the above copyright > * notice, this list of conditions and the following disclaimer. > * > * 2. Redistributions in binary form must reproduce the above copyright > * notice, this list of conditions and the following disclaimer in > * the documentation and/or other materials provided with the > * distribution. > * > * 3. The end-user documentation included with the redistribution, > * if any, must include the following acknowledgment: > * "This product includes software developed by the > * Apache Software Foundation (http://www.apache.org/)." > * Alternately, this acknowledgment may appear in the software itself, > * if and wherever such third-party acknowledgments normally appear. > * > * 4. The names "Apache" and "Apache Software Foundation" and > * "Apache POI" must not be used to endorse or promote products > * derived from this software without prior written permission. For > * written permission, please contact [EMAIL PROTECTED] > * > * 5. Products derived from this software may not be called "Apache", > * "Apache POI", nor may "Apache" appear in their name, without > * prior written permission of the Apache Software Foundation. > * > * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED > * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES > * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE > * DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR > * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, > * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT > * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF > * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND > * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, > * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT > * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF > * SUCH DAMAGE. > * ==================================================================== > * > * This software consists of voluntary contributions made by many > * individuals on behalf of the Apache Software Foundation. For more > * information on the Apache Software Foundation, please see > * <http://www.apache.org/>. > */ > > package org.apache.poi.hssf.usermodel.examples; > > import org.apache.poi.hssf.usermodel.*; > > import java.io.FileOutputStream; > import java.io.IOException; > import java.util.Date; > > /** > * An example on how to cells with dates. The important thing to note > * about dates is that they are really normal numeric cells that are > * formatted specially. > * > * @author Glen Stampoultzis (glens at apache.org) > */ > public class CreateDateCells > { > public static void main(String[] args) > throws IOException > { > 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.getFormat("m/d/yy h:mm")); > cell = row.createCell((short)1); > cell.setCellValue(new Date()); > cell.setCellStyle(cellStyle); > > // Write the output to a file > FileOutputStream fileOut = new FileOutputStream("workbook.xls"); > wb.write(fileOut); > fileOut.close(); > > } > } > > >