CLASSE JAVA POUR LA COMPARAISON DE 2 FICHIERS EXCEL

package ihm_main;

import java.io.File;
import java.io.FileWriter;
import java.io.PrintWriter;

import jxl.Sheet;
import jxl.Workbook;

public class XLCompare {

	private	String		dirname;
	private	static final String[]	COLUMN = { "A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L",
			"M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "X", "Y", "Z", "AA", "AB", "AC",
			"AD", "AE", "AF"};
	
	/**
	 * Constructor
	 * @param	dirname : directory where excel files are located
	 */
	public XLCompare( String dirname) {
		this.dirname = dirname;
	}
	
	/**
	 * This method compares reference and new excel file
	 */
	public void fcompare( String fnew, String fref ) {
 
		try {
			// Open log file
		   	PrintWriter plog = new PrintWriter( new FileWriter( this.dirname + 
		   			java.io.File.separator + "Change.log"));
		   	// Open reference file
			Workbook wref = Workbook.getWorkbook( new File( this.dirname + 
					java.io.File.separator + fref));
		   	// Open new file
			Workbook wnew = Workbook.getWorkbook( new File( this.dirname + 
					java.io.File.separator + fnew));
			// Get sheet names in new file
			String[] nsheet = wnew.getSheetNames();
			
			// Check for all sheet from new file
			for( int i=0; i<nsheet.length; i++) {
				// Trace sheet name in log file
				plog.println();
				plog.println( "Sheet " + nsheet[i]);
				// Open sheet in reference file
				Sheet rsh = wref.getSheet( nsheet[i]);
				if( rsh == null) {
					plog.println( "   new sheet. Not existing in reference file");
					continue;
				}
				// Open sheet in new file
				Sheet nsh = wnew.getSheet( nsheet[i]);
				this.scompare( plog, nsh, rsh);
			}		   	
			plog.close();
		}
		catch (Exception e) {
			System.err.println( "Xl compare : " + e.toString());
		}
	}

	/**
	 * This method compare 2 sheets
	 */
	private void scompare( PrintWriter plog, Sheet nsh, Sheet rsh) {
		
		int nmax = nsh.getRows();
		
		for( int i=0; i<nmax; i++) {
			for( int j=0; j<28; j++) {
				String rlab = rsh.getCell( j, i).getContents();
				String nlab = nsh.getCell( j, i).getContents();
				if( !rlab.equals( nlab)) {
					String texte = "line " + Integer.toString( i+1) + ", column " +
						COLUMN[ j] + " : " + rlab + " -> " + nlab;
					plog.println( "   " + texte);
					System.err.println( texte);
				}
			}
		}
	}
}

06 octobre 2007 14:42:51 :

Prise en compte des conseils de Twinuts - merci

06 octobre 2007 14:49:15 :

Voilà avec le bon code...

09 octobre 2007 06:58:14 :

Indication du lien vers le site JexcelAPI