We are building a new experience for our SmartBear Community.
This site is now read-only. You can still browse and search as usual. Learn More

Forum Discussion

ShahZaib's avatar
ShahZaib
Contributor
3 years ago
Solved

Verify Frozen columns in Excel

Hi   1. I have frozen a few columns in the MSExcel and I want to verify via script testing how many columns are frozen 2. Similarly, I have marked a few columns as hidden and again I want to verif...
data-driven testing
desktop testing
object recognition
script tests
Variables
  • rraghvani's avatar
    rraghvani
    3 years ago

    For example,

     

    function Test()
{
    var oExec = WshShell.Exec("powershell.exe -Command \"C:\\Temp\\Book2.ps1\" -excelfile \"C:\\Temp\\Book2.xlsx\"");
    while (oExec.Status == 0) {
        aqUtils.Delay(1000);
    }
    while (!oExec.StdOut.AtEndOfStream) {
        Log.Message(oExec.StdOut.ReadLine());
    }
}

     

     

  • ShahZaib's avatar
    ShahZaib
    3 years ago

    Thanks a lot this solves all my problems 

    Thank you once again for all the effort

ShahZaib's avatar
ShahZaib
Contributor
3 years ago

Thank you very much for your help this is perfect

One more question how can I pass a parameter from test complete to Powershell

for example, in the above script if I want file path to be a variable getting its value from the test complete

$excel = New-Object -ComObject Excel.Application
$workbook = $excel.Workbooks.Open('C:\Temp\Book2.xlsx')