Example of Auto Fill and Fill Series in ASP.NET Core Excel (XlsIO)

This sample demonstrates how to use the Auto Fill and Fill Series options with 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.

Fill Type:	Auto Fill Fill Series
Fill Option:
Series In:
	Trend
Step Value:
Stop Value:

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.