/*
* #%L
* gitools-ui-app
* %%
* Copyright (C) 2013 Universitat Pompeu Fabra - Biomedical Genomics group
* %%
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as
* published by the Free Software Foundation, either version 3 of the
* License, or (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public
* License along with this program. If not, see
* <http://www.gnu.org/licenses/gpl-3.0.html>.
* #L%
*/
package org.gitools.ui.app.fileimport.wizard.excel;
import org.gitools.api.analysis.IProgressMonitor;
import org.gitools.api.persistence.FileFormat;
import org.gitools.api.resource.IResource;
import org.gitools.api.resource.IResourceLocator;
import org.gitools.ui.app.fileimport.ImportWizard;
import org.gitools.ui.core.Application;
import org.gitools.ui.core.utils.FileFormatFilter;
import org.gitools.ui.platform.IconUtils;
import org.gitools.ui.platform.icons.IconNames;
import org.gitools.ui.platform.progress.JobRunnable;
import org.gitools.ui.platform.progress.JobThread;
import org.gitools.ui.platform.wizard.AbstractWizard;
import org.gitools.ui.platform.wizard.WizardDialog;
import java.io.IOException;
import java.util.List;
public class ExcelImportWizard extends AbstractWizard implements ImportWizard {
private static FileFormat[] FILE_FORMATS = new FileFormat[] { new FileFormat("Excel", "xls"), new FileFormat("Excel", "xlsx") };
private static FileFormatFilter FILE_FORMAT_FILTER = new FileFormatFilter("Microsoft Excel files", FILE_FORMATS);
private IResourceLocator locator;
private SelectColumnsPage selectColumnsPage;
private ExcelReader reader;
private Callback callback;
public ExcelImportWizard() {
setTitle("Import an Excel matrix");
setLogo(IconUtils.getImageIconResourceScaledByHeight(IconNames.excel48, 48));
setHelpContext("import_excel");
}
@Override
public FileFormatFilter getFileFormatFilter() {
return FILE_FORMAT_FILTER;
}
public void setLocator(IResourceLocator locator) {
this.locator = locator;
}
@Override
public void setCallback(Callback callbackFunction) {
this.callback = callbackFunction;
}
@Override
public void addPages() {
selectColumnsPage = new SelectColumnsPage();
selectColumnsPage.setTitle("Select rows, columns and values headers");
selectColumnsPage.setReader(reader);
addPage(selectColumnsPage);
}
@Override
public void performFinish() {
ExcelReader reader = selectColumnsPage.getReader();
int columns = selectColumnsPage.getSelectedColumn();
int rows = selectColumnsPage.getSelectedRow();
List<Integer> values = selectColumnsPage.getSelectedValues();
JobRunnable loadFile = new CommandConvertAndLoadExcelFile(columns, rows, values, reader) {
@Override
public void afterLoad(IResource resource, IProgressMonitor monitor) throws CommandException {
callback.afterLoad(resource, monitor);
}
};
Application.get().showNotification("Data imported.");
JobThread.execute(Application.get(), loadFile);
}
@Override
public void run(IProgressMonitor monitor) throws IOException {
reader = new ExcelReader(locator);
reader.run(monitor);
init();
WizardDialog wizDlg = new WizardDialog(Application.get(), this);
wizDlg.open();
}
}