發問發問
 

已答覆excel.application question

  • Thursday, 2 July, 2009 14:12c0pe 使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     
    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?

解答

  • Saturday, 4 July, 2009 0:42Marco ShawMVP, 版主使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     已答覆
    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.

所有回覆

  • Saturday, 4 July, 2009 0:42Marco ShawMVP, 版主使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     已答覆
    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, 6 July, 2009 15:05c0pe 使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     
    bummer, but I figured that would be the case. Thanks for the confirmation Marco, its appreciated.