Test Scenarios for Excel Export functionality

1 file should get exported in proper file extension
2 file name for the exported Excel file should are 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 is same as shown on page
5 exported file should has columns with proper column names
6 default page sorting should is carried in exported file as well
7 Excel file data should is 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
Check if Export button is showing proper icon according to exported file type e.g. Excel file icon for XLS files
Check export functionality for files with very large size
Check export functionality for pages containing special characters. Check If these special characters is exported properly in Excel file

Test Scenarios for Excel Export functionality