What is the Equivalent of Excel's VBA Clean Function in Autoit?

[TheOne23]

Hi Experts,

 

May i seek your help if someone knows What is the Equivalent of Excel's VBA Clean Function in Autoit?

application.worksheetfunction.clean(text) ------- VBA

AutoIT---- ? 

[water]

Functions you can call from VBA can be called from AutoIt (using COM) as well.
Untested:

#include <Excel.au3>
Global $oExcel = _Excel_Open()
Global $sCleanString = $oExcel.WorksheetFunction.Clean("StringToBeCleaned")

 

[TheOne23]

Hi Water,

 

Thank you for the answer.

Will below code work?

#include <Excel.au3>
Global $oExcel = _Excel_Open()

$oWorkbook1 = _Excel_BookOpen($oExcel, @ScriptDir & "\Test.xlsx" , false, True)

$LastRow_test = $oWorkbook1.ActiveSheet.Range("A1").SpecialCells($xlCellTypeLastCell).Row

For $i = 1 to $LastRow_test step 1

    Global $sCleanString = $oExcel.WorksheetFunction.Clean("A" & $i)     ; ("StringToBeCleaned")

Next

 

[seadoggie01]

Really only one way to find out, lol

You really shouldn't declare variables inside of a loop like that though. You're overwriting it each time the loop executes as well, so only the last string will be picked up

[water]

I don't think so. According to the docu you need to pass the value of a cell to the Clean function.
Untested:

$sCleanString = $oExcel.WorksheetFunction.Clean($oExcel.ActiveSheet.Range("A" & $i).Value)     ; ("StringToBeCleaned")

 

Edited May 11, 2020 by water

[TheOne23]

Hi Water,

Thank you very much on your correction. I really appreciate it. I will try it now and will give updates.

Cheers to AutoIt Wizards!