dede
unread,Jul 26, 2016, 7:52:42 AM7/26/16You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
Hello,
I would like to hide the grid lines of the sheet. How to do that ?
<cfset sheet = spreadsheetNew("document")>
cfset FormatData = StructNew()
cfset FormatData.font = "Calibri"
cfset FormatData.fontsize = "11"
cfset FormatData.textwrap = true
cfset FormatData.verticalalignment = "vertical_top"
cfset FormatData.topborder = "thin"
cfset FormatData.leftborder = "thin"
cfset FormatData.bottomborder = "thin"
cfset FormatData.rightborder = "thin"
cfset rw = 5
cfset SpreadsheetSetCellValue(sheet, "Product", rw, 1)
cfset SpreadsheetFormatCell(sheet,FormatData,rw,1)
<!--- Generate document --->
cfheader name="content-disposition" value="attachment; filename=test.xls"
cfcontent type="application/msexcel" variable="#spreadsheetReadBinary(sheet)#"
reset="true"
Thank you for your help
Dede