View Javadoc

1   /*
2    * 
3    * 
4    */
5   
6   package oscon2006.common;
7   
8   import com.healthmarketscience.jackcess.*;
9   import org.apache.poi.hssf.*;
10  import org.apache.poi.hssf.usermodel.*;
11  import java.io.*;
12  
13  public class xls2mdb
14  {
15  	public static void main(String[] args)
16  	{
17  		if (args.length != 1)
18  		{
19  			exit("Sorry.");
20  		}
21  		
22  		File xlsFile = new File(args[0]);
23  
24  		if ( ! xlsFile.canRead())
25  		{
26  			exit("Sorry.");
27  		}
28  		
29  		try
30  		{
31  			String mdbFilename = getMdbFilename(xlsFile);
32  			Util.createDatabaseFile(xlsFile, mdbFilename);
33  			System.exit(0);
34  		}
35  		catch (Exception ex)
36  		{
37  			ex.printStackTrace();
38  		}
39  		
40  	}
41  	
42  	public static String getMdbFilename(File xlsFile)
43  	{
44  		String dbFilename = null;
45  		
46  		String xlsFilename = xlsFile.getName();
47  		
48  		if (xlsFilename.toLowerCase().endsWith(".xls"))
49  		{
50  			dbFilename = xlsFilename.substring(0, xlsFilename.length() - 4) + ".mdb";
51  		}
52  		else
53  		{
54  			dbFilename = xlsFilename + ".mdb";
55  		}
56  		
57  		return dbFilename;
58  	}
59  	
60  	
61  	private static void exit(String message)
62  	{
63  		System.err.println(message);
64  		System.exit(1);
65  	}
66  }