OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 1

changes.mady.by.user Wiki Administrator

Saved on

compared with

New Version Current

changes.mady.by.user Unknown User (seank)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Param
sheetIndex
sheetIndex

The 0-based index of the worksheet to move the chart to or the index of the chartsheet to insert.

Exceptions
Exception
IndexOutOfRangeException
IndexOutOfRangeException

An IndexOutOfRangeException will be thrown if sheetIndex is less than 0 or greater than the number of sheets in the workbook.

Exception
ArgumentException
ArgumentException

An ArgumentException will be thrown if chartLocation is ObjectInSheet and the sheet at sheetIndex is a Chartsheet, if chartLocation is ChartAsSheet and there is already as sheet named sheetName or if chartLocation is ChartAsSheet and sheetName is not a valid worksheet name. See Worksheet.Name for a description of what is a valid worksheet name.

Exception
ArgumentNullException
ArgumentNullException

An ArgumentNullException will be thrown if chartLocation is ChartAsSheet and sheetName is null.

Remarks

If chartLocation is ChartAsSheet, this will create a Chartsheet at sheetIndex named sheetName and move the chart to the chartsheet.

If chartLocation is ObjectInSheet, this will move the chart to the worksheet at sheetIndex.

In either case, the chart's formulas (for series data, axis titles, etc) will maintain their original references.

If the chart is inside a chartsheet before calling this method, that chartsheet is deleted.

Scrollbar