未加星标

Spreadsheet Data Formatting Not Working

字体大小 | |
[前端(javascript) 所属分类 前端(javascript) | 发布者 店小二04 | 时间 2018 | 作者 红领巾 ] 0人收藏点击收藏

I have a function to generate a single worksheet in an excel xlsx workbook. I am passing in a sheet name, a comma separated list of column names and a query of data. No matter what I do, I can’t seem to get a data format to be applied to a cell. I have seen a few examples and it’s using similar methodology, which leaves me scratching my head.

Is there a sequence that must be followed for the formatting to be applied? Do I need to write the file and then update it with the formatting?

// Create a spreadsheet object with the sheetname passed into the function.

variables.spreadsheetObj = spreadsheetNew(“#ARGUMENTS.sheetName#”,true);

//Add the header row column labels

spreadSheetAddRow(variables.spreadsheetObj, “#ARGUMENTS.columnNames#”);

//Format the header row

SpreadsheetFormatCellRange(variables.spreadsheetObj, variables.headerFormat, 1, 1, 1, #variables.numberOfColumns#);

//Add the data from the query

spreadsheetAddRows(variables.spreadsheetObj,variables.dataQueryResults,2,1,false,[“”],false);

//Format the data rows with the formatting from above, and apply to the rest of the rows.

spreadsheetFormatRows(variables.spreadsheetObj,variables.rowFormat,”2-#variables.lastExcelRow#”);

//Set the values of a format struct

variables.cellFormat = StructNew();

variables.cellFormat.dataformat = “($#,##0_($#,##0)”;

//I Loop through a comma separated list of the columns that need formatting and run this function

spreadsheetFormatCellRange(variables.spreadsheetObj, variables.cellFormat, 2, #columnNumber#, 21, #columnNumber#);

//Write the excel file.

cfml tag/function cfspreadsheet ColdFusion question

0

0

Snazzo


Spreadsheet Data Formatting Not Working
Newbie 2 posts

Followers: 0 people

Snazzo

Comments (0)

Add your comment

You must belogged in to post a comment.

本文前端(javascript)相关术语:javascript是什么意思 javascript下载 javascript权威指南 javascript基础教程 javascript 正则表达式 javascript设计模式 javascript高级程序设计 精通javascript javascript教程

代码区博客精选文章
分页:12
转载请注明
本文标题:Spreadsheet Data Formatting Not Working
本站链接:https://www.codesec.net/view/611211.html


1.凡CodeSecTeam转载的文章,均出自其它媒体或其他官网介绍,目的在于传递更多的信息,并不代表本站赞同其观点和其真实性负责;
2.转载的文章仅代表原创作者观点,与本站无关。其原创性以及文中陈述文字和内容未经本站证实,本站对该文以及其中全部或者部分内容、文字的真实性、完整性、及时性,不作出任何保证或承若;
3.如本站转载稿涉及版权等问题,请作者及时联系本站,我们会及时处理。
登录后可拥有收藏文章、关注作者等权限...
技术大类 技术大类 | 前端(javascript) | 评论(0) | 阅读(62)