convertExcelFormula

swordfish.function.convertExcelFormula()

Convert Excel formula to DolphinDB expressions.

Parameters:

• formula (Constant) – A STRING scalar/vector indicating an Excel formula.

• colStart (Constant) – A STRING scalar indicating the starting column of the data in Excel.

• colEnd (Constant) – A STRING scalar indicating the ending column of the data in Excel.

• rowStart (Constant) – A positive integer indicating the starting row of the data in Excel.

• rowEnd (Constant) – A positive integer indicating the ending row of the data in Excel. rowEnd must be greater than or equal to rowStart.