Rosetta Xtra - Excel Functions

The Excel functions allow Director developers to create charts, create spreadsheets, control, print and export image with Microsoft Excel. Rosetta uses Microsoft Excel automation to communicate and control the Excel application. Microsoft Excel is required for these functions to work. The recommended version is Excel 97 or above. Some of Rosetta's features may not work correctly in Excel 95.

When using the Excel functions with Rosetta xtra, please refer to the layer diagram for details on functionality scope.

Application
|----> Workbook
|--------> Worksheet
|------------> Cell Range

As an example, to add text to on a blank presentation, you will need to:

Launch Excel ( Application level )
Create blank presentation ( Workbook level )
Select Range ( Worksheet level )
Insert Text ( Text objects level )

Method summary for Microsoft Excel

Method
xlsInstalled()	xlsSetRange()
xlsLaunch()	xlsWidth()
xlsNewBlank()	xlsHeight()
xlsOpen()	xlsData()
xlsSave()	xlsInsertTxt()
xlsSaveAs()	xlsSetFont()
xlsClose()	xlsSetFontSize()
xlsQuit()	xlsSetFontColor()
xlsCount()	xlsSetFontStyle()
xlsGo()	xlsSetAlignment()
xlsSetVisible()	xlsSetNumberFormat()
xlsSetWinRect()	xlsInsertImg()
xlsColumnWidth()	xlsInsertChart()
xlsSetColumnWidth()	xlsExportChart()
xlsRowHeight()	xlsPrint()
xlsSetRowHeight()	xlsErr()
xlsAddSheet()