ShahZaib
3 years agoContributor
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 verify their visibility
Is there any sample script that I can use
Thanks
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()); } }
Thanks a lot this solves all my problems
Thank you once again for all the effort