Excel integration - Easylanguage

Questions about MultiCharts and user contributed studies.
x3p0
Posts: 9
Joined: 29 Feb 2008
Been thanked: 1 time

Excel integration - Easylanguage

Postby x3p0 » 09 Apr 2017

Hello,

Is there any update to be released in the near future that will incorporate the excel workbook class component for integration between MC and excel? Such as can be seen on TS's easylanguage?

http://help.TS.com/09_00/tsde ... _class.htm

Thanks

x3p0
Posts: 9
Joined: 29 Feb 2008
Been thanked: 1 time

Re: Excel integration - Easylanguage

Postby x3p0 » 09 Apr 2017

Workbook Class (Component)

The Workbook allows you to read and write values to cells from a specified Excel workbook and spreadsheet that may be used in EasyLanguage analysis techniques and strategies.

Typically, you will use the Toolbox to add a component to your EasyLanguage document. Click and drag the name Workbook into your document from the Toolbox. By default, the name of the Workbook appears in the component tray at the bottom of your document followed by a number (to help identify multiple instances of the component). The file name and full path are entered using the FileName property. The Excel file must exist before the analysis technique or strategy is run.

Individual cells are addressed in the form [column, row]. For example, to import string cell data from the third column, fourth row of the left-most tabbed worksheet into RadarScreen use:

plot1(workbook1.sheets[1].CellsAsString[3,4]);

Specific Excel workbook sheets may be addressed using an index number to reference the tabbed sheets from left to right. The far left tab is sheet 1; the next one to the right is 2, etc. For example, a cell in sheet 2 is assigned a string value.

workbook1.sheets[2].CellsAsString[3,3]= "Data11";

Excel workbook sheets may also be addressed using the exact tab name of the spreadsheet.

workbook1.sheets["DatasheetTab1"].CellsAsDouble[1,3]= 456.65;

By default, changes to Excel are not saved. To save changes, set SaveOnClose to true.

Namespace: elsystem.office.excel

[ Expand All ]
Properties
Name Type Description
Public property ActiveSheet integer The index number of the active worksheet (default property).
Public property FileName string The name of the Excel spreadsheet file on your computer.
Public property Load boolean True to load and open the connection to the spreadsheet.
Public property SaveOnClose boolean True to save changes made to the spreadsheet when closing the connection.
Public property Shared boolean True to share a single Excel spreadsheet across multiple Workbook objects. False if not shared.
Public property SheetCount integer Specifies the number of sheets in the workbook.
Public property Sheets[index] object Access a Sheet based on an index of available sheets.
Public property Sheets[sSheetName] object Access a Sheet based on a specified sheet name string.
Public property Visible boolean True to display the spreadsheet when connected or False to update the spreadsheet without viewing.
Methods
Inheritance Hierarchy


Return to “MultiCharts”