/*
    * 
    * 
    */
   package oscon2006.common;
   
   import java.io.*;
   import org.apache.poi.hssf.*;
   import org.apache.poi.hssf.usermodel.HSSFWorkbook;
  
  public class xls2csv
  {
  	static private final String SHEETNAME_OPTION = "-s";
  	static private String argXlsFilename;
  	static private String argSheetname;
  
  	/**
  	 * 
  	 * @param args
  	 * 
  	 */
  	public static void main(String[] args)
  	{
  		if (args.length != 1)
  		{
  			System.exit(1);
  		}
  
  		processArgs(args);
  		
  		InputStream in = null;
  		
  		String csvFilename = "output.csv";
  		
  		try
  		{
  			in = new FileInputStream(argXlsFilename);
  			HSSFWorkbook wb = new HSSFWorkbook(in);
  			
  			CsvBuilder builder = new CsvBuilder();
  			builder.setData(wb);
  			builder.setTargetWorksheet(argSheetname);
  			builder.build(csvFilename);
  		}
  		catch (Exception ex)
  		{
  			ex.printStackTrace();
  		}
  		finally
  		{
  			try
  			{
  				in.close();
  			}
  			catch (IOException ignore)
  			{
  				// ignore
  			}
  		
  		}
  
  	}
  
  	static private void processArgs(String[] args)
  	{
  		for (int index = 0; index < args.length; index++)
  		{
  			String arg = args[index];
  			if (arg.equals(SHEETNAME_OPTION))
  			{
  				index++;
  				argSheetname = args[index];
  			}
  			else
  			{
  				argXlsFilename = args[index];
  			}
  		}
  	}
  }