Excel Spreadsheet in Internet Browser Control as Extended Viewport

NOTE:

ActiveX Controls have been deprecated by Microsoft in the latest versions of the Windows operating system in favor of the DotNet framework and its controls.

While MAXScript still supports ActiveX controls, these have to be installed and registered on the system to be accessible to MAXScript.

As a replacement of ActiveX controls, MAXScript supports DotNet controls in 3ds Max 9 and higher.

Creates a Microsoft Excel spreadsheet inside an embedded Microsoft Internet Explorer browser control. It also registers the rollout as an extended viewport -

SAMPLE SCRIPT

rollout rExcel "Excel"
(
activeXControl ax "e:\\test.xls" height:250 width:370 align:#center
)
fExcel = newRolloutFloater "Excel" 390 270
addRollout rExcel fExcel
format "----Application----"
showProperties rExcel.ax.application
format "----Parent----"
showProperties rExcel.ax.parent
format "----Container----"
showProperties rExcel.ax.container
-- In case of MS Excel .document points to the msexcel.workbook
workbook = rExcel.ax.document
format "----Document----"
showProperties workbook showHidden:true
showMethods workbook showHidden:false
props = getPropNames workbook
sort props 
for prop in props do
(
try
(
format "\t%=%\n" (prop as string) (getProperty workbook prop)
) catch ()
)

Excel Spreadsheet in Internet Browser Control as Extended Viewport

See Also