透過Java解析Excel檔案
也是一個工作中遇到的情境，很多單位想讓內部人員利用Excel維護資料（因為維護上比較簡單方便），且想讓這份資料透過網頁呈現給一般網友閱讀，所以整體後端的流程應該是：
- 將維護的Excel透過網頁介面上傳
- 將上傳的Excel轉換成XML
- 網頁去讀取這份XML來呈現
透過以上的三個步驟，就可以完成客戶想要效果。
本範例展示的是讀取Excel的XLS格式（新版Excel為XLSX格式），並轉換成陣列的方法（寫入XML在前面的範例就有了），我們選用讀取Excel的Library是Apache POI，而檔內已經有以下的資料，其中Total是公式欄位，計算Price x Quantity：
| ID | Name | Price | Quantity | Total |
| 100001 | 產品名稱1 | 10 | 5 | 50 |
| 100002 | 產品名稱2 | 20 | 10 | 200 |
| 100003 | 產品名稱3 | 30 | 15 | 450 |
以下是讀取的程式範例：
package CDIT.stanley;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.Iterator;
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;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
public class excelToXMLFullSample {
static ArrayList<ArrayList<String>> excelData = new ArrayList<ArrayList<String>>();
public static void main (String[] args) throws FileNotFoundException{
excelData.clear();
String xlsPath = "C:\\Projects\\Javas\\sample.xls";
InputStream inputStream = null;
inputStream = new FileInputStream (xlsPath);
POIFSFileSystem fileSystem = null;
try {
fileSystem = new POIFSFileSystem (inputStream);
@SuppressWarnings("resource")
HSSFWorkbook workBook = new HSSFWorkbook (fileSystem);
HSSFSheet sheet = workBook.getSheetAt (0);
Iterator<?> rows = sheet.rowIterator ();
while (rows.hasNext ()){
HSSFRow row = (HSSFRow) rows.next();
Iterator<?> cells = row.cellIterator ();
ArrayList<String> rowData = new ArrayList<String>();
while (cells.hasNext ()){
HSSFCell cell = (HSSFCell) cells.next();
switch (cell.getCellTypeEnum()){
case STRING :{
rowData.add(cell.getStringCellValue());
break;
}
case NUMERIC : {
rowData.add((int)cell.getNumericCellValue() + "");
break;
}
case FORMULA :{
switch(cell.getCachedFormulaResultTypeEnum()) {
case STRING:
rowData.add(cell.getStringCellValue ());
break;
case NUMERIC:
rowData.add((int)cell.getNumericCellValue() + "");
break;
default:
rowData.add("");
break;
}
}
default:
rowData.add("");
break;
}
}
excelData.add(rowData);
}
} catch(IOException e){
System.out.println("IOException " + e.getMessage());
System.out.println("轉換失敗，請檢查Excel檔案與格式是否正確");
}
for(int i=0 ; i<excelData.size(); i++){
System.out.println("Excel Row "+ i +" Data : " + excelData.get(i));
}
}
}
程式會把Excel內的資料轉換為ArrayList，輸出內容如下：
Excel Row 0 Data : [Product ID, Product Name, Product Price, Quantity, Total] Excel Row 1 Data : [100001, 產品名稱1, 10, 5, 50, ] Excel Row 2 Data : [100002, 產品名稱2, 20, 10, 200, ] Excel Row 3 Data : [100003, 產品名稱3, 30, 15, 450, ]
Slot menjadi daya tarik utama di kasino: bonaslot.site – bonaslot.site
http://garuda888.top/# Pemain sering berbagi tips untuk menang
http://preman69.tech/# Permainan slot mudah dipahami dan menyenangkan
slot demo rupiah slot demo rupiah Slot menjadi daya tarik utama di kasino
Kasino sering mengadakan turnamen slot menarik http://slot88.company/# Kasino di Indonesia menyediakan hiburan yang beragam
garuda888.top garuda888.top Banyak kasino memiliki promosi untuk slot
Banyak pemain mencari mesin dengan RTP tinggi http://preman69.tech/# Beberapa kasino memiliki area khusus untuk slot
Kasino di Bali menarik banyak pengunjung http://preman69.tech/# Slot klasik tetap menjadi favorit banyak orang
http://bonaslot.site/# Kasino selalu memperbarui mesin slotnya
Permainan slot mudah dipahami dan menyenangkan: bonaslot – BonaSlot
Banyak kasino menawarkan permainan langsung yang seru: bonaslot – bonaslot
Banyak pemain berusaha untuk mendapatkan jackpot: preman69 – preman69 slot
http://slotdemo.auction/# Mesin slot dapat dimainkan dalam berbagai bahasa
http://garuda888.top/# Kasino selalu memperbarui mesin slotnya
garuda888.top garuda888 Kasino memiliki suasana yang energik dan menyenangkan
Slot dengan grafis 3D sangat mengesankan https://slotdemo.auction/# Banyak pemain berusaha untuk mendapatkan jackpot
About us
Since its founding in 2020, EtherCode Innovation has demonstrated an outstanding level of expertise in smart contract development on the Ethereum platform. The EtherCode Innovation team brings together experienced developers whose knowledge and skills allow them to create reliable and innovative solutions for their clients
honeypot code
Mission
We strive to ensure that every person interested in blockchain technologies can gain high-quality knowledge and skills. Our mission is to develop smart contracts that not only improve the functionality of the Ethereum network, but also contribute to the education and development of the developer community.
Our services
EtherCode Innovation specializes in creating various smart contracts within Ethereum. We develop innovative solutions for financial instruments, decentralized applications (DApps) and digital asset management systems. Our team has deep knowledge of the Solidity and Vyper programming languages, which allows us to create secure and efficient smart contracts.
In addition, we provide free educational content for those who want to learn how to create tokens, including Honeypot tokens. Our materials cover all aspects of creating and deploying tokens on Ethereum, from basic concepts to complex technical details.
Our contribution to the community
We believe that education plays a key role in the development of the blockchain community. Therefore, we actively participate in various educational and communication initiatives. We also support various educational projects aimed at spreading knowledge about blockchain.
Development prospects
We are confident that blockchain technology will continue to transform the world, and we are committed to staying at the center of this process. Our team will continue to create innovative products, develop educational resources, and actively participate in the development of the Ethereum developer community.
Finally, it is worth noting that EtherCode Innovation is committed to continuous development and innovation. The team is constantly researching new technologies and development methods to provide its clients with the most advanced solutions. Thanks to this approach, the company remains ahead of its time and continues to be in demand in the field of blockchain development.
EtherCode Innovation is not just a company developing smart contracts on Ethereum. We are leaders in blockchain technology and education, and we invite you to join us on this exciting journey into the world of decentralization and innovation.
Kasino sering memberikan hadiah untuk pemain setia http://slotdemo.auction/# Pemain sering mencoba berbagai jenis slot
https://bonaslot.site/# Permainan slot bisa dimainkan dengan berbagai taruhan
Slot dengan tema film terkenal menarik banyak perhatian http://garuda888.top/# Kasino di Indonesia menyediakan hiburan yang beragam
Kasino di Bali menarik banyak pengunjung: slot88 – slot 88
Banyak kasino menawarkan permainan langsung yang seru: slot demo – slot demo pg gratis
slot88 slot88 Kasino selalu memperbarui mesin slotnya
http://preman69.tech/# Slot menjadi bagian penting dari industri kasino
https://garuda888.top/# Kasino memastikan keamanan para pemain dengan baik
Mega India Pharm Mega India Pharm MegaIndiaPharm
overseas pharmacy no prescription https://familypharmacy.company/# family pharmacy
pharmacy discount coupons https://xxlmexicanpharm.com/# mexico drug stores pharmacies
MegaIndiaPharm: indianpharmacy com – indianpharmacy com
drug mart: discount drug mart – drugmart