Autocomplete
| API | Description | Example |
|---|---|---|
| Range.AutoComplete | Function that returns an auto-expanded string for a specific string, limited to single cells | let a1Cell = instance.Application.ActiveSheet.Range("A1"); a1Cell.Value2 = "Example"; console.log(a1Cell.AutoComplete("Ex")); // Auto-completed to Example and output to console |
| Range.AutoFill | Function that performs data auto-completion based on data in the specified range | let range = instance.Application.ActiveSheet.Range("A1:A2"); let target = instance.Application.ActiveSheet.Range("A1:A4"); // Target range must include the auto-completion reference range range.AutoFill(target); |
Related Features
Data Processing , Built-in Function Libraries , Pivot Table Creation and Editing , Data Validation , Filter and Sort , Find and Replace