Example of Auto Fill & Fill Series in ASP.NET MVC Excel (XlsIO) Library
This sample demonstrates how to use the Auto Fill and Fill Series options using XlsIO.
DEMO
SOURCE
Click the "Create Document" button to generate and view the Excel file. You can enter the Step Value and Stop Value as either a number or a date in MM/DD/YYYY format, and the generated document can be opened using Microsoft Excel or Excel Viewer.
The Auto Fill and Fill Series features enable users to programmatically populate a range of Excel cells based on defined patterns, sequences, or trends. These capabilities help reduce manual data entry by automatically generating values using built-in logic.
Features:
- Allows automatic filling of cells with common sequences, including numbers, months, and custom patterns.
- Offers Fill Series options, including linear, growth, and date-based sequences.
- Supports configuration of step value, stop value, series direction, and trend usage.