Equivalent to choosing the Series command from the Fill submenu on the Edit menu
[C++]
static int DataSeries(
unsigned short rowcol = 0,
unsigned short type_num = 1,
unsigned short date_num = 1,
double step_value = 1.0,
bool has_stop_value = false,
double stop_value = 0.0,
short int trend = -1
);
Rowcol is a number that specifies where the series should be entered. A value of 0 is treated as a missing argument.
Type_num is a number from 1 to 4 that specifies the type of series.
Date_num is a number from 1 to 4 that specifies the date unit of the series.
Step_value is a number that specifies the step value for the series.
has_stop_value is a logical value that specifies whether the series has a stop_value. If it is false, then stop_value will be treated as missing.
Stop_value is a number that specifies the stop value for the series. It is ignored if has_stop_value is false.
Trend is a logical value corresponding to the Trend check box. A value of -1 is treated as a missing argument, A value greater than 0 is treated as TRUE, and 0 is treated as FALSE.
Zero if the function has been called successfully; non-zero
if the function could not be called.
See Error codes for a list
of return values.
See the Microsoft Excel on-line Help for full details about
this function.
Header: xlfuncs.h