Sign in
Microsoft.com
 
Script Center
 
 
 
Script Center > Scripting Forums > The Official Scripting Guys Forum! > excel.application question
Ask a questionAsk a question
Search Forums:
 

Answerexcel.application question

  • Thursday, July 02, 2009 2:12 PMc0pe Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Hello,

    I need to work on a script that will process some excel files. The machine I am using to develop the script on does not have excel installed.... will installing the latest version of the Excel Viewer install the necessary components? Or is the only way to install the full blown excel app?
     

Answers

  • Saturday, July 04, 2009 12:42 AMMarco ShawMVP, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    1
    Sign In to Vote
    The Excel Viewer only gives you read-only access to documents and doesn't provide the COM interface.

    You'll need the full version...  Unless you somehow export the files to CSV, then PowerShell can deal with the data relatively easily.
     

All Replies

  • Saturday, July 04, 2009 12:42 AMMarco ShawMVP, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    1
    Sign In to Vote
    The Excel Viewer only gives you read-only access to documents and doesn't provide the COM interface.

    You'll need the full version...  Unless you somehow export the files to CSV, then PowerShell can deal with the data relatively easily.
     
  • Monday, July 06, 2009 3:05 PMc0pe Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    bummer, but I figured that would be the case. Thanks for the confirmation Marco, its appreciated.