Difference between revisions of "WriteWorksheetRange"

Latest revision as of 02:45, 9 February 2016

This function has been deprecated. It is now superseded by SpreadsheetSetRange

WriteWorksheetRange(workbook, sheet, range, colIndex, rowIndex)

Writes «value» to a worksheet range, which may be identified either by a named range label or by a cell range.

You should use SpreadsheetSetRange instead of WriteWorksheetRange because WriteWorksheetRange may be removed in future builds of Analytica.

History

WriteWorksheetRange was first made available in an early beta build of 4.2.0, and replaced by SpreadsheetSetRange in beta build 4.2.0.21, so it was never "officially" part of an Analytica release. It was subsequently replaced by SpreadsheetSetRange.

@@ Line 1: / Line 1: @@
-[[Category:Database Functions]]
+[[Category: Obsolete and deprecated functions]]
-#REDIRECT [[Functions to Write Data to Excel Worksheets]]
+''This function has been deprecated.  It is now superseded by [[SpreadsheetSetRange]]''
+== WriteWorksheetRange(workbook, sheet, range, colIndex, rowIndex) ==
+Writes «value» to a worksheet range, which may be identified either by a named range label or by a cell range.
+You should use [[SpreadsheetSetRange]] instead of  [[WriteWorksheetRange]] because [[WriteWorksheetRange]] may be removed in future builds of Analytica.
+==History==
+[[WriteWorksheetRange]] was first made available in an early beta build of 4.2.0, and replaced by [[SpreadsheetSetRange]] in beta build 4.2.0.21, so it was never "officially" part of an Analytica release. It was subsequently replaced by [[SpreadsheetSetRange]].
+==See Also==
+*[[SpreadsheetSetRange]]