You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ni...@apache.org on 2008/03/16 18:23:26 UTC
svn commit: r637614 - in /poi/branches/ooxml/src:
documentation/content/xdocs/spreadsheet/
examples/src/org/apache/poi/ss/usermodel/examples/
java/org/apache/poi/hssf/usermodel/ testcases/org/apache/poi/hssf/data/
Author: nick
Date: Sun Mar 16 10:23:24 2008
New Revision: 637614
URL: http://svn.apache.org/viewvc?rev=637614&view=rev
Log:
More create helper stuff, and some sample formatting files
Added:
poi/branches/ooxml/src/java/org/apache/poi/hssf/usermodel/HSSFCreationHelper.java (with props)
poi/branches/ooxml/src/testcases/org/apache/poi/hssf/data/Formatting.xls (with props)
poi/branches/ooxml/src/testcases/org/apache/poi/hssf/data/Formatting.xlsx (with props)
Modified:
poi/branches/ooxml/src/documentation/content/xdocs/spreadsheet/quick-guide.xml
poi/branches/ooxml/src/examples/src/org/apache/poi/ss/usermodel/examples/FromQuickGuide.java
poi/branches/ooxml/src/java/org/apache/poi/hssf/usermodel/HSSFCell.java
poi/branches/ooxml/src/java/org/apache/poi/hssf/usermodel/HSSFWorkbook.java
Modified: poi/branches/ooxml/src/documentation/content/xdocs/spreadsheet/quick-guide.xml
URL: http://svn.apache.org/viewvc/poi/branches/ooxml/src/documentation/content/xdocs/spreadsheet/quick-guide.xml?rev=637614&r1=637613&r2=637614&view=diff
==============================================================================
--- poi/branches/ooxml/src/documentation/content/xdocs/spreadsheet/quick-guide.xml (original)
+++ poi/branches/ooxml/src/documentation/content/xdocs/spreadsheet/quick-guide.xml Sun Mar 16 10:23:24 2008
@@ -105,6 +105,7 @@
<source>
Workbook wb = new HSSFWorkbook();
//Workbook wb = new XSSFWorkbook();
+ CreationHelper createHelper = wb.getCreationHelper();
Sheet sheet = wb.createSheet("new sheet");
// Create a row and put some cells in it. Rows are 0 based.
@@ -116,7 +117,7 @@
// Or do it on one line.
row.createCell((short)1).setCellValue(1.2);
row.createCell((short)2).setCellValue(
- cell.createRichTextString("This is a string"));
+ createHelper.createRichTextString("This is a string"));
row.createCell((short)3).setCellValue(true);
// Write the output to a file
@@ -128,22 +129,25 @@
<anchor id="CreateDateCells"/>
<section><title>Creating Date Cells</title>
<source>
- HSSFWorkbook wb = new HSSFWorkbook();
- HSSFSheet sheet = wb.createSheet("new sheet");
+ Workbook wb = new HSSFWorkbook();
+ //Workbook wb = new XSSFWorkbook();
+ CreationHelper createHelper = wb.getCreationHelper();
+ Sheet sheet = wb.createSheet("new sheet");
// Create a row and put some cells in it. Rows are 0 based.
- HSSFRow row = sheet.createRow((short)0);
+ Row 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 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"));
+ CellStyle cellStyle = wb.createCellStyle();
+ cellStyle.setDataFormat(
+ createHelper.createDataFormat().getFormat("m/d/yy h:mm"));
cell = row.createCell((short)1);
cell.setCellValue(new Date());
cell.setCellStyle(cellStyle);
Modified: poi/branches/ooxml/src/examples/src/org/apache/poi/ss/usermodel/examples/FromQuickGuide.java
URL: http://svn.apache.org/viewvc/poi/branches/ooxml/src/examples/src/org/apache/poi/ss/usermodel/examples/FromQuickGuide.java?rev=637614&r1=637613&r2=637614&view=diff
==============================================================================
--- poi/branches/ooxml/src/examples/src/org/apache/poi/ss/usermodel/examples/FromQuickGuide.java (original)
+++ poi/branches/ooxml/src/examples/src/org/apache/poi/ss/usermodel/examples/FromQuickGuide.java Sun Mar 16 10:23:24 2008
@@ -18,9 +18,13 @@
import java.io.FileOutputStream;
import java.io.IOException;
+import java.util.Date;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
+import org.apache.poi.ss.usermodel.CellStyle;
+import org.apache.poi.ss.usermodel.CreationHelper;
+import org.apache.poi.ss.usermodel.DataFormat;
import org.apache.poi.ss.usermodel.RichTextString;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
@@ -71,6 +75,7 @@
for (int i = 0; i < wbs.length; i++) {
Workbook wb = wbs[i];
+ CreationHelper createHelper = wb.getCreationHelper();
Sheet sheet = wb.createSheet("new sheet");
// Create a row and put some cells in it. Rows are 0 based.
@@ -82,7 +87,7 @@
// Or do it on one line.
row.createCell((short)1).setCellValue(1.2);
row.createCell((short)2).setCellValue(
- cell.createRichTextString("This is a string"));
+ createHelper.createRichTextString("This is a string"));
row.createCell((short)3).setCellValue(true);
// Write the output to a file
@@ -90,5 +95,34 @@
wb.write(fileOut);
fileOut.close();
}
+ }
+
+ public void newDateCells() throws IOException {
+ Workbook wb = new HSSFWorkbook();
+ //Workbook wb = new XSSFWorkbook();
+ CreationHelper createHelper = wb.getCreationHelper();
+ Sheet sheet = wb.createSheet("new sheet");
+
+ // Create a row and put some cells in it. Rows are 0 based.
+ Row row = sheet.createRow((short)0);
+
+ // Create a cell and put a date value in it. The first cell is not styled
+ // as a date.
+ Cell 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.
+ CellStyle cellStyle = wb.createCellStyle();
+ cellStyle.setDataFormat(createHelper.createDataFormat().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();
}
}
Modified: poi/branches/ooxml/src/java/org/apache/poi/hssf/usermodel/HSSFCell.java
URL: http://svn.apache.org/viewvc/poi/branches/ooxml/src/java/org/apache/poi/hssf/usermodel/HSSFCell.java?rev=637614&r1=637613&r2=637614&view=diff
==============================================================================
--- poi/branches/ooxml/src/java/org/apache/poi/hssf/usermodel/HSSFCell.java (original)
+++ poi/branches/ooxml/src/java/org/apache/poi/hssf/usermodel/HSSFCell.java Sun Mar 16 10:23:24 2008
@@ -1141,11 +1141,4 @@
int eofLoc = sheet.findFirstRecordLocBySid( EOFRecord.sid );
sheet.getRecords().add( eofLoc, link.record );
}
-
- /**
- * Creates a new HSSFRichTextString for you.
- */
- public RichTextString createRichTextString(String text) {
- return new HSSFRichTextString(text);
- }
}
Added: poi/branches/ooxml/src/java/org/apache/poi/hssf/usermodel/HSSFCreationHelper.java
URL: http://svn.apache.org/viewvc/poi/branches/ooxml/src/java/org/apache/poi/hssf/usermodel/HSSFCreationHelper.java?rev=637614&view=auto
==============================================================================
--- poi/branches/ooxml/src/java/org/apache/poi/hssf/usermodel/HSSFCreationHelper.java (added)
+++ poi/branches/ooxml/src/java/org/apache/poi/hssf/usermodel/HSSFCreationHelper.java Sun Mar 16 10:23:24 2008
@@ -0,0 +1,44 @@
+/* ====================================================================
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+==================================================================== */
+package org.apache.poi.hssf.usermodel;
+
+import org.apache.poi.ss.usermodel.CreationHelper;
+import org.apache.poi.ss.usermodel.DataFormat;
+import org.apache.poi.ss.usermodel.RichTextString;
+
+public class HSSFCreationHelper implements CreationHelper {
+ private HSSFWorkbook workbook;
+ private HSSFDataFormat dataFormat;
+
+ HSSFCreationHelper(HSSFWorkbook wb) {
+ workbook = wb;
+
+ // Create the things we only ever need one of
+ dataFormat = new HSSFDataFormat(workbook.getWorkbook());
+ }
+
+ /**
+ * Creates a new HSSFRichTextString for you.
+ */
+ public RichTextString createRichTextString(String text) {
+ return new HSSFRichTextString(text);
+ }
+
+ public DataFormat createDataFormat() {
+ return dataFormat;
+ }
+}
Propchange: poi/branches/ooxml/src/java/org/apache/poi/hssf/usermodel/HSSFCreationHelper.java
------------------------------------------------------------------------------
svn:eol-style = native
Modified: poi/branches/ooxml/src/java/org/apache/poi/hssf/usermodel/HSSFWorkbook.java
URL: http://svn.apache.org/viewvc/poi/branches/ooxml/src/java/org/apache/poi/hssf/usermodel/HSSFWorkbook.java?rev=637614&r1=637613&r2=637614&view=diff
==============================================================================
--- poi/branches/ooxml/src/java/org/apache/poi/hssf/usermodel/HSSFWorkbook.java (original)
+++ poi/branches/ooxml/src/java/org/apache/poi/hssf/usermodel/HSSFWorkbook.java Sun Mar 16 10:23:24 2008
@@ -63,6 +63,7 @@
import org.apache.poi.hssf.record.formula.UnionPtg;
import org.apache.poi.hssf.util.CellReference;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
+import org.apache.poi.ss.usermodel.CreationHelper;
import org.apache.poi.util.POILogFactory;
import org.apache.poi.util.POILogger;
@@ -1459,6 +1460,10 @@
}
}
}
+ }
+
+ public CreationHelper getCreationHelper() {
+ return new HSSFCreationHelper(this);
}
private byte[] newUID()
Added: poi/branches/ooxml/src/testcases/org/apache/poi/hssf/data/Formatting.xls
URL: http://svn.apache.org/viewvc/poi/branches/ooxml/src/testcases/org/apache/poi/hssf/data/Formatting.xls?rev=637614&view=auto
==============================================================================
Binary file - no diff available.
Propchange: poi/branches/ooxml/src/testcases/org/apache/poi/hssf/data/Formatting.xls
------------------------------------------------------------------------------
svn:executable = *
Propchange: poi/branches/ooxml/src/testcases/org/apache/poi/hssf/data/Formatting.xls
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: poi/branches/ooxml/src/testcases/org/apache/poi/hssf/data/Formatting.xlsx
URL: http://svn.apache.org/viewvc/poi/branches/ooxml/src/testcases/org/apache/poi/hssf/data/Formatting.xlsx?rev=637614&view=auto
==============================================================================
Binary file - no diff available.
Propchange: poi/branches/ooxml/src/testcases/org/apache/poi/hssf/data/Formatting.xlsx
------------------------------------------------------------------------------
svn:executable = *
Propchange: poi/branches/ooxml/src/testcases/org/apache/poi/hssf/data/Formatting.xlsx
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org