Chinaunix

标题: java读取EXCEL [打印本页]

作者: leigaiting 时间: 2006-08-02 13:25
标题: java读取EXCEL
//FunctionRead data from Excel
//AuthorATGC
//Date of compilationOct 29,2004
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.hssf.record.*;
import org.apache.poi.hssf.model.*;
import org.apache.poi.hssf.util.*;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate;
import java.io.FileInputStream;
public class xls2table
{
public static String fileToBeRead="e://test.xls";
public static void main(String argv[])
{
try
{
HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(fileToBeRead));
HSSFSheet sheet = workbook.getSheet("Sheet1");
int rows = sheet.getPhysicalNumberOfRows();
for (int r = 0; r

本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/15315/showart_149662.html

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)