POI读取Excel文件的带注释小例子 - 军军小站|张军博客

欢迎点击此处订阅本Blog  <link title="RSS 2.0" type="application/rss+xml" href="http://feed.feedsky.com/softwave" rel="alternate">

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

本文转自：http://www.blogjava.net/jwin/archive/2007/12/11/167093.html

试试用POI操作excel囖.
纯粹为了自己好找.
要有人看了这些的话,随意就好啦...欢迎指出不当之处.

package xls;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.OutputStreamWriter;

import java.io.UnsupportedEncodingException;

import java.text.SimpleDateFormat;

import java.util.ArrayList;

import java.util.Date;

import java.util.List;

import org.apache.poi.hssf.usermodel.HSSFCell;

import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class ReadXL

{

public static StringfileName = " C://xls//EXCEL.xls " ;

public static Stringpath = " C://xls// " ; // 为方便,就这样写了.

public static void main(Stringargv[])

{

Listlist = readExcel();

Stringxmldata = buildXML(list);

createXMLFile(xmldata);

}

/**

*读取磁盘上的EXCEL文件的内容

* @return List

public static ListreadExcel()

{

Listlist = null ;

UserBeanub = null ;

try

{

HSSFWorkbookworkbook = new HSSFWorkbook( new FileInputStream(

fileName)); // 得到excel对象

HSSFSheetsheet = workbook.getSheetAt( 0 ); // 得到第一个sheet

int rows = sheet.getPhysicalNumberOfRows(); // 得到行数

list = new ArrayList();

for ( int i = 1 ;i < rows;i ++ )

{

HSSFRowrow = sheet.getRow(i);

ub = new UserBean();

HSSFCellcell = row.getCell(( short ) 0 ); // 得到列0(下标0,为第一列)

ub.setName(cell.getStringCellValue());

cell = row.getCell(( short ) 1 ); // 得到列1

ub.setEmail(cell.getStringCellValue());

cell = row.getCell(( short ) 2 ); // 得到列2

ub.setPhone(cell.getStringCellValue());

cell = row.getCell(( short ) 3 ); // 得到列3

ub.setPasswd(cell.getStringCellValue());

list.add(ub);

}

return list;

}

catch (Exceptione)

{

return null ;

}

/**

*组装xml格式字符串

* @param listList

* @return String

public static StringbuildXML(Listlist)

{

StringBuffersb = new StringBuffer();

sb.append( " <contents-list>/n/t " );

sb.append( " <content>/n/t/t " );

for ( int i = 0 ;i < list.size();i ++ )

{

UserBeanbean = (UserBean)list.get(i);

sb.append( " <userinfo>/n/t/t/t " );

sb.append( " <name> " + bean.getName() + " </name>/n/t/t/t " );

sb.append( " <email> " + bean.getEmail() + " </email>/n/t/t/t " );

sb.append( " <phone> " + bean.getPhone() + " </phone>/n/t/t/t " );

sb.append( " <passwd> " + bean.getPasswd() + " </passwd>/n/t/t " );

if (i + 1 < list.size())

{

sb.append( " </userinfo>/n/t/t " );

}

else

{

sb.append( " </userinfo>/n/t " );

}

sb.append( " </content>/n " );

sb.append( " </contents-list> " );

return sb.toString();

}

/**

*输出到文件

* @param xmldataString

public static void createXMLFile(Stringxmldata)

{

StringcreateTime = createTime();

Stringfilename = path + createTime + " .xml " ;

OutputStreamWriterosw = null ;

FileOutputStreamoutput = null ;

try

{

output = new FileOutputStream(filename);

osw = new OutputStreamWriter(output, " utf-8 " );

osw.write(xmldata);

osw.flush();

}

catch (Exceptionex)

{

}

finally

{

try

{

if ( null != output)

{

output.close();

}

catch (IOExceptionex2)

{

}

try

{

if ( null != osw)

{

osw.close();

}

catch (IOExceptionex3)

{

}

/**

*用时间作为文件名

* @return String

public static StringcreateTime()

{

Datedate = new Date();

SimpleDateFormatdateFormat = new SimpleDateFormat( " yyyyMMddmmss " );

StringcreateTime = dateFormat.format(date);

return createTime;

}

再就一个UserBean,就几个属性.

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript" src="http://www.google.com/reader/ui/publisher.js"></script><script type="text/javascript" src="http://www.google.com/reader/public/javascript/user/00697638153916680411/state/com.google/broadcast?n=5&callback=GRC_p(%7Bc%3A%22green%22%2Ct%3A%22%5Cu8FD9%5Cu4E9B%5Cu6587%5Cu7AE0%5Cu4E5F%5Cu503C%5Cu5F97%5Cu4E00%5Cu770B%22%2Cs%3A%22false%22%7D)%3Bnew%20GRC"></script>

POI读取Excel文件的带注释小例子

更多文章、技术交流、商务合作、联系博主

微信扫码或搜索：z360901061

微信扫一扫加我为好友

QQ号联系： 360901061

您的支持是博主写作最大的动力，如果您喜欢我的文章，感觉我的文章对您有帮助，请用微信扫描下面二维码支持博主2元、5元、10元、20元等您想捐的金额吧，狠狠点击下面给点支持吧，站长非常感激您！手机微信长按不能支付解决办法：请将微信支付二维码保存到相册，切换到微信，然后点击微信右上角扫一扫功能，选择支付二维码完成支付。

【本文对您有帮助就好】元

2元

5元

10元

20元

自定义