升级到poi包括转换现有hssf.pdfVIP

UpgradingtoPOI3.5,including

convertingexistingHSSFUsermodel

codetoSSUsermodel(forXSSFand

HSSF)

byNickBurch

1.ThingsthathavetobechangedwhenupgradingtoPOI3.5

Whereverpossible,wehavetriedtoensurethatyoucanuseyourexistingPOIcodewithPOI

3.5withoutrequiringanychanges.However,Javadoesntalwaysmakethateasy,and

unfortunatelythereareafewchangesthatmayberequiredforsomeusers.

1.1.org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.CellValue

Annoyingly,javawillnotletyouaccessastaticinnerclassviaachildoftheparentone.So,

allreferencestoorg.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.CellValuewillneed

tobechangedtoorg.apache.poi.ss.usermodel.FormulaEvaluator.CellValue

1.2.org.apache.poi.hssf.usermodel.HSSFRow.MissingCell

Annoyingly,javawillnotletyouaccessastaticinnerclassviaachildoftheparentone.So,

allreferencestoorg.apache.poi.hssf.usermodel.HSSFRow.MissingCellwillneedtobe

changedtoorg.apache.poi.ss.usermodel.Row.MissingCell

1.3.DDFandorg.apache.poi.hssf.record.RecordFormatException

Previously,recordlevelerrorswithinDDFwouldthrowanexceptionfromthehssfclass

heirachy.Now,recordlevelerrorswithinDDFwillthrowamoregeneral

RecordFormatException,org.apache.poi.util.RecordFormatException

Inaddition,org.apache.poi.hssf.record.RecordFormatExceptionhasbeenchangedtoinherit

fromtheneworg.apache.poi.util.RecordFormatException,soyoumaywishtochange

Page1

Copyright©2002-2011TheApacheSoftwareFoundation

UpgradingtoPOI3.5,includingconvertingexistingHSSFUsermodelcodetoSS

Usermodel(forXSSFandHSSF)

catchesofthehssfversiontothenewutilversion.

2.ConvertingexistingHSSFUsermodelcodetoSSUsermodel(forXSSFandHSSF)

2.1.Whychange?

IfyouhaveexistingHSSFusermodelcodethatworksjustfine,andyoudontwanttousethe

newOOXMLXSSFsupport,thenyouprobablydontneedto.YourexistingHSSFonlycode

willcontinuetoworkjustfine.

However,ifyouwanttobeabletoworkwithbothHSSFforyour.xlsfiles,andalsoXSSF

fo