Forum Discussion

ShahZaib's avatar
ShahZaib
Contributor
2 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...
  • rraghvani's avatar
    2 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
    2 years ago

    Thanks a lot this solves all my problems 

    Thank you once again for all the effort