Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm using CIA report manager add on and have scripted 3 tables to be sent out to a pdf report. I would like the report output to 'scale to fit to one page' as I would if I tried printing this from excel. How can I do that in the script editor? I'm failry new to this - is there any online help for this anywhere?
Thank you.
# The following is code I used in CIA Report Manager. This is some basic script.
DEFINE DeptName AS STRING
WB.OPEN("Templates", "Template_Report.xlsx")
# Opens the template stored in a Templates directory
Use a WS = WB.Findsheet("Sheet 1")
# Selects the sheet in the workbook
SELECT = WS.SELECT(1,1,1,1)
# Sets the content at the position defined in pixels
SELECT.SETCONTENT(DeptName)
# Applies the exported content such as images, tables, text, etc.