Forum Discussion
Spreadsheet Compare command line
I am a big fan of the built-in Spreadsheet compare tool that is part of Office 365.
I need to run this tool from a cmd to embed it in a script.
I can run it and send the command line arg that points to the file that contains the 2 files to compare.
This opens the app with the comparison already done and then I can export the result.
However, I need to automate that extra mile as well and be able to export the results without really opening the tool GUI and manually exporting it.
How can this be achieved?
1 Reply
yairogen This can't be done via command line, but you should be able to do it with Power Automate Desktop (PAD), which should be free to use for something like this. With PAD, you can record the steps that you would take in the GUI and have it replay those steps automatically. You would need to do some extra work to make it flexible if you want to be able to run it for different sets of files, use a variable export file name, etc.
