透過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, ]
buy generic 100mg viagra online: Generic100mgEasy – Generic100mgEasy
onion dark website dark market 2025
Kamagra Kopen Online: Kamagra Kopen – kamagra 100mg kopen
dark web market urls https://github.com/darkwebsitesyhshv/darkwebsites – dark market url
dark websites darknet sites
ссылка на сайт мега даркнет
https://shvejnye.ru/
darknet markets onion https://github.com/abacuslink4jjku/abacuslink – dark web markets
dark web markets dark web market list
HappyToon 무료웹툰사이트 : which has the largest number of webtoons currently being serialized. 무료웹툰사이트
HappyToon 웹툰사이트 : which has the largest number of webtoons currently being serialized. 웹툰사이트
HappyToon 해피툰 : which has the largest number of webtoons currently being serialized. 해피툰
HappyToon 웹툰추천 : which has the largest number of webtoons currently being serialized. 웹툰추천
HappyToon 해피툰 주소안내 : which has the largest number of webtoons currently being serialized. 해피툰 주소안내
HappyToon 해피툰 : which has the largest number of webtoons currently being serialized. 해피툰
HappyToon 해피툰 주소안내 : Introduction to the most popular free webtoons. 해피툰 주소안내
HappyToon 해피툰 : Introduction to the most popular free webtoons. 해피툰 주소안내
HappyToon 해피툰 주소안내 : the fastest place to check free webtoon addresses. 해피툰 주소안내
HappyToon 해피툰 : the fastest place to check free webtoon addresses. 해피툰
dark web markets https://github.com/aresmarketdarknetl9khn/aresmarketdarknet – dark web link
веб-сайтшаблоны хайп проектов
cialis without a doctor prescription: Generic Cialis without a doctor prescription – TadalafilEasyBuy.com
Aw, this was a very nice post. Taking the time and actual effort to make a superb article… but what can I say… I put things off a whole lot and never manage to get nearly anything done.
подробнее
купить хайп
Charlotte Dog Park’s grassy fields are perfect for my pup’s dramatic rolls and tumbles.
darknet sites darknet drug market
интернетКупить хайп под ключ
https://kamagrakopen.pro/# kamagra jelly kopen
интернет
Хайп проект под ключ
1block crypto casino
1Block Casino: Full Platform Overview
1Block Casino is a modern gaming platform that offers a wide range of gambling entertainment for players worldwide. From classic slots to unique games like Plinko, the service provides everything needed for gambling enthusiasts. Let’s take a closer look at the main features of the platform, game categories, and key advantages.
Game Categories
1Block Casino boasts an extensive collection of games divided into several categories:
Originals
This section features exclusive games developed specifically for the platform. It’s a great choice for those seeking a unique gaming experience.
Slots
Classic and modern slots with various themes, bonuses, and mechanics are available here. Whether you prefer traditional fruit machines or innovative video slots, there’s something for everyone.
Live Games
Immerse yourself in the atmosphere of a real casino with live dealer games. These games are streamed in real-time, offering an authentic experience with professional dealers.
Fishing Games
A unique category that combines gambling with interactive gameplay. Fishing games are gaining popularity due to their engaging mechanics and potential for big wins.
Poker
Test your skills against other players in various poker formats. The platform offers both traditional and fast-paced poker games.
Esports Betting
Bet on your favorite esports teams and tournaments. This section caters to fans of competitive gaming who want to add excitement to their matches.
Lucky Bets and High Rollers
1Block Casino caters to all types of players, from casual gamers to high rollers. The Lucky Bets section highlights random wins, while the High Rollers section showcases impressive payouts from large bets. Whether you’re betting small or large amounts, the platform ensures fair play and exciting opportunities.
Our Community and Partnerships
1Block Casino values its community and collaborates with trusted partners to enhance the gaming experience. The platform proudly works with leading providers, ensuring top-quality games and services for its users.
Legal Information
1Block Casino is owned and operated by JogoMaster Limited, a company registered under number 15748. The company’s registered address is located in Hamchako, Mutsamudu, Autonomous Island of Anjouan, Union of Comoros.
The platform is licensed and regulated by the Gaming Board of Anjouan (License No. ALSI-152406032-FI3). 1Block has passed all regulatory compliance checks and is legally authorized to conduct gaming operations for all games of chance and wagering.
Why Choose 1Block Casino?
Diverse Game Selection : From slots to live games, there’s something for every type of player.
Transparency : All bets and payouts are clearly displayed, ensuring trust and fairness.
Crypto-Friendly : The platform supports cryptocurrency transactions, making it convenient for modern players.
Licensed and Regulated : With a valid license from the Gaming Board of Anjouan, players can enjoy a secure and legal gaming experience.
Whether you’re a fan of classic casino games or looking to explore unique options like Plinko, 1Block Casino offers a comprehensive and enjoyable platform for all gambling enthusiasts.