Compare 2 Excel Doc's in HTML?!

[mad0maxx]

How do you take two Excel documents and compare them in HTML format?

I tried frames but I am a n00b to HTML... any help is greatly appreciated

 

[lozina]

Excel documents or XML data? confused..

 

[mad0maxx]

Originally posted by: lozina
Excel documents or XML data? confused..

Excel... sorry... heading fixed.

 

[Aikouka]

I'm not sure what you mean by compare them in HTML format... care to elaborate?

 

[mayest]

I'm with Aikouka, I don't know what you mean by "compare," especially because you mentioned that you tried to use frames. Are you trying to display two Excel files in a Web page?

If you really just want to compare two HTML files, one thing that you might try is Word's "Compare and Merge Documents" on the Tools menu. I haven't used that, but Word will read HTML files, so I would imagine that this feature will work with them.

 

[mad0maxx]

Basically display both documents side by side ethier horizontally or vertically so we can look at last years July compared to this years July... something like that.

 

[ahurtt]

I think what he means is he essentially wants a "diff" program that computes the differences between 2 input Excel spreadsheet files and outputs the results in HTML. Is that correct OP? I don't know of any program that does this currently.

 

[mad0maxx]

Originally posted by: ahurtt
I think what he means is he essentially wants a "diff" program that computes the differences between 2 input Excel spreadsheet files and outputs the results in HTML. Is that correct OP? I don't know of any program that does this currently.

Yeah... but does not have to be a program... just a way for it to be visually put into HTML.

 

[mayest]

Does it have to be in HTML? I'm guessing that the answer is yes, but if not do you know that you can do this very easily in Excel? Just open both files and choose Window --> Compare Side by Side with..

You can also do this within a single file. Just open the file and then choose Window --> Arrange, and then do the compare side by side thing.

 

[mad0maxx]

Yeah has to be in HTML so that everyone in the company can look at the data and do not have to distrubute the file everywhere and have many different copies out there...