How to write test results to an existing Excel table in Python (ii)

Today Friday, oh, the most happy every month is the Friday and pay the day, hehe. I wish you a happy weekend here in advance.

Last time I shared how to implement single interface automation with the Python+excel table, today and we say, how to automatically write test results to the original Excel table.

Because I used to have a database +python do automation, divided into two tables one is Test_data, one is Test_report, after the column and test results to write directly to a table, so chose to use Excel+python. Here is the part of the Code implementation

This time with our WAP terminal login function module, python+selenium+excle, with GCA, we need to write the results of our code judgments automatically into the "Final_reslut" field, if and Expected_reslut Consistency means success.

Next is the Code implementation section

After running, you get the result:

Can you see that the Final_result field already has content, so that we can not achieve the desired effect? If you have any questions about the code of my login module, I will update my login module code next time so that you will understand it more easily.

We can encapsulate it as a common module and combine it with other column modules for this write to an existing Excel table. Next time I will continue to update, it is here today oh.

More information or software downloads can follow my blog or join the following groups, qq:511213522/461085465

We exchange software tests together and progress together.

How to write test results to an existing Excel table in Python (ii)