ColdFusion – forsiranje teksta kao formata kod inserta broja koristeći spreadsheetSetCellValue

Problem: ubaciti string “012345″ u čeliju koristeći spreadsheetSetCellValue. Dobiveni excel dokument sadrži vrijednost 12345, dakle izgubio je nulu.

Rješenje: ubaciti podatak, formatirati polje i ubaciti podatak opet.


<cfset var sprSht = spreadsheetNew("mojFile", true)>

<cfset var format_values = structNew()>

<!--- format as text --->
<cfset format_values.dataformat = "@">

<!--- insert value --->
<cfset spreadsheetSetCellValue(sprSht, '012345', 1, 1)>

<!--- format cell --->
<cfset spreadsheetFormatCell(sprSht, format_values, 1, 1)>

<!--- insert value again--->
<cfset spreadsheetSetCellValue(sprSht, '012345', 1, 1)>
This entry was posted on Friday, September 7th, 2018 at 2:47 pmand is filed under Coldfusion. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

Comments are closed.