Sign in
 
Home20132010Other VersionsLibraryForumsGallery

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
  • Hide
    Minoro error in Description
    2 Posts | Last post August 28, 2012
    • Written August 15, 2010 
      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.
    • Written August 28, 2012 
      True.
  • Hide
    Thank You
    1 Posts | Last post October 11, 2011
    • Written October 11, 2011 
      I was looking for this to read parameters from an excel to kick off SSRS report through powershell.

Appreciate this.
Kalpesh
  • Hide
    Great for a NEWBIE
    1 Posts | Last post December 14, 2010
    • Written 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!