Test Scenarios for Excel Export functionality

標籤：excel   ble   with   win   port   standards   ali   names   tin   

1 File should get exported in proper file extension
2 File name for the exported excel file should be as per the standards e.g. if file name is using timestamp, it should get replaced properly with actual timestamp at the time of exporting the file
3 check for date format if exported excel file contains date columns
4 check number formatting for numeric or currency values. Formatting should be same as shown on page
5 exported file should have columns with proper column names
6 default page sorting should be carried in exported file as well
7 excel file data should be formatted properly with header and footer text, date, page numbers etc. values for all pages
8 check if data displayed on page and exported excel file is same
9 check export functionality when pagination is enabled
10 check if export button is showing proper icon according to exported file type e.g. excel file icon for xls files
11 check export functionality for files with very large size
12 check export functionality for pages containing special characters. Check if these special characters are exported properly in excel file

 

Test Scenarios for Excel Export functionality