实现一个方法,判断表1中 A列第一行的值是否为X,若是则将B列同行的值赋值到表2中C列第一行
依次往下循环
下面是我的思路,求大神帮忙看看如何实现
package com.excelchange;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import jxl.CellType;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import jxl.write.Label;
import jxl.write.WritableCell;
import jxl.write.WritableSheet;
public class ExcelChange {
//workbook=sheet[];sheet=cell[][];
Workbook wb=null;
Sheet sheet=null;
public Sheet input(String sourcepath,int page) throws BiffException, FileNotFoundException, IOException{
//读取excel到workbook类对象;page=0是第一页
Workbook wb=Workbook.getWorkbook(new FileInputStream(sourcepath));
Sheet st=wb.getSheet(page);
return sheet;
}
public void output(String targetpath,int page,int type) throws BiffException, FileNotFoundException, IOException{
Workbook wb=Workbook.getWorkbook(new FileInputStream(targetpath));
Sheet st=wb.getSheet(page);
//输出excel
//case
switch(type)
{
case 1:
wb.setCell(st,x,y);
break;
/* case 2:语句2;
default:语句;
*/
}
wb.write();
wb.close();
}
public int type(Sheet sheet){
//判断表格类型
int type=0;
String c=getCell(sheet,2,3,0);
//用case判断
switch(c)
{
case "3602013619200130631":type=1;
break;
case "123": type =2;
break;
}
return type;
}
public String getCell(Sheet sheet,int x,int y,int page){
//获取指定单元格内容
Sheet st=wb.getSheet(page); //获取第一个sheet
WritableCell cell =((WritableSheet) sheet).getWritableCell(x, y);//获取第一个单元格
String a=cell.toString();
return a;
}
public void setCell(Sheet sheet,int x,int y){
//设置指定单元格内容
Sheet st=wb.getSheet(0);
WritableSheet sheet1 = (WritableSheet) wb.getSheet(0);
WritableCell cell1 = sheet1.getWritableCell(x,y);
Label l = (Label) cell1;
l.setString(getCell(st,x,y,0));
}
}