XLL+ Class Library (7.0)


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



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.

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.


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


Header: xlfuncs.h

See Also

CXlMacros Class | CXlMacros Methods