-
1. Re: Can you use the R1C1 reference style for SpreadsheetSetCellFormula
-==cfSearching==- Apr 26, 2012 10:44 AM (in response to HugoSchmidt)I could be wrong, but I do not think CF supports R1C1 style. However you can use the underlying POI classes to convert a column number to a letter. Just be aware POI expects the column index to be in base zero, not one.
<cfscript>
// example generate all column letters
util = createObject("java", "org.apache.poi.ss.util.CellReference");
for (col = 1; col <= 256; col++) {
// note - the column numbers are in base zero (0)!
colLetter = util.convertNumToColString( col - 1 );
WriteOutput("R1C1=[#col#] Alpha=[#colLetter#]<br>" );
}
</cfscript>
Message was edited by: -==cfSearching==-
-
2. Re: Can you use the R1C1 reference style for SpreadsheetSetCellFormula
HugoSchmidt Apr 26, 2012 10:49 AM (in response to -==cfSearching==-)I'll give you credit for a correct answer, because it does answer my #1 and it works. I do wish I could just use the R1C1 format, though. Especially since ColdFusion is done by numeric reference.
Thanks!
-
3. Re: Can you use the R1C1 reference style for SpreadsheetSetCellFormula
-==cfSearching==- Apr 26, 2012 10:59 AM (in response to HugoSchmidt)Well ultimately I think it comes down to whether POI supports it. Last I checked it did not, or at least not fully. Though that might have changed.