Having issues viewing certain Excel test resources in Quality Center or ALM?
In the past I’ve seen issues with some test resources that used Excel not being viewable in ALM. I was confused why some worked and others did not. It turns out that this is a known issue.
What can cause this ALM Excel behavior?
According to HP its third-party component for QTP does not support Excel files that contain certain formatting. Unfortunately, they don’t specify exactly what formatting cause this but they do supply the following workaround
How to fix
To fix this funky formatting issue HP basically recommends that open your XLS and convert it to .csv then back to XLS. By saving as a .csv file, Excel will remove the formatting that is causing the issue in the .xls file)
- Open up your .xls file that is causing an issue with ALM’s test resource
In excel navigate to File>Save As and save the file as .csv
- Close Excel
- Reopen the .csv file in Excel
- Click File>Save As and save the file back to .xls
- Upload the new .xls file to your ALM resource
Did it work?
After performing the above steps you should now be able to view the resource in Quality Center.