Arcgis自动建库(Java)

package topy;
import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.OutputStreamWriter;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

/**
 * 将excel中的内容复制到py中
 */
public class xls {
    static String filepath = path();
	// private static String py = filepath + "\\ld.py";
	private static String path = filepath + "\\sourcefile.xls";

	public static void main(String[] args) throws BiffException, IOException {
		// 创建流
		InputStream is = new FileInputStream(path);
		Workbook book = Workbook.getWorkbook(is);
		String[] sheetname = book.getSheetNames();
		// 读取excel中多个sheet
		for (int i = 0; i < book.getSheetNames().length; i++) {
			// 生成的python文件名与路径
			String py = filepath + "\\" + sheetname[i] + ".py";
			// 读取sheet
			Sheet sheet = book.getSheet(i);
			// 将sheet数据写入py中
			new xls().readExcel(path, py, true, sheet);
		}
		book.close();
	}

	// 读取当前文件路径
	public static String path() {
		File directory = new File("");// 参数为空
		String courseFile = null;
		try {
			courseFile = directory.getCanonicalPath();
		//	System.out.println(courseFile);
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return courseFile;
	}

	// 读取Excel内的数据并写入目标文件中
	public boolean readExcel(String path, String py, boolean append, Sheet sheet) {
		try {
			// 得到所有的行数
			Integer rows = sheet.getRows();
			// 得到所有的列数
			Integer colus = sheet.getColumns();
			Cell cell;
			String filepath2=filepath;
			String spatial = sheet.getCell(6, 0).getContents().trim();
			// 写入py头部必要信息
			String CreateFeatureclass = "# -*- coding: UTF-8 -*-";
			new xls().insert(py, CreateFeatureclass + "\r\n", append);
			CreateFeatureclass = "import arcpy";// 引入arcpy
			new xls().insert(py, CreateFeatureclass + "\r\n", append);
			CreateFeatureclass = "from arcpy import env";
			new xls().insert(py, CreateFeatureclass + "\r\n", append);
			CreateFeatureclass = "env.workspace = \"" + filepath2.replace("\\", "/")
					+ "/database.mdb\"";// 定义工作空间
			new xls().insert(py, CreateFeatureclass + "\r\n", append);
			
			CreateFeatureclass = "spatial_reference = arcpy.Describe(\""+filepath2.replace("\\", "/")+"/spatial_reference/"+spatial+"\").spatialReference";
			
			new xls().insert(py, CreateFeatureclass + "\r\n", append);
			/**
			 * 新建要素类
			 */
			CreateFeatureclass = "arcpy.CreateFeatureclass_management(\""+filepath2.replace("\\", "/")+"/database.mdb\",";
			for (int i = 1; i < 6; i++) {
				String colname = sheet.getCell(i, 0).getContents().trim();
				CreateFeatureclass += "\""+colname + "\",";
			}
			new xls().insert(py, CreateFeatureclass +"spatial_reference"+ ")" + "\r\n"
					+ "\r\n", append);
			/**
			 * 添加字段
			 */
			for (int i = 3; i < rows; i++) {
				// 得到地2列字段名用做判断
				String getSheet = sheet.getCell(1, i).getContents().trim();
				// 得到新建要素类名
				String getField = sheet.getCell(1, 0).getContents().trim();
				// 跳过字段名为SHAPE和OBJECTID的字段
				if (getSheet.equals("SHAPE") == false
						|| getSheet.equals("OBJECTID") == false) {
					String topython = "arcpy.AddField_management(\"" + getField
							+ "\",\"";
					for (int a = 1; a < colus; a++) {
//						System.out.println(getSheet);
						String colname = sheet.getCell(a, i).getContents()
								.trim();
						topython += colname + "\",\"";
					}
					new xls().insert(py, topython + "\")" + "\r\n",
							append);
				}
			}
			return true;
		} catch (Exception e) {
			e.printStackTrace();
			return false;
		}
	}

	// 写入py文件流
	public void insert(String py, String content,boolean append) throws IOException {
		File file = new File(py);
		FileOutputStream writerStream = new FileOutputStream(file,append);    
		BufferedWriter writer = new BufferedWriter(new OutputStreamWriter(writerStream, "UTF-8")); 
		writer.write(content);
		writer.close();    
    } 
}