Deprecate HSSFWorkbook.getSSTString(int) ?

[ap...@charter.net]

Why was HSSFWorkbook.getSSTString(int) deprecated?  I parse spreadsheets that are uploaded via a web application and there are times I get spreadsheets that look like they have data but when the normal methods of getting data out of the cells are used, it does not return any data.  The only way I can get the data out of the spreadsheet is to use the getSSTString method.  When I saw it was deprecated in 3.0, I was hopeful that the issue was corrected, but I just tried it and I am still required to use getSSTString to get the data.

A code snippet form the code I use to get the data from the spreadsheet is as follows and I have attached an example spreadsheet that has this issue.  Note that if you open it and save it, it will not have the issue anymore.  If you are going to try it out, just save it directly from the email.

Thanks for any help.  If more information is needed, I will be happy to provide it.

            int rowCnt = sheet.getLastRowNum();
            for (int rowNum = 0; rowNum <= rowCnt; rowNum++)
            {
                boolean isBlankRow = true;
                HSSFRow row = sheet.getRow(rowNum);
                if (row == null)
                {
                    System.out.println("Row " + rowNum + " was NULL.");
                    continue;
                }

                Collection errors = new ArrayList();
                Object voObject = null;
                try
                {
                    voObject = voClass.newInstance();
                } catch (IllegalAccessException ex)
                {
                    ex.printStackTrace();
                    throw new RwtException(ExceptionConstants.GENERAL_EX,
                            RwtException.SYSTEM_EXCEPTION,
                            RwtException.FATAL_ERROR, ex);
                } catch (InstantiationException ex)
                {
                    ex.printStackTrace();
                    throw new RwtException(ExceptionConstants.GENERAL_EX,
                            RwtException.SYSTEM_EXCEPTION,
                            RwtException.FATAL_ERROR, ex);
                }

                int cellCnt = row.getLastCellNum();
                Collection mapColumns = fileMap.getColumns();
                if (hasHeader && rowNum == 0)
                {
                    System.out.println("Validating the header!!!");
                    Collection headerErrors = validateHeader(row, mapColumns,
                            file.getFileName(), rowNum);
                    if (headerErrors.size() > 0)
                    {
                        System.out.println("Found error in header.");
                        throw new InvalidHeaderException(headerErrors);
                    }
                } else
                {
                    Collection cellValues = new ArrayList();
                    for (short cellNum = 0; cellNum < cellCnt; cellNum++)
                    {
                        HSSFCell cell = row.getCell(cellNum);
                        if (cell != null
                                && cell.getCellType() != HSSFCell.CELL_TYPE_BLANK)
                        {
                            // Get the value of the cell and approximate its type
                            int cellType = cell.getCellType();
                            Object cellValue = null;
                            if (cellType == HSSFCell.CELL_TYPE_NUMERIC)
                            {
                                double cellDoubleValue = cell
                                        .getNumericCellValue();
                                if (HSSFDateUtil.isCellDateFormatted(cell))
                                {
                                    cellValue = new Timestamp(HSSFDateUtil
                                            .getJavaDate(cellDoubleValue)
                                            .getTime());
                                } else
                                {
                                    long cellLongValue = (long) cellDoubleValue;
                                    if (cellLongValue == cellDoubleValue)
                                    {
                                        cellValue = new Long(cellLongValue);
                                    } else
                                    {
                                        cellValue = new Double(cellDoubleValue);
                                    }
                                }
                            } else if (cellType == HSSFCell.CELL_TYPE_STRING)
                            {
                                // WR-1579 begin
                                HSSFRichTextString richText = cell.getRichStringCellValue();
                                cellValue = richText.getString();
                                // WR-1579 end
                            }

                            foundRowData = true;
                            cellValues.add(cellValue);
                        } else
                        {
                            cellValues.add("");
                        }
                    }

                    /* If no valid cell has been found
                     * to this point in the spreadsheet
                     * try to get a value from the Shared
                     * String Table at the row's position.
                     * 
                     * See page 389 in the 
                     * Excel 97 Developer's Kit
                     */
                    if (!foundRowData)
                    {
                        System.out
                                .println("No cell data has been found for row: "
                                        + rowNum);

                        try
                        {
                            /* If and SST value is found then the cellValues
                             * Collection must be cleared to remove any empty 
                             * Strings added in the cell loop, above.
                             */
                            System.out
                                    .println("Looking for cell data from Shared String Table: "
                                            + sstPosition); // WR-0964                            
                            String sstString = workbook
                                    .getSSTString(sstPosition);
                            cellValues = new ArrayList();
                            cellValues.add(sstString);
                            System.out
                                    .println("Set cell data from Shared String Table: "
                                            + sstPosition); // WR-0964
                        } catch (Exception e)
                        {
                            System.out
                                    .println("Failed to get Shared String Table String: "
                                            + sstPosition); // WR-0964
                        }
                        sstPosition++;
                    }


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org