Ask a Question

Best method to compare large data sets without opening excel

TestQA1
Frequent Contributor

Best method to compare large data sets without opening excel

Hi,

 

My team wants to avoid use of excel in our BDD script tests and opening the excel was causing lot of issues.

 

Is there any alternative method that would be helpful to compare the different data sets without having to open any text or excel file manually?

 

Thank you.

2 REPLIES 2
Marsha_R
Community Hero

Working with text files is less complicated than working with Excel. That's the way I would write it.

 

https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/text...

 

 


Marsha_R
[Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame
rraghvani
Trusted Contributor

If you have an Excel file named Book1.xlsx, rename the file to Book1.xlsx.zip. If you then open the zip file, there will be several files which makes up the Excel document. These files you can compare without the need of Excel

 

rraghvani_0-1656086386007.png

 

cancel
Showing results for 
Search instead for 
Did you mean: