Append data after row

1

Row number, after which the data is to be inserted.

Enable dynamic sheet handling

true, false

false

See section 'Multiple Sheets' below.

Excel password for protection

Password for the Excel file. Which Excel attributes are set is described in the section below. Note: See also parameter Protect to open file - needs password.

Excel password to open file

Password to open the Excel file.

Excel template file

File name and path of the Excel template file.

Export as XML

true, false

false

Creates the Excel file in the Microsoft XML format SpreadsheetML . Note: Set the content to "Output of IU" and the encoding to "8859_1" in the Response.

Force style

true, false

false

See parameter "Use style of row".

Ignore new line in cell data

true, false

false

If true, linebreaks (NL) in cells are ignored.

Newly created sheet(s) are based on sheet#

0

See section "Multiple Sheets" below.

One sheet for each record

true, false

false

Creates one sheet for each record.

Remove all empty rows at end of each worksheet

true, false

false

Removes all empty rows at the end of each worksheet.

Remove all formulas

true, false

false

Removes all formulas after calculations have been done (e.g. because a partner should not see them).

Replace variable filler

true, false

false

Replaces variable fillers {var_myVariable} in the template file.

Sheet names (use semicolon to delimit names)

1

Name of spreadsheets if the option Use multiple sheets is used.

Skip empty fields

true, false

false

Cells in Excel are not 'touched' if the target structure field's Empty Flag is set. That is, for example, no empty string is written (necessary if a cell has a formula that should not be overwritten).

Start at column

1

Column number, after which the data is to be inserted.

Use multiple sheets

true, false

false

If the optional parameter Use multiple sheets is configured with value true, multiple spreadsheets can be generated. For that purpose, a target node can be associated with a spreadsheet by setting the node attribute "Optional Settings" to the number of the corresponding spreadsheet. Only integer values, starting with 1, are allowed.

Use style of row

0

The format of the specified row of the template file is used as format for the newly created rows. If the format is to be adopted in general (not only for new lines), you can use parameter Force style.

0 = no template.

A

ABS, ACCRINT, ACCRINTM, ACOS, ACOSH, ADDRESS, AMORDEGRC, AMORLINC, AND, AREAS, ASIN, ASINH, ATAN, ATAN2, ATANH, AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF

B

BESSELI, BESSELJ, BESSELK, BESSELY, BETADIST, BETAINV, BIN2DEC, BIN2HEX, BIN2OCT, BINOMDIST

C

CEILING, CHAR, CHIDIST, CHIINV, CHITEST, CHOOSE, CODE, COLUMN, COLUMNS, COMBIN, CONCATENATE, CONFIDENCE, CORREL, COS, COSH, COUNT, COUNTA, COUNTBLANK, COUNTIF, COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD, COVAR, CRITBINOM, CUMIPMT, CUMPRINC

D

DATE, DATEDIF, DATEVALUE, DAY, DAYS360, DAVERAGE, DB, DCOUNT, DCOUNTA, DDB, DEC2BIN, DEC2HEX, DEC2OCT, DEGREES, DELTA, DEVSQ, DGET, DISC, DMAX, DMIN, DOLLAR, DOLLARDE, DOLLARFR, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DURATION, DVAR, DVARP

E

EDATE, EFFECT, EOMONTH, ERF, ERFC, ERROR.TYPE, EVEN, EXACT, EXP, EXPONDIST

F

F.DIST, F.DIST.RT, F.INV.RT, FACT, FACTDOUBLE, FDIST, FIND, FINDB, FINV, FISHER, FISHERINV, FIXED, FLOOR, FORECAST, FORMULATEXT, FREQUENCY, FV, FVSCHEDULE, FALSE

G

GAMMADIST, GAMMAINV, GAMMALN, GCD, GEOMEAN, GESTEP, GROWTH

H

HARMEAN, HLOOKUP, HOUR, HYPGEOMDIST, HYPERLINK

I

IF, IFERROR, IMABS, IMAGINARY , IMARGUMENT, IMCONJUGATE, IMCOS, IMDIV, IMEXP, IMLN, IMLOG10, IMLOG2, IMPOWER, IMPRODUCT, IMREAL, IMSIN, IMSQRT, IMSUB, IMSUM, INDEX, INDIRECT, INT, INTERCEPT, INTRATE, IPMT, ISBLANK, ISERR, ISERROR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISPMT, ISREF, ISTEXT

K

KURT

L

LARGE, LCM, LEFT, LEFTB, LEN, LENB, LINEST, LN, LOG, LOG10, LOGEST, LOGINV, LOGNORMDIST, LOOKUP, LOWER

M

MATCH, MAX, MAXA, MDETERM, MDURATION, MEDIAN, MID, MIDB, MIN, MINA, MINUTE, MINVERSE, MIRR, MMULT, MOD, MODE, MONTH, MROUND, MULTINOMIAL

N

N, NA, NEGBINOMDIST, NETWORKDAYS, NOMINAL, NORMDIST, NORMINV, NORMSDIST, NORMSINV, NOT, NOW, NPER, NPV

O

OCT2BIN, OCT2DEC, OCT2HEX, ODD, ODDFPRICE, ODDLPRICE, ODDLYIELD, OFFSET, OR

P

PEARSON, PERCENTILE, PERCENTRANK, PERMUT, PI, PMT, POISSON, POWER, PPMT, PRICE, PRICEDISC, PRICEMAT, PROB, PRODUCT, PROPER, PV

Q

QUARTILE, QUOTIENT

R

RADIANS, RAND, RANDBETWEEN, RANK, RATE, RECEIVED, REPLACE, REPLACEB, REPT, RIGHT, RIGHTB, ROUND, ROUNDDOWN, ROUNDUP, ROW, ROWS, RSQ

S

SEARCH, SEARCHB, SECOND, SERIESSUM, SIGN, SIN, SINH, SKEW, SLN, SLOPE, SMALL, SQRT, SQRTPI, STANDARDIZE, STDEV, STDEVA, STDEVP, STDEVPA, STEYX, SUBSTITUTE, SUBTOTAL, SUM, SUMIF, SUMPRODUCT, SUMSQ, SUMX2MY2, SUMX2PY2, SUMXMY2, SYD

T

T, TAN, TANH, TBILLEQ, TBILLPRICE, TBILLYIELD, TDIST, TEXT, TIME, TIMEVALUE, TINV, TODAY, TREND, TRIM, TRIMMEAN, TRUE, TRUNC, TTEST, TYPE

U

UPPER, USDOLLAR

V

VALUE, VAR, VARA, VARP, VARPA, VDB, VLOOKUP

W

WEEKDAY, WEEKNUM, WEIBULL, WORKDAY

X

XIRR, XNPV

Y

YEAR, YEARFRAC, YIELD, YIELDDISC, YIELDMAT

Z

ZTEST

Select locked cells

true

Select unlocked cells

true

Format cells

true

Format rows

true

Insert columns

false

Insert rows

false

Insert hyperlinks

false

Delete columns

false

Delete rows

false

Sort

true

Use AutoFilter

true

Use PivotTable reports

true

Edit objects

false

Edit scenarios

false

Edit content

false