Excel.RangeReference interface
Représente une référence de chaîne au format « SheetName ! A1 :B5 " ou une plage nommée globale ou locale.
Remarques
Utilisateur
- Excel.Functions : abs, accrInt, accrIntM, acos, acosh, acot, acoth, amorDegrc, amorLinc, and, arabic, areas, asc, asin, asinh, atan, atan, atanh, aveDev, average, averageA, averageIf, averageIfs, bahtText, base, besselI, besselJ, besselK, besselY, beta_Dist, beta_Inv, bin2Dec, bin2Hex, bin2Oct, binom_Dist, binom_Dist_Range, binom_Inv, bitand, bitlshift, bitor, bitrshift, bitxor, ceiling_Math, ceiling_Precise, char, chiSq_Dist, chiSq_ Dist_RT, chiSq_Inv, chiSq_Inv_RT, choose, propre, code, columns, combina, combina, complex, concaténate, confidence_Norm, confidence_T, convert, cos, cosh, cot, coth, count, countA, countBlank, countIf, countIfs, coupDayBs, coupDays, coupDaysNc, coupNcd, coupNum, coupPcd, csc, csch, cumIPmt, cumPrinc, date, datevalue, daverage, day, days, days360, db, dbcs, dcount, dcountA, ddb, dec2Bin, dec2Hex, dec2Octt, decimal, degrees, delta, devSq, dget, disc, dmax, dmin, dollar, dollarDe, dollarFr, dproduct, dstDev, dstDevP, dsum, duration, dvar, dvarP, ecma_Ceiling, edate, effect, eoMonth, erf, erf_Precise, erfC, erfC_Precise, error_Type, even, exact, exp, expon_Dist, f_Dist, f_Dist_RT, f_Inv, f_Inv_RT, factDouble, find, findB, fisher, fisherInv, fixed, floor_Math, floor_Precise, fv, fvschedule, gamma, gamma_Dist, gamma_Inv, gammaLn, gammaLn_Precise, gauss, gcd, geoMean, geStep, harMean, hex2Bin, hex2Dec, hex2Oct, hlookup, hour, hyperlink, hypGeom_Dist, if, imAbs, imaginary, imArgument, imConjugate, imCos, imCosh, imCot, imCsc, imCsch, imDiv, imExp, imLn, imLog10, imLog2, imPower, imProduct, imReal, imSec, imSech, imSin, imSinh, imSqrt, imSub, imSum, imTan, int, intRate, ipmt, irr, isErr, isError, isEven, isFormula, isLogical, isNA, isNonText, isNumber, iso_Ceiling, isOdd, isoWeekNum, ispmt, isref, isText, kurt, large, lcm, left, leftb, len, lenb, ln, log, log10, logNorm_Dist, logNorm_Inv, lookup, lower, match, max, maxA, mduration, median, midb, min, minA, minute, mirr, mod, month, mround, multiNomial, n, negBinom_Dist, networkDays, networkDays_Intl, nominal, norm_Dist, norm_Inv, norm_S_Dist, norm_S_Inv, not, nper, npv, numberValue, oct2Bin, oct2Dec, oct2Hex, odd, oddFPrice, oddFYield, oddLPrice, oddLYield, or, pduration, percentile_Exc, percentile_Inc, percentRank_Exc, percentRank_Inc, permutationa, phi, pmt, poisson_Dist, power, ppmt, priceDisc, priceMat, product, proper, pv, quartile_Exc, quartile_Inc, quotient, radians, randBetween, rank_Avg, rank_Eq, rate, received, replace, replaceB, rept, right, rightb, roman, round, roundDown, roundUp, rows, rri, sec, sech, second, seriesSum, sheet, sheets, sign, sin, sinh, skew, skew_p, sln, small, sqrt, sqrtPi, standardize, stDev_P, stDev_S, stDevA, stDevPA, substitute, sous-total, sum, sumIf, sumIfs, sumSq, syd, t, t_Dist, t_Dist_2T, t_Dist_RT, t_Inv, t_Inv_2T, tanh, tbillEq, tbillEq, tbillPrice, tbillYield, text, time, timevalue, trimMean, trunc, type, unichar, unicode, upper, usdollar, value, var_P, var_S, varA, varPA, vdb, vlookup, weekday, weekNum, weibull_Dist, workDay, workDay_Intl, xirr, xnpv, xor, yearFrac,yield, yieldDisc, yieldMat, z_Test
Propriétés
| address | Adresse de la plage, par exemple « SheetName ! A1 :B5". |
Détails de la propriété
address
Adresse de la plage, par exemple « SheetName ! A1 :B5".
address: string;
Valeur de propriété
string