You have region in your query so this is being used instead of your region object. Maybe?
Adrian > -----Original Message----- > From: Craigsell [mailto:[email protected]] > Sent: 07 January 2009 15:42 > To: cf-talk > Subject: Re: POI HSSF problem with CFLOOP > > Oops! Sorry. > > Here's the code that throws the error. If you remove the CFLOOP tags, > the > addMergedRegion method becomes available. > > > > Merged Cell Test <CFoutput>#now()#</cfoutput> > > <cfset myQuery = QueryNew("REGION, STATE, ZIP", "VarChar, VarChar, > VarChar")> > <cfset newRow = QueryAddRow(MyQuery, 1)> > <cfset temp = QuerySetCell(myQuery, "REGION", "CENTRAL", 1)> > <cfset temp = QuerySetCell(myQuery, "STATE", "MO", 1)> > <cfset temp = QuerySetCell(myQuery, "ZIP", "11111", 1)> > > <CFSET WorkBook = > createObject("java","org.apache.poi.hssf.usermodel.HSSFWorkbook").init( > )> > <CFSET TargetSheet = WorkBook.createSheet("new sheet")/> > <cfset row = TargetSheet.createRow(5)/> > <cfset cell = row.createCell(1)/> > <cfset cell.setCellValue("With Loop")> > <cfset row = TargetSheet.createRow(8)/> > <cfset cell = row.createCell(1)/> > <cfset cell.setCellValue("Merged")> > <cfset cell = row.createCell(2)/> > <cfset cell.setCellValue("False")> > <cfset region = > createObject("java","org.apache.poi.hssf.util.Region").init(8,1,8,6)/> > > <CFLOOP query="myQuery"> > <cfset TargetSheet.addMergedRegion(region)/> > </CFLOOP> > > <CFHEADER name="Content-Disposition" value="attachment; > filename=OutputFile.xls"> > <CFSCRIPT> > context = getPageContext(); > context.setFlushOutput(false); > response = context.getResponse().getResponse(); > response.reset(); > out = response.getOutputStream(); > response.setContentType("application/vnd.ms-excel"); > WorkBook.write(out); > out.flush(); > response.reset(); > out.close(); > </CFSCRIPT> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317527 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
