Google Groupes n'accepte plus les nouveaux posts ni abonnements Usenet. Les contenus de l'historique resteront visibles.

hide the grid in an excel document with CF10

3 vues
Accéder directement au premier message non lu

dede

non lue,
26 juil. 2016, 07:52:4226/07/2016
à
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

0 nouveau message