例:1*1=1
1*2=2.。。。。。。和为1+2+。。
package com.sj.zy;
import java.io.File;
import java.io.IOException;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
public class 求和九九乘法表 {
public static void main(String[] args) throws BiffException, IOException {
// TODO 自动生成的方法存根
String path = "D://测试.xls";
File file = new File(path);
int sum=0;
int num = 0;
Workbook workbook = Workbook.getWorkbook(file);
Sheet sheet = workbook.getSheet(0);
for (int i = 0; i <=8; i++) {
for (int j = 0; j < i+1; j++) {
Cell ce01 = sheet.getCell(j,i);
String text = ce01.getContents();
String text2 = text.substring(text.lastIndexOf("=")+1);//取到=号后面的字符
String text3 = text2.trim();//将字符两边去掉空格
num = Integer.parseInt(text3);//将字符转换为整型;
sum= sum+num;//累加起来
System.out.println(num);//输出转换为整型的数,看看是多少
}
System.out.println("++++++++++++++++");
}
System.out.println("最终值为:"+sum);//输出结果
workbook.close();
}
}