在导出到Excel之前，如何更改cfquery结果的值？

<cfquery name="myQuery" datasource="yourDataSource">
    SELECT column1, column2, column3
    FROM yourTable
</cfquery>

<cfset modifiedQuery = []>

<cfloop query="myQuery">
    <cfset newValue = "" />

    <!-- 根据需要修改值 -->
    <cfif myQuery.column1 EQ "someValue">
        <cfset newValue = "New Value" />
    <cfelse>
        <cfset newValue = myQuery.column1 />
    </cfif>

    <!-- 创建新的查询行并添加到修改后的查询结果中 -->
    <cfset newRow = {
        "column1": newValue,
        "column2": myQuery.column2,
        "column3": myQuery.column3
    }>
    <cfset arrayAppend(modifiedQuery, newRow)>
</cfloop>

<!-- 导出修改后的查询结果到Excel -->
<cfspreadsheet action="write" filename="path/to/your/excel/file.xlsx" query="modifiedQuery" overwrite="true">