Excel Spreadsheet in Internet Browser Control as Extended Viewport

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 ()
   )