Document Solutions for Excel, Java Edition - v9.0

API Reference Use JDK 8 Date Time API Document Solutions Data Viewer Features AI Assistant AI Functions AI.QUERY AI.TEXTSENTIMENT AI.TRANSLATE Sort Conditional Formatting Average Rule Cell Value Rule Color Scale Rule Data Bar Rule Date Occurring Rule Expression Rule Icon Sets Rule Top Bottom Rule Unique Rule Data Validations Add Validations Delete Validation Modify Validation Filter Group Outline Subtotals Create Row or Column Group Outline Column Remove a Group Row or Column Group Information Summary Row Styles Create and Set Custom Named Style Set Sheet Styling Barcodes Codabar Code128 Code39 Code93 Data Matrix EAN-13 EAN-8 GS1- 128 PDF417 QRCode Comments Threaded Comments Print Settings Configure Columns to Repeat at Left and Right Configure Drafts Configure Page Breaks Configure Page Header and Footer Configure Page Settings Configure Paper Settings Configure Print Area Configure Print Page Range Configure Rows to Repeat at Top and Bottom Configure Sheet Print Settings Data Binding Defined Names Digital Signatures Document Properties Form Controls Hyperlinks Import Data Logging Custom Functions Formulas Asynchronous Functions Calculation Mode Cross Workbook Formula Dynamic Array Formulas Formula Evaluation Formula Functions Formula Parser Iterative Calculation LAMBDA Functions Localized Formulas Precedents and Dependents Set Array Formula Set Formula to Range Set Table Formula What-If Analysis Goal Seek Operation Scenarios Workbook Clone Workbook Create Workbook Cut or Copy Across Sheets Enable or Disable Calculation Engine Open and Save Workbook Protect Workbook Workbook Views Worksheet Background Image Customize Worksheets Date and Time Format for a Culture Range Operations Access a Range Access Areas in a Range Access Cells, Rows and Columns in a Range Auto Fit Row Height and Column Width Auto Merge Cells Cut or Copy Cell Ranges Cut or Copy Shape, Slicer, Chart and Picture Find and Replace Data Get Address of Cell Range Get Intersection, Union and Offset Range Get Range and Range Area Get Row and Column Count Get Special Cell Ranges Hide Rows and Columns Ignore Errors in Cell Range Insert And Delete Cell Ranges Insert and Delete Rows and Columns Measure Digital Width Merge Cells Paste or Ignore Data in Hidden Range Protect Cell Range Set Cell Background Image for Cell Range Set Custom Objects to a Range Set Default Values for Cell Range Set Row Height and Column Width Set Values to a Range Work with Used Range Rich Text Tags Cell Types Range Template Cell Quote Prefix Work with Worksheets Worksheet Views Pivot Chart Themes and Colors Chart Chart Sheet Configure Chart Chart Area Chart Title Plot Area Create and Delete Chart Customize Chart Objects Axis and Other Lines Configure Chart Axis Data Table Data Label Floor Legends Series Configure Chart Series Display #N/A Values Error Bars Walls Chart Types Area Chart Bar Chart Column Chart Combo Chart Line Chart Pie Chart Radar Chart Specialized Chart Funnel Sunburst Treemap Statistical Chart Box Whisker Histogram Pareto Chart Waterfall Chart Stock Chart Surface Chart XY (Scatter) chart Pivot Table Pivot Table Style Create Pivot Table Pivot Table Filter Pivot Table Settings Slicer Add Slicer in Pivot Table Add Slicer in Table Slicer Style Modify Slicer with Custom Style Modify Table Layout for Slicer Style Auto-Filter Table with Slicer Configure Slicer Layout Cut or Copy Slicer Duplicate Slicer Use Do Filter Operation Sparkline Table Add and Delete Table Columns and Rows Table Sort Table Style Modify Table Layout Modify Table with Custom Style Convert Table to Range Create and Delete Tables Modify Tables Table Filters Shapes Alternative Text Connector Shapes Group Shapes Hyperlink on Shape Manage Shape Options Manage Shape Text Options Picture Shapes Formula Reference Add-in and Automation Functions EUROCONVERT Compatibility Functions BETADIST BETAINV BINOMDIST CHIDIST CHIINV CHITEST CONFIDENCE COVAR CRITBINOM EXPONDIST FDIST FINV FLOOR FTEST GAMMADIST GAMMAINV HYPGEOMDIST LOGINV LOGNORMDIST MODE NEGBINOMDIST NORMDIST NORM.INV NORMSDIST NORMSINV PERCENTILE PERCENTRANK POISSON QUARTILE RANK STDEV STDEVP TDIST TINV TTEST VAR VARP WEIBULL ZTEST Database Functions DAVERAGE DCOUNT DCOUNTA DGET DMAX DMIN DPRODUCT DSTDEV DSTDEVP DSUM DVAR DVARP Date and Time Functions DATE DATEDIF DATEVALUE DAY DAYS DAYS360 EDATE EOMONTH HOUR ISOWEEKNUM MINUTE MONTH NETWORKDAYS NETWORKDAYS.INTL NOW SECOND TIME TIMEVALUE TODAY WEEKDAY WEEKNUM WORKDAY WORKDAY.INTL YEAR YEARFRAC Engineering Functions BESSELI BESSELJ BESSELK BESSELY BIN2DEC BIN2HEX BIN2OCT BITAND BITLSHIFT BITOR BITRSHIFT BITXOR COMPLEX CONVERT DEC2BIN DEC2HEX DEC2OCT DELTA ERF ERFC ERFC.PRECISE ERF.PRECISE GESTEP HEX2BIN HEX2DEC HEX2OCT 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 OCT2BIN OCT2DEC OCT2HEX Financial Functions ACCRINT ACCRINTM AMORDEGRC AMORLINC COUPDAYBS COUPDAYS COUPDAYSNC COUPNCD COUPNUM COUPPCD CUMIPMT CUMPRINC DB DDB DISC DOLLARDE DOLLARFR DURATION EFFECT FV FVSCHEDULE INTRATE IPMT IRR ISPMT MDURATION MIRR NOMINAL NPER NPV ODDFPRICE ODDFYIELD ODDLPRICE ODDLYIELD PDURATION PMT PPMT PRICE PRICEDISC PRICEMAT PV RATE RECEIVED RRI SLN SYD TBILLEQ TBILLPRICE TBILLYIELD VDB XIRR XNPV YIELD YIELDDISC YIELDMAT Information Functions CELL ERROR.TYPE ISBLANK ISERR ISERROR ISEVEN ISFORMULA ISLOGICAL ISNA ISNONTEXT ISNUMBER ISODD ISOMITTED ISREF ISTEXT N NA SHEET SHEETS TYPE Logical Functions AND BYCOL BYROW FALSE IF IFERROR IFNA IFS LAMBDA MAKEARRAY MAP NOT OR REDUCE SCAN SWITCH TRUE XOR Lookup and Reference Functions ADDRESS AREAS CHOOSE CHOOSECOLS CHOOSEROWS COLUMN COLUMNS DROP EXPAND FILTER FORMULATEXT GETPIVOTDATA GROUPBY HLOOKUP HSTACK HYPERLINK IMAGE INDEX INDIRECT LOOKUP MATCH OFFSET PIVOTBY ROW ROWS SINGLE SORT SORTBY TAKE TOCOL TOROW TRANSPOSE TRIMRANGE UNIQUE VLOOKUP VSTACK WRAPCOLS WRAPROWS XLOOKUP XMATCH Math and Trigonometry Functions ABS ACOS ACOSH ACOT ACOTH AGGREGATE ARABIC ASIN ASINH ATAN ATAN2 ATANH BASE CEILING CEILING.MATH CEILING.PRECISE COMBIN COMBINA COS COSH COT COTH CSC CSCH DECIMAL DEGREES EVEN EXP FACT FACTDOUBLE FLOOR.MATH FLOOR.PRECISE GCD INT ISO.CEILING LCM LET LN LOG LOG10 MDETERM MINVERSE MMULT MOD MROUND MULTINOMIAL MUNIT ODD PERCENTOF PI POWER PRODUCT QUOTIENT RADIANS RAND RANDARRAY RANDBETWEEN ROMAN ROUND ROUNDDOWN ROUNDUP SEC SECH SEQUENCE SERIESSUM SIGN SIN SINH SQRT SQRTPI SUBTOTAL SUM SUMIF SUMIFS SUMPRODUCT SUMSQ SUMX2MY2 SUMX2PY2 SUMXMY2 TAN TANH TRUNC Statistical Functions AVEDEV AVERAGE AVERAGEA AVERAGEIF AVERAGEIFS BETA.DIST BETA.INV BINOM.DIST BINOM.DIST.RANGE BINOM.INV CHISQ.DIST CHISQ.DIST.RT CHISQ.INV CHISQ.INV.RT CHISQ.TEST CONFIDENCE.NORM CONFIDENCE.T CORREL COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS COVARIANCE.P COVARIANCE.S DEVSQ EXPON.DIST F.DIST F.DIST.RT F.INV F.INV.RT FISHER FISHERINV FORECAST FORECAST.LINEAR FREQUENCY F.TEST GAMMA GAMMA.DIST GAMMA.INV GAMMALN GAMMALN.PRECISE GAUSS GEOMEAN GROWTH HARMEAN HYPGEOM.DIST INTERCEPT KURT LARGE LINEST LOGEST LOGNORM.DIST LOGNORM.INV MAX MAXA MAXIFS MEDIAN MIN MINA MINIFS MODE.MULT MODE.SNGL NEGBINOM.DIST NORM.DIST NORMINV NORM.S.DIST NORM.S.INV PEARSON PERCENTILE.EXC PERCENTILE.INC PERCENTRANK.EXC PERCENTRANK.INC PERMUT PERMUTATIONA PHI POISSON.DIST PROB QUARTILE.EXC QUARTILE.INC RANK.AVG RANK.EQ RSQ SKEW SKEW.P SLOPE SMALL STANDARDIZE STDEVA STDEV.P STDEVPA STDEV.S STEYX T.DIST T.DIST.2T T.DIST.RT T.INV T.INV.2T TREND TRIMMEAN T.TEST VARA VAR.P VARPA VAR.S WEIBULL.DIST Z.TEST Text Functions ARRAYTOTEXT ASC BAHTTEXT CHAR CLEAN CODE CONCAT CONCATENATE DBCS DOLLAR EXACT FIND FINDB FIXED JIS LEFT LEFTB LEN LENB LOWER MID MIDB NUMBERVALUE PROPER REPLACE REPLACEB REPT RIGHT RIGHTB SEARCH SEARCHB SUBSTITUTE T TEXT TEXTAFTER TEXTBEFORE TEXTJOIN TEXTSPLIT TRIM UNICHAR UNICODE UPPER VALUE VALUETOTEXT Web Functions ENCODEURL FILTERXML WEBSERVICE Getting Started End User License Agreement DsExcel Dependencies License Information Redistribution Contacting Sales Technical Support Key Features File Operations Convert to Image Export to PDF Adjust Column Width and Row Height Configure Fonts and Set Style Control Pagination Delete Blank Pages From Middle Export Custom Page Information Export Different Headers On Different Pages Export Last Page Without Headers Export Multiple Sheets To One Page Export Specific Pages to PDF Export Worksheet to PDF Keep Rows Together Over Page Breaks Render Excel Range Inside PDF Save Multiple Workbooks to Single PDF Customize Border Style Export Charts Export Slicers Export Barcodes Export Borders Export Conditional Formatting Export Fills Export Form Controls to Form Fields Export Picture Export Pivot Table Styles And Format Export Shapes Export Signature Lines Export Sparkline Export Table Export Text Export Vertical Text Shrink To Fit With Text Wrap Support Document Properties Support Security Options Support Sheet Background Image Support Background Color Transparency Track Export Progress Export to HTML Import and Export .xlsx Document Import and Export CSV File Import and Export CSV Files with Delimiters Import and Export Excel Options Import and Export Excel Templates Import and Export Macros Import and Export OLE Objects Import and Export SpreadJS Files SpreadJS Sparklines SSJSON IO for Features Style and Formatting Settings Support for SpreadJS Features Workbook and Worksheet Settings Import CSV File with Custom Parser Working With Page Setup Document Solutions for Excel, Java Edition Overview Release Notes Breaking Changes Release Notes for Version 8.1.0 Release Notes for Version 8.2.0 Release Notes for Version 9.0.0 Release Notes for Version 2.1.0 Release Notes for Version 2.2.0 Release Notes for Version 3.0.0 Release Notes for Version 3.1.0 Release Notes for Version 3.2.0 Release Notes for Version 4.0.0 Release Notes for Version 4.1.0 Release Notes for Version 4.2.0 Release Notes for Version 5.0.0 Release Notes for Version 5.0.3 Release Notes for Version 5.1.0 Release Notes for Version 5.2.0 Release Notes for Version 6.1.0 Release Notes for Version 6.2.0 Release Notes for Version 7.0.0 Release Notes for Version 7.1.0 Release Notes for Version 7.2.0 Release Notes for Version 8.0.0 Release Notes for Version 6.0.0 Templates Create Excel Report using Template Data Source Binding Template Configuration Charts Conditional Formatting Default Values in Template Cells Fixed Layout Global Settings Paginated Templates Pagination Properties and Functions PDF Form Builder Custom Form Input Types Sparklines Tables Template Properties Cell Context Cell Expansion Template Fields Template Formula Usage