import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import com.opensymphony.xwork2.ActionSupport;
import com.zkyt.entity.TBasEnterprise;
import com.zkyt.service.SysConfigBizImpl;
public class FxyUtilDemo extends ActionSupport{
private static SysConfigBizImpl sysConfigBiz;
private static List<TBasEnterprise> tbsList = new ArrayList<TBasEnterprise>();
public static void readExcel(String filePath) throws BiffException, IOException
{
InputStream is = new FileInputStream(filePath);
Workbook wrb = Workbook.getWorkbook(is);
Sheet[] sts = wrb.getSheets();//得到文件所有页的名字
//for(int i=0;i<sts.length;i++)
//{
int i = 0;
String tableName = sts[i].getName().trim();
System.out.println(tableName);
System.out.println(sts[i].getRows());
System.out.println(sts[i].getColumns());
for(int j=0;j<sts[i].getRows();j++)
{
TBasEnterprise tbep = new TBasEnterprise();
boolean flag = true;
for(int k=0;k<sts[i].getColumns();k++)
{
flag = true;
Cell coo = sts[i].getCell(k, j);
String str = coo.getContents().trim();
if (str!=null) {
Pattern p = Pattern.compile("\\s*|\t|\r|\n");//将数据中的空格,回车等去掉。
Matcher m = p.matcher(str);
str = m.replaceAll("");
system.out println(str);
}
}
}