發問發問
 

已答覆excel.application question

  • 2009年7月2日 下午 02: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?

解答

  • 2009年7月4日 上午 12: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.

所有回覆

  • 2009年7月4日 上午 12: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.
  • 2009年7月6日 下午 03:05c0pe 使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     
    bummer, but I figured that would be the case. Thanks for the confirmation Marco, its appreciated.