StarUML - Excel

excel.js

// See an example in the StarUML translator  for excel
//   (StarUML\modules\staruml-generator\translators\excel\ExcelTranslator.js)


var excel = new ActiveXObject("Excel.Application"); 
excel.visible = true ;
excelWorkbook = excel.Workbooks.Open(excelfile);
// xlNormal = -4143 (&HFFFFEFD1)
// ...
excelWorkbook.SaveAs(outputFilename, -4143, "", "", false, false);
excelWorkbook.Close();




staruml.log( excel.Worksheets("Sheet1").Range("A1").Value ) ;


for(var i = 1; i <= excelWorkbook.Sheets.Count; i++) {
  var excelSheet = excelWorkbook.Sheets(i);
  excelSheet.Select();
  ...
}



== Excel VBA == 
=== Information Source === 
* http://www.excel-vba.com/excel-vba-contents.htm 
=== Important Classes 
==== Worksheet ====
==== Range ==== 
* Column, number of the first column
* Row, number of the first row
* Columns.Count
* Rows.Count
* Item, an cell in the range in relative coordinate
* Offset
==== Name ====
* Name
* RefersToRange
* RefersToR1C1