Home

New in Version 1.0.1.3:

Clarified error messages, eliminated apparent and unnecessary stack trace messages.

New in Version 1.0.1.2:

Fixed typos in error messages, improved aesthetics of GUI slightly.

New in Version 1.0.1.1:

Primary key column from the input spreadsheets will be the leftmost column in the output spreadsheet.

Fixed bug where .xls files with more than one sheet cannot be processed.

Changed minimum number of .xls files from two (2) to one (1). This allows combining all the sheets
in a single .xls files into one sheet.

If two cells in different spreadsheets have different contents but occur in the same row and column,
then there is a discrepancy. In previous versions, this discrepancy was ignored. Now, the user is
notified of the discrepancy, is told the the column and row where it occurred,
and merging stops without producing an output spreadsheet or affecting the input spreadsheet(s).
The user must then correct the discrepancy by opening up his/her favorite spreadsheet program before (s)he can merge the spreadsheet(s). See the example wiki for an example.

Examples (and a New Version) Have Arrived!

As promised, here is the examples page for MWM.

Also, I noticed when creating the examples page that the MWM user interface has some naming discrepancies. These have been changed and a new version (1.01) has been uploaded and I have moved most of my files into appropriately named folders. My apologies for any confusion.

Hi there,

For the impatient:

You only need to download mwm.jar mwm-1.01.jar mwm-1.0.1.1.jar mwm-1.0.1.3.jar if you are only interested in using MWM. If you are interested in the actual source code, then you should take a look at the .java files under the files tab on this webpage (and you will probably have to download Andrew Khan's JExcelApi while you are at it)

For the less impatient:

I just got done dealing more legalese than I care to deal with, which involved a few relatively minor but still tedious changes to my code. I am going to bed now, but I will soon post an example page on how to use MWM and some test files to go along with the examples.

For the one person who is still reading:

Happy New Year!

            --Andrew Zuelsdorf (combine2@users.sourceforge.net)