excelstandard.java

基于Java的地图数据管理软件。使用MySQL数据库管理系统。

package net.aetherial.gis.excel;
import java.io.*;
import jxl.*;
import jxl.format.*;
import jxl.write.*;

public class ExcelStandard {

  public ExcelStandard() {
  }
  public int[] standardNumber(int rowStart){
    int[] number =new int[80];
   // number[0] = 0;         // --column
   // number[1] = rowStart;         //---row
   int k = 0;
   for(int i =0;i<10;i++){
     for(int j=0;j<4;j++){
       number[k]=j*4;            //列号
       number[k+1]=rowStart;   //行号
       k++;
       k++;
     }
     rowStart =rowStart+2;  //每横向走2*4个数据，行号+2
   }
    return number;
  }
  public int[] standardName(int rowStart){
    int[] number =new int[80];
    int k = 0;
   for(int i =0;i<10;i++){
     for(int j=0;j<4;j++){
       number[k]=j*4+1;           //列号
       number[k+1]=rowStart;   //行号
       k++;
       k++;
     }
     rowStart =rowStart+2;  //每横向走2*4个数据，行号+2
   }
    return number;
  }
  public int[] standardValue(int rowStart){
    int[] number =new int[80];
    int k = 0;
   for(int i =0;i<10;i++){
     for(int j=0;j<4;j++){
       number[k]=j*4+3;           //列号
       number[k+1]=rowStart;   //行号
       k++;
       k++;
     }
     rowStart =rowStart+2;  //每横向走2*4个数据，行号+2
   }
    return number;
  }
  public int[] standardLat(int rowStart){
    return this.standardValue(rowStart);
  }
  public int[] standardLon(int rowStart){
    int[] number =new int[80];
    int k = 0;
   for(int i =0;i<10;i++){
     for(int j=0;j<4;j++){
       number[k]=j*4+3;           //列号
       number[k+1]=rowStart+1;   //行号
       k++;
       k++;
     }
     rowStart =rowStart+2;  //每横向走2*4个数据，行号+2
   }
    return number;
  }
  public void initialize(WritableSheet sheet){
    sheet.setColumnView(0,4);
    sheet.setColumnView(1,10);
    sheet.setColumnView(2,4);
    sheet.setColumnView(3,10);
    sheet.setColumnView(4,4);
    sheet.setColumnView(5,10);
    sheet.setColumnView(6,4);
    sheet.setColumnView(7,10);
    sheet.setColumnView(8,4);
    sheet.setColumnView(9,10);
    sheet.setColumnView(10,4);
    sheet.setColumnView(11,10);
    sheet.setColumnView(12,4);
    sheet.setColumnView(13,10);
    sheet.setColumnView(14,4);
    sheet.setColumnView(15,10);
    sheet.setColumnView(16,4);
    sheet.setColumnView(17,10);

  }
  public WritableCell row1(int rowStart,WritableSheet sheet){
    String myStr ="县乡（村）公路勘探通用记录表格";
    WritableCell wc = null;
    try {

      WritableFont wf = new WritableFont(WritableFont.TIMES, 20,
                                         WritableFont.BOLD, false,
                                         UnderlineStyle.NO_UNDERLINE);
      WritableCellFormat wcf = new WritableCellFormat(wf);
      wcf.setAlignment(jxl.format.Alignment.CENTRE);
      wcf.setWrap(true);
      //wcf.setBorder(jxl.format.Border.ALL, jxl.format.BorderLineStyle.THIN);
      sheet.mergeCells(0, rowStart, 17, rowStart);
      Label label = new Label(0, 0, myStr, wcf);
      wc = label;
    }
    catch (Exception e) {
      e.printStackTrace();
    }
    return wc;
  }
  public WritableCell row2(int rowStart){
    WritableCell wc = null;
    try {

    }
    catch (Exception e) {
      e.printStackTrace();
    }
    return wc;
  }
  public WritableCell row3(int rowStart){
    WritableCell wc = null;
    try {

    }
    catch (Exception e) {
      e.printStackTrace();
    }
    return wc;
  }
  public WritableCell row4(int rowStart){
    WritableCell wc = null;
    try {

    }
    catch (Exception e) {
      e.printStackTrace();
    }
    return wc;
  }



  public static void main(String args[]){
    ExcelStandard es = new ExcelStandard();
    int[] test = es.standardNumber(10);
    for(int i = 0;i<test.length;i++){
      System.out.println(test[i]);
    }
  }
}