ExcelImportWizard.java

package org.openlca.app.wizards.io;

import java.io.File;
import java.lang.reflect.InvocationTargetException;

import org.eclipse.core.runtime.IProgressMonitor;
import org.eclipse.jface.operation.IRunnableWithProgress;
import org.eclipse.jface.viewers.IStructuredSelection;
import org.eclipse.jface.wizard.Wizard;
import org.eclipse.ui.IImportWizard;
import org.eclipse.ui.IWorkbench;
import org.openlca.app.M;
import org.openlca.app.db.Cache;
import org.openlca.app.db.Database;
import org.openlca.app.navigation.Navigator;
import org.openlca.app.rcp.images.Icon;
import org.openlca.io.xls.process.input.ExcelImport;

public class ExcelImportWizard extends Wizard implements IImportWizard {

	private FileImportPage importPage;

	@Override
	public void init(IWorkbench workbench, IStructuredSelection selection) {
		setWindowTitle(M.ProcessExcelImportDescription);
		setDefaultPageImageDescriptor(Icon.IMPORT_ZIP_WIZARD.descriptor());
		setNeedsProgressMonitor(true);
	}

	@Override
	public void addPages() {
		importPage = new FileImportPage(new String[] { "xlsx", "xls" }, true);
		addPage(importPage);
	}

	@Override
	public boolean performFinish() {
		File[] files = importPage.getFiles();
		if (files == null)
			return false;
		try {
			Database.getIndexUpdater().beginTransaction();
			doRun(files);
			return true;
		} catch (final Exception e) {
			return false;
		} finally {
			Database.getIndexUpdater().endTransaction();
			Navigator.refresh();
			Cache.evictAll();
		}
	}

	private void doRun(final File[] files) throws Exception {
		getContainer().run(true, true, new IRunnableWithProgress() {
			@Override
			public void run(IProgressMonitor monitor)
					throws InvocationTargetException, InterruptedException {
				monitor.beginTask(M.Import, files.length);
				for (File file : files) {
					monitor.subTask(file.getName());
					ExcelImport importer = new ExcelImport(file, Database.get());
					importer.run();
					monitor.worked(1);
				}
				monitor.done();
			}
		});

	}
}