Automate Excel with PowerShell

In this video I go over how to do various tasks in Excel using PowerShell.

00:00 | Introduction
01:20 | Load Workbook
03:20 | Get number of rows in Worksheet
05:09 | Get Cell Value
06:06 | Change Cell Value
08:14 | Get All Sheets
09:26 | Add a new Worksheet
10:30 | Change Worksheet Name
13:32 | Create new Workbook
18:10 | Write to Workbook
23:10 | Merging Cells
28:16 | Styling Cells
30:13 | Inserting / Deleting Rows
33:58 | Calculation of Averages

[sunset]

From a text file I want to import the information into an Excel box to fill in certain set fields. Is it possible to do that?
thanks!

[sridhar]

Hi, I want a script to get a sum of columns calculation.
For example:I have data in A1 =10, A2=20, =A3=5, then output should be 35.