InterviewSolution
| 1. |
How Can I Speed Up My Excel-based Data Connector? |
|
Answer» Especially with big files, the performance of MICROSOFT's default file format for excel spreadsheets is getting poor. This WEAKNESS might also affect your data driven test execution. For performance improvements you could use the binary file format (xlsb) instead of the default ONE (xlsx). Simply SAVE your Excel spreadsheet with the extension "xlsb" and assign it to your excel data source. Especially with big files, the performance of Microsoft's default file format for excel spreadsheets is getting poor. This weakness might also affect your data driven test execution. For performance improvements you could use the binary file format (xlsb) instead of the default one (xlsx). Simply save your Excel spreadsheet with the extension "xlsb" and assign it to your excel data source. |
|