package read_out;
import java.io.File;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class newExcelReader {
public int rowCount=0;
public String quan[][];
public static void main(String args[])
{
newExcelReader test =new newExcelReader();
try {
Workbook book = Workbook.getWorkbook(new File("d:\\test_excel\\data5.xls"));
// 获得第一个工作表对象
Sheet sheet = book.getSheet( 0 );
// 得到第一列第一行的单元格
Cell cell1 ;
test.rowCount=sheet.getRows();
test.quan=new String[6][test.rowCount];
for(int i=0;i<6;i++)
{
for(int j=0;j<test.rowCount;j++)
{
cell1 = sheet.getCell( i , j );
test.quan[i][j]=cell1.getContents();
System.out.println(test.quan[i][j]);
}
}
book.close();
} catch (Exception e) {
System.out.println(e);
}
try {
// Excel获得文件
Workbook wb = Workbook.getWorkbook( new File("d:\\test_excel\\data60.xls"));
// 打开一个文件的副本,并且指定数据写回到原文件
WritableWorkbook book = Workbook.createWorkbook( new File("d:\\test_excel\\data60.xls"),
wb);
// 添加一个工作表
WritableSheet sheet = book.getSheet( "Sheet1" );
for(int i=0;i<6;i++)
{
for(int j=0;j<test.rowCount;j++)
{
if((j+1)%12==0)
{
sheet.addCell( new Label( i , (j+1)/12-1 ,test.quan[i][j]));
// sheet.getCell(i, (j+1)/3-1).equals(test.quan[i][j]);
}
}
}
book.write();
book.close();
} catch (Exception e) {
System.out.println(e);
}
}
}