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

rraghvani's avatar
rraghvani
Icon for Champion Level 3 rankChampion Level 3
3 years ago

Here's the PowerShell script code,

$excel = New-Object -ComObject Excel.Application
$workbook = $excel.Workbooks.Open('C:\Temp\Book2.xlsx')
$worksheet = $workbook.Worksheets('Sheet1')
Write-Host "Is column 3 hidden?" $worksheet.Columns.Item(3).Hidden
Write-Host "Is row 4 hidden?" $worksheet.Rows.Item(4).Hidden
Write-Host "Is freeze pane enabled?" $excel.ActiveWindow.FreezePanes
$excel.Quit()
[System.Runtime.InteropServices.Marshal]::ReleaseComObject($excel) | Out-Null

 Which checks the Excel spreadsheet,