Read an Excel Spreadsheet

Opens and reads the spreadsheet C:\Scripts\New_users.cls, then echoes back the data.

 
 
 
 
 
4.6 Star
(7)
Add to favorites
Office
8/10/2009
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • Minoro error in Description
    2 Posts | Last post August 28, 2012
    • Neat script!
      
      But...
      
      The description reads:
      
      Opens and reads the spreadsheet C:\Scripts\New_users.cls, then echoes back the data. 
      
      This should read:
      
      Opens and reads the spreadsheet C:\Scripts\New_users.xls, then echoes back the data. 
    • True.
  • Thank You
    1 Posts | Last post October 11, 2011
    • I was looking for this to read parameters from an excel to kick off SSRS report through powershell.
      
      Appreciate this.
      Kalpesh
  • Great for a NEWBIE
    1 Posts | Last post December 14, 2010
    • After searching for a day on the web looking for the answer to this (couldn't get any other examples to work) -- found this -- easy to read and it works flawlessly!  I'm on 64 bit Windows 7 - 
      
      Thanks!