title: How to script Excel files with Groovy
body: <p>I want to create excel files in Groovy, then have them plotted.  This code was taken from an example using Microsoft's Shell Scripting language:</p>
  
  <pre><code>Set objExcel = CreateObject("Excel.Application")
  objExcel.Visible = True
  Set objWorkbook = objExcel.Workbooks.Add()
  Set objWorksheet = objWorkbook.Worksheets(1)
  
  objWorksheet.Cells(1,1) = "Operating System"
  objWorksheet.Cells(2,1) = "Windows Server 2003"
  objWorksheet.Cells(3,1) = "Windows XP"
  objWorksheet.Cells(5,1) = "Windows NT 4.0"
  objWorksheet.Cells(6,1) = "Other"
  
  objWorksheet.Cells(1,2) = "Number of Computers"
  objWorksheet.Cells(2,2) = 145
  objWorksheet.Cells(3,2) = 987
  objWorksheet.Cells(4,2) = 611
  objWorksheet.Cells(5,2) = 41
  objWorksheet.Cells(6,2) = 56
  
  Set objRange = objWorksheet.UsedRange
  objRange.Select
  
  Set colCharts = objExcel.Charts
  colCharts.Add()
  
  Set objChart = colCharts(1)
  objChart.Activate
  
  objChart.HasLegend = FALSE
  objChart.ChartTitle.Text = "Operating System Use"
  </code></pre>
  
  <p>How would I modify this to work in Groovy?</p>