Previous Topic Next Topic

Compare Excel sheets using Python

Closed
ramya515 Posts 1 Registration date Monday October 29, 2018 Status Member Last seen November 1, 2018 - Updated on Nov 1, 2018 at 01:06 PM
 Blocked Profile - Nov 1, 2018 at 05:11 PM
Hello,

Can you please solve this question.To compare two excel sheets and copy unlike data to a third sheet which is not deduplicated.Can you please resolve this in python code,I am not getting in python

Ramya
Related:

1 response

Answer 1 / 1
Blocked Profile
Nov 1, 2018 at 05:11 PM
UM, Excel is a proprietary format. You will need to pass your python script to a VBA control and have a VBA middleware break it back into something python can work with!

Similar discussions

macro to compare two excel sheets
annajins -
Aks -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
Macro to compare sheets(Jan & Feb), highlight the difference, copy the comme
drsuresh26 -
ac3mark -

1 response