bennadel / poiutility.cfc Goto Github PK

I have tried to implement the getCellComment() method in the PIOutility.cfc but I get a "method not found" error.

From the API documentation:
http://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/Cell.html#getCellComment%28%29

Can anyone help?
Thank you,

Hi Ben,

The row custom tag only creates rows, doesn't perform a get, so when you're using a template, the given row is completely overwritten. You can fix this by replacing the existing create (roughly line 56) with the following;

<!--- Try Getting the  row. --->
<cfset VARIABLES.Row = VARIABLES.SheetTag.Sheet.getRow( JavaCast( "int", (VARIABLES.SheetTag.RowIndex - 1) ) )>

<cfif ! StructKeyExists(Variables, "Row")>
     <cfset VARIABLES.Row = VARIABLES.SheetTag.Sheet.CreateRow(
			JavaCast( "int", (VARIABLES.SheetTag.RowIndex - 1) )
			) />
</cfif>

It changing int value in export. For example query return value "204678549" but in exported excel is " 204678544". I not sure why, but it looks like because of DataMapValue.