I am working on creating an excel workbook that creates 10 worksheets and randomly add's numbers to a group of 10,000 cells. I am stuck on getting the random part to each cell. Individually it is working, but as a group it is not. Any help would be greatly appreciated!
Here is the code I have so far:
$Excel01 = New-Object -ComObject Excel.Application
$Excel01.Visible = $True
$Excel01.SheetsInNewWorkbook = 10
$Workbook01 = $Excel01.Workbooks.Add()
$Worksheet01 = $Workbook01.Sheets.Item(1)
$Worksheet01.Cells.Item(1,1) = "This Works!"