Home |
Search |
Today's Posts |
#1
|
|||
|
|||
comparing excel spreadsheets from command line
Hi,
I am running tests here that involve comparing two excel spread sheets. right now we have to manually open the files, copy and paste the contents of each into a separate too, and run a compare. This is time consuming as it involves an awful lot of manual intervention. Ideally, I would like to run some sort of command that takes the two files as params and which outputs (preferable in some sort of graphical format) the differences between the two files. Is that possible? Or am I asking too much? thanks much and have a nice day Graham |
#2
|
|||
|
|||
hi,
see this site. http://www.cpearson.com/excel/duplic...#InOneNotOther FSt1 "grahamo" wrote: Hi, I am running tests here that involve comparing two excel spread sheets. right now we have to manually open the files, copy and paste the contents of each into a separate too, and run a compare. This is time consuming as it involves an awful lot of manual intervention. Ideally, I would like to run some sort of command that takes the two files as params and which outputs (preferable in some sort of graphical format) the differences between the two files. Is that possible? Or am I asking too much? thanks much and have a nice day Graham |
#3
|
|||
|
|||
thanks for that. i checked the site but couldn't see anthing there. I'd like
to do the comparison from the command line if possible, outside of excel. Any ideas? G "FSt1" wrote: hi, see this site. http://www.cpearson.com/excel/duplic...#InOneNotOther FSt1 "grahamo" wrote: Hi, I am running tests here that involve comparing two excel spread sheets. right now we have to manually open the files, copy and paste the contents of each into a separate too, and run a compare. This is time consuming as it involves an awful lot of manual intervention. Ideally, I would like to run some sort of command that takes the two files as params and which outputs (preferable in some sort of graphical format) the differences between the two files. Is that possible? Or am I asking too much? thanks much and have a nice day Graham |
#4
|
|||
|
|||
Excel's file format is way too complex for me to do something like this.
Any chance you could have a macro that asks you for the two filenames and then does the work to dump to a plain text file. You may be able to use some of Chip Pearson's techniques at: http://www.cpearson.com/excel/duplicat.htm grahamo wrote: thanks for that. i checked the site but couldn't see anthing there. I'd like to do the comparison from the command line if possible, outside of excel. Any ideas? G "FSt1" wrote: hi, see this site. http://www.cpearson.com/excel/duplic...#InOneNotOther FSt1 "grahamo" wrote: Hi, I am running tests here that involve comparing two excel spread sheets. right now we have to manually open the files, copy and paste the contents of each into a separate too, and run a compare. This is time consuming as it involves an awful lot of manual intervention. Ideally, I would like to run some sort of command that takes the two files as params and which outputs (preferable in some sort of graphical format) the differences between the two files. Is that possible? Or am I asking too much? thanks much and have a nice day Graham -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
comparing 2 spreadsheets | Excel Discussion (Misc queries) | |||
locking formula for shared excel spreadsheets | Excel Discussion (Misc queries) | |||
importing excel spreadsheets into web-based applications | Excel Discussion (Misc queries) | |||
Viewing Excel spreadsheets | Excel Discussion (Misc queries) |