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

Thanks a lot this is working like a charm

One more thing to verify the frozen column in excel I have used the following command 

$excel = New-Object -Com Excel.Application

$excel.Visible = $True

$wb = $Excel.Workbooks.Add()

$ws = $wb.Worksheets.Add()

$ws.Activate()

$ws.Select()

$excel.Columns.Item(1).Select()

$excel.ActiveWindow.FreezePanes

Its always returns true for me, Can you please guide me on this