This Powershell Module will allow users to interact with MS excel versions based on openxml (MS Office 2007 and 2010).
Dependencies:
Note: you do not need MS excel or MS Office to be installed on the server or machine that runs this module.
Module Features:
- Create new excel files, modify existing files.
- Add - Delete - Copy - Rename - Move worksheets within a workbook
- Import Text files ( tab,comma,space,fixed width)
- Import a bunch of csv files as separate worksheets into a single excel file.
- Create tables and set built-in table styles
- Create DefinedNames
- Insert PageBreaks,SplitPanes,FreezePanes.
- Add Conditional Formatting Iconsets,Databars,ColorScale,& Highlighting
- Add DataValidation
- Merge/Unmerge cells, set built-in cell styles Eg: Good,Bad,Calculation etc
- Support for PasteSpecial: 'Formatting','Formulas','Paste','Values','Transpose'
- Sort & Filter data
- AutoFit Rows & Columns
- Hide Rows & Columns
- Group/ungroup rows, columns
- Protect/Unprotect worksheets
- Set Row height & column width
- Set document Metadata such as Author,Category,Keywords etc
- Show/hide gridlines from one or all worksheets in a workbook
- set Font, Alignment, border, fill, gradient fill etc.
Data can come from any powershell cmdlet(eg. Get-Service) or function that outputs objects
Most cmdlets in this module support pipeline input which will enable users to obtain the desired output with a minimum of code.
Online HTML Help
http://kiran-reddy.in/projects/powershell-excel/Note: This module has been tested on MS Excel version 2007 and 2010 only.