<!-- Feedsky FEED發布代碼開始 -->
歡迎點擊此處訂閱本Blog
<!-- FEED自動發現標記開始 --> <link title="RSS 2.0" type="application/rss+xml" rel="alternate"> <!-- FEED自動發現標記結束 -->
<!--Google 468*60橫幅廣告開始--><script type="text/javascript"><!-- google_ad_client = "pub-7343546549496470"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "image"; //2007-07-26: CSDN google_ad_channel = "6063905817"; google_color_border = "6699CC"; google_color_bg = "E6E6E6"; google_color_link = "FFFFFF"; google_color_text = "333333"; google_color_url = "AECCEB"; google_ui_features = "rc:6"; //--> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script><!--Google 468*60橫幅廣告結束-->
本文轉自：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,就幾個屬性.
<!--新Google 468*60橫幅廣告開始--><script type="text/javascript"><!-- google_ad_client = "pub-7343546549496470"; /* 468x60, 創建于 08-8-6 */ google_ad_slot = "7368701459"; google_ad_width = 468; google_ad_height = 60; //--> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script><!--新Google 468*60橫幅廣告結束-->
<!--新Google 468x15 橫鏈接單元開始--><script type="text/javascript"><!-- google_ad_client = "pub-7343546549496470"; /* 468x15 橫鏈接單元 */ google_ad_slot = "5785741422"; google_ad_width = 468; google_ad_height = 15; //--> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script><!--新Google 468x15 橫鏈接單元結束-->
<!-- Google Reader shared發布代碼開始 --><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><!-- Google Reader shared發布代碼結束 -->
<!--Google 468*60橫幅廣告開始--><script type="text/javascript"><!-- google_ad_client = "pub-7343546549496470"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "image"; //2007-07-26: CSDN google_ad_channel = "6063905817"; google_color_border = "6699CC"; google_color_bg = "E6E6E6"; google_color_link = "FFFFFF"; google_color_text = "333333"; google_color_url = "AECCEB"; google_ui_features = "rc:6"; //--> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script><!--Google 468*60橫幅廣告結束-->
本文轉自：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,就幾個屬性.
<!--新Google 468*60橫幅廣告開始--><script type="text/javascript"><!-- google_ad_client = "pub-7343546549496470"; /* 468x60, 創建于 08-8-6 */ google_ad_slot = "7368701459"; google_ad_width = 468; google_ad_height = 60; //--> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script><!--新Google 468*60橫幅廣告結束-->
<!--新Google 468x15 橫鏈接單元開始--><script type="text/javascript"><!-- google_ad_client = "pub-7343546549496470"; /* 468x15 橫鏈接單元 */ google_ad_slot = "5785741422"; google_ad_width = 468; google_ad_height = 15; //--> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script><!--新Google 468x15 橫鏈接單元結束-->
<!-- Google Reader shared發布代碼開始 --><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><!-- Google Reader shared發布代碼結束 -->
更多文章、技術交流、商務合作、聯系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號聯系： 360901061
您的支持是博主寫作最大的動力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點擊下面給點支持吧，站長非常感激您！手機微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對您有幫助就好】元
