XLL+ Class Library (7.0)

CXlMacros::DataSeries

Equivalent to choosing the Series command from the Fill submenu on the Edit menu

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
);

Parameters

rowcol

Rowcol is a number that specifies where the series should be entered. A value of 0 is treated as a missing argument.

type_num

Type_num is a number from 1 to 4 that specifies the type of series.

date_num

Date_num is a number from 1 to 4 that specifies the date unit of the series.

step_value

Step_value is a number that specifies the step value for the series.

has_stop_value

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

Stop_value is a number that specifies the stop value for the series. It is ignored if has_stop_value is false.

trend

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.

Return Value

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.

Remarks

See the Microsoft Excel on-line Help for full details about this function.

Requirements

Header: xlfuncs.h

See Also

CXlMacros Class | CXlMacros Methods