OpenInWorksheet

The OpenInWorksheet method opens a document in the worksheet view, even if it usually opens in the plot view (like BLN or DXF files). This is particularly beneficial for editing file types that contain vector graphics (like BLN or DXF) that might default to opening in the plot view. The method returns a Document object.

Syntax

object.OpenInWorksheet( filename, options)

 

Parameter	Type	Required / Optional	Default	Description
filename	[in] BSTR	Required	n/a	The worksheet file's full path and file name including extension to open.
options	[in, optional] VARIANT	Optional	""	May contain combination of worksheet import options strings, such as "Sheet=sheet2".

 

Example 1

Set MultiSheetxlsx_Sheet1_doc = Grapher.Documents.OpenInWorksheet("D:\Temp\MultiSheet.xlsx","Sheet=Sheet1")

Example 2

This example demonstrates how to open a BLN file in the worksheet view

Set blnWks = Grapher.Documents.OpenInWorksheet("D:\Temp\DemoRect.bln")

 

Used by: Documents collection