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.

Last edited Dec 1, 2014 at 1:33 AM by touchstone_81, version 9