Spreadsheet Compare

English support forum

Moderators: white, Hacker, petermad, Stefan2

Post Reply
User avatar
Damel
Member
Member
Posts: 130
Joined: 2003-02-06, 01:11 UTC
Location: Prague, Czech Republic

Spreadsheet Compare

Post by *Damel »

Hi, I want to compare 2 excel files (xls, xlsx), to figure out where the changes was made. I have the MS Office 2016 and I use this button:

Code: Select all

TOTALCMD#BAR#DATA
%ProgramFiles(x86)%\Microsoft Office\Office16\DCF\SPREADSHEETCOMPARE.EXE
%UL
%ProgramFiles(x86)%\Microsoft Office\Office16\DCF\SPREADSHEETCOMPARE.EXE
Spreadsheet Compare

-1
-1
And it works fine, if both files are in the same dir. But, and this is way more often, if is one file in left and another in right panel, then this obviously cannot work. So I tried to use %C1 %C2 instead, but that was bad idea. The SPREADSHEETCOMPARE.EXE crashed and excel file in left panel was deleted, permanently (I had to use Recuva to recover him). Take this as warning advice! So.. do you have any idea how to solve this without copying files into only one panel (with renaming, because they have in most situation same name)?

Thank you for your advices.
The best solution:
1. format C:
2. install TotalCmd
3. install Windows (optionally)
User avatar
Ovg
Power Member
Power Member
Posts: 756
Joined: 2014-01-06, 16:26 UTC

Post by *Ovg »

2Damel
Try %X%P%N %X%T%M for files in left and right panels.
It's impossible to lead us astray for we don't care even to choose the way.
#259941, TC 11.01 x64, Windows 7 SP1 x64
User avatar
Horst.Epp
Power Member
Power Member
Posts: 6450
Joined: 2003-02-06, 17:36 UTC
Location: Germany

Re: Spreadsheet Compare

Post by *Horst.Epp »

Damel wrote:Hi, I want to compare 2 excel files (xls, xlsx), to figure out where the changes was made. I have the MS Office 2016 and I use this button:

Code: Select all

TOTALCMD#BAR#DATA
%ProgramFiles(x86)%\Microsoft Office\Office16\DCF\SPREADSHEETCOMPARE.EXE
%UL
%ProgramFiles(x86)%\Microsoft Office\Office16\DCF\SPREADSHEETCOMPARE.EXE
Spreadsheet Compare

-1
-1
And it works fine, if both files are in the same dir. But, and this is way more often, if is one file in left and another in right panel, then this obviously cannot work. So I tried to use %C1 %C2 instead, but that was bad idea. The SPREADSHEETCOMPARE.EXE crashed and excel file in left panel was deleted, permanently (I had to use Recuva to recover him). Take this as warning advice! So.. do you have any idea how to solve this without copying files into only one panel (with renaming, because they have in most situation same name)?

Thank you for your advices.
If %C1 %C2 crashes your program then this its not a TC fault.
TC just invokes your program with the files you have selected.
Windows 11 Home x64 Version 23H2 (OS Build 22631.3374)
TC 11.03 x64 / x86
Everything 1.5.0.1371a (x64), Everything Toolbar 1.3.2, Listary Pro 6.3.0.69
QAP 11.6.3.2 x64
User avatar
nsp
Power Member
Power Member
Posts: 1804
Joined: 2005-12-04, 08:39 UTC
Location: Lyon (FRANCE)
Contact:

Post by *nsp »

It is known that SPREADSHEETCOMPARE destroy the file passed as parameter as the file should only contain a list of file to study.
In your case, you must create a txt file with both file path and then use SPREADSHEETCOMPARE.EXE.

You can make a batch like <MyPath To>\excelcmp.cmd:

Code: Select all

@echo off 
echo %1 > "%temp%\excelcmp.txt"
echo %2 >> "%temp%\excelcmp.txt"

"%ProgramFiles(x86)%\Microsoft Office\Office16\DCF\SPREADSHEETCOMPARE.EXE"  "%temp%\excelcmp.txt"
And then

Code: Select all

TOTALCMD#BAR#DATA
<MyPath to>\excelcmp.cmd
%C1 %C2
%ProgramFiles(x86)%\Microsoft Office\Office16\DCF\SPREADSHEETCOMPARE.EXE
Spreadsheet Compare

-1
-1 
First, you could try it manually to ensure that all is working as expected !
User avatar
Damel
Member
Member
Posts: 130
Joined: 2003-02-06, 01:11 UTC
Location: Prague, Czech Republic

Post by *Damel »

Thank you all, but none of that works.

2Ovg: It invoke "Please specify two files to compare" msg window only.

2nsp: Spreadsheet Compare crashed when this is used.

So propably there is not a way to compare two Excel spreadsheets if they are not in one panel. :(
The best solution:
1. format C:
2. install TotalCmd
3. install Windows (optionally)
Post Reply