Execute Excel Formula with Powershell

Welcome Forums General PowerShell Q&A Execute Excel Formula with Powershell

This topic contains 1 reply, has 2 voices, and was last updated by

10 months, 3 weeks ago.

  • Author
  • #103423

    Topics: 18
    Replies: 30
    Points: 50
    Rank: Member

    I can execute the following formula in Excel and it gets the last price of IBM
    =RTD("tos.rtd", , "LAST", "IBM")

    How can execute something similar using PowerShell ?

    (The above formula was taken from https://www.stock-data-solutions.com/realtimetodb/rtd-database-quotes-tos-rtd.htm )


  • #103513

    Topics: 0
    Replies: 4
    Points: 0
    Rank: Member

    well, I can suggest you that you should follow these things:
    Most of the time in excel to find how many "string" is used in a row we use

    I would like to call this function (=NB.SI(range," string") ) with a PowerShell script.

    I tried to use$objExcel.worksheetFunction.Match("string",range) but it wasn't useful.

The topic ‘Execute Excel Formula with Powershell’ is closed to new replies.

denizli escort samsun escort muğla escort ataşehir escort kuşadası escort