org.molgenis.data.omx2emx.Omx2EmxExcelConverter Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of molgenis-data-mysql Show documentation

The newest version!

package org.molgenis.data.omx2emx;

import java.io.File;
import java.io.FileNotFoundException;
import java.io.IOException;

import org.molgenis.data.MolgenisInvalidFormatException;
import org.molgenis.data.RepositoryCollection;
import org.molgenis.data.WritableFactory;
import org.molgenis.data.excel.ExcelRepositoryCollection;
import org.molgenis.data.excel.ExcelWriter;
import org.molgenis.data.excel.ExcelWriter.FileFormat;
import org.springframework.util.StringUtils;

public class Omx2EmxExcelConverter
{
	public static void main(String[] args) throws MolgenisInvalidFormatException
	{
		if (args.length < 2 || args.length > 3)
		{
			System.err.println("usage: java " + Omx2EmxExcelConverter.class.getSimpleName()
					+ " inputfile outputfile ");
			return;
		}

		try
		{
			String namespace = args.length == 3 ? args[2] : null;
			convert(new File(args[0]), new File(args[1]), namespace);
		}
		catch (FileNotFoundException e)
		{
			e.printStackTrace();
		}
		catch (IOException e)
		{
			e.printStackTrace();
		}
	}

	public static void convert(File omxInputFile, File emxOutputFile, String namespace) throws IOException,
			MolgenisInvalidFormatException
	{

		RepositoryCollection repositoryCollection = new ExcelRepositoryCollection(omxInputFile);

		FileFormat fileFormat = StringUtils.getFilenameExtension(emxOutputFile.getName()).equalsIgnoreCase("xls") ? FileFormat.XLS : FileFormat.XLSX;
		WritableFactory writableFactory = new ExcelWriter(emxOutputFile, fileFormat);

		try
		{
			new Omx2EmxConverter(repositoryCollection, namespace).convert(writableFactory);
		}
		finally
		{
			writableFactory.close();
		}
	}
}