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/10/27 18:59:39 UTC
svn commit: r708252 - /poi/trunk/src/java/org/apache/poi/hssf/dev/HSSF.java
Author: nick
Date: Mon Oct 27 10:59:39 2008
New Revision: 708252
URL: http://svn.apache.org/viewvc?rev=708252&view=rev
Log:
Patch from bug #46092 - fix hssf dev utility
Modified:
poi/trunk/src/java/org/apache/poi/hssf/dev/HSSF.java
Modified: poi/trunk/src/java/org/apache/poi/hssf/dev/HSSF.java
URL: http://svn.apache.org/viewvc/poi/trunk/src/java/org/apache/poi/hssf/dev/HSSF.java?rev=708252&r1=708251&r2=708252&view=diff
==============================================================================
--- poi/trunk/src/java/org/apache/poi/hssf/dev/HSSF.java (original)
+++ poi/trunk/src/java/org/apache/poi/hssf/dev/HSSF.java Mon Oct 27 10:59:39 2008
@@ -221,7 +221,7 @@
if (args.length < 2)
{
-/* try
+ try
{
HSSF hssf = new HSSF(args[ 0 ]);
@@ -230,26 +230,30 @@
for (int k = 0; k < wb.getNumberOfSheets(); k++)
{
- System.out.println("Sheet " + k);
HSSFSheet sheet = wb.getSheetAt(k);
int rows = sheet.getPhysicalNumberOfRows();
-
+ System.out.println("Sheet " + k + " \""
+ + wb.getSheetName(k) + "\" has "
+ + rows + " row(s).");
for (int r = 0; r < rows; r++)
{
- HSSFRow row = sheet.getPhysicalRowAt(r);
- int cells = row.getPhysicalNumberOfCells();
-
- System.out.println("ROW " + row.getRowNum());
+ HSSFRow row = sheet.getRow(r);
+ int cells = (row != null) ? row.getPhysicalNumberOfCells() : 0;
+ if (row != null) {
+ System.out.println("\nROW " + row.getRowNum()
+ + " has " + cells + " cell(s).");
+ }
for (int c = 0; c < cells; c++)
{
- HSSFCell cell = row.getPhysicalCellAt(c);
+ HSSFCell cell = row.getCell(c);
String value = null;
switch (cell.getCellType())
{
case HSSFCell.CELL_TYPE_FORMULA :
- value = "FORMULA ";
+ value = "FORMULA value="
+ + cell.getCellFormula();
break;
case HSSFCell.CELL_TYPE_NUMERIC :
@@ -274,7 +278,7 @@
catch (Exception e)
{
e.printStackTrace();
- }*/
+ }
}
else if (args.length == 2)
{
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org