透過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, ]
Pharmacie Internationale en ligne: Pharmacies en ligne certifiees – Pharmacie Internationale en ligne
pharmacie en ligne pas cher https://viagrameilleurprix.com/# Acheter Sildenafil 100mg sans ordonnance
acheter mГ©dicament en ligne sans ordonnance https://tadalafilmeilleurprix.com/# pharmacie en ligne livraison europe
Pharmacie en ligne livraison Europe cialis generique pharmacie en ligne fiable
pharmacie en ligne avec ordonnance: kamagra pas cher – pharmacie en ligne fiable
http://pharmaciemeilleurprix.com/# pharmacie en ligne
pharmacie en ligne france livraison internationale
Astronomers briefly thought Elon Musk’s car was an asteroid. Here’s why that points to a broader problem
skraken тор
Seven years after SpaceX launched Elon Musk’s cherry red sports car into orbit around our sun, astronomers unwittingly began paying attention to its movements once again.
Observers spotted and correctly identified the vehicle as it started its extraterrestrial excursion in February 2018 — after it had blasted off into space during the Falcon Heavy rocket’s splashy maiden launch. But more recently, the car spawned a high-profile case of mistaken identity as space observers mistook it for an asteroid.
Several observations of the vehicle, gathered by sweeping surveys of the night sky, were inadvertently stashed away in a database meant for miscellaneous and unknown objects, according to the International Astronomical Union’s Minor Planet Center.
An amateur astronomer noticed a string of data points in January that appeared to fit together, describing the orbit of a relatively small object that was swooping between the orbital paths of Earth and Mars.
The citizen scientist assumed the mystery object was an undocumented asteroid and promptly sent his findings to the MPC, which operates at the Harvard Smithsonian Center for Astrophysics in Cambridge, Massachusetts, as a clearinghouse that seeks to catalog all known asteroids, comets and other small celestial bodies. An astronomer there verified the finding.
And thus, the Minor Planet Center logged a new object, asteroid “2018 CN41.”
Within 24 hours, however, the center retracted the designation.
The person who originally flagged the object realized their own error, MPC astronomer Peter Veres told CNN, noticing that they had, in fact, found several uncorrelated observations of Musk’s car. And the center’s systems hadn’t caught the error.
https://pharmaciemeilleurprix.shop/# acheter mГ©dicament en ligne sans ordonnance
pharmacie en ligne france livraison belgique
https://kamagrameilleurprix.shop/# trouver un mГ©dicament en pharmacie
trouver un mГ©dicament en pharmacie
pharmacie en ligne avec ordonnance: cialis generique – п»їpharmacie en ligne france
Astronomers briefly thought Elon Musk’s car was an asteroid. Here’s why that points to a broader problem
skraken войти
Seven years after SpaceX launched Elon Musk’s cherry red sports car into orbit around our sun, astronomers unwittingly began paying attention to its movements once again.
Observers spotted and correctly identified the vehicle as it started its extraterrestrial excursion in February 2018 — after it had blasted off into space during the Falcon Heavy rocket’s splashy maiden launch. But more recently, the car spawned a high-profile case of mistaken identity as space observers mistook it for an asteroid.
Several observations of the vehicle, gathered by sweeping surveys of the night sky, were inadvertently stashed away in a database meant for miscellaneous and unknown objects, according to the International Astronomical Union’s Minor Planet Center.
An amateur astronomer noticed a string of data points in January that appeared to fit together, describing the orbit of a relatively small object that was swooping between the orbital paths of Earth and Mars.
The citizen scientist assumed the mystery object was an undocumented asteroid and promptly sent his findings to the MPC, which operates at the Harvard Smithsonian Center for Astrophysics in Cambridge, Massachusetts, as a clearinghouse that seeks to catalog all known asteroids, comets and other small celestial bodies. An astronomer there verified the finding.
And thus, the Minor Planet Center logged a new object, asteroid “2018 CN41.”
Within 24 hours, however, the center retracted the designation.
The person who originally flagged the object realized their own error, MPC astronomer Peter Veres told CNN, noticing that they had, in fact, found several uncorrelated observations of Musk’s car. And the center’s systems hadn’t caught the error.
Pharmacie Internationale en ligne: cialis prix – trouver un mГ©dicament en pharmacie
pharmacie en ligne avec ordonnance https://kamagrameilleurprix.com/# vente de mГ©dicament en ligne
Have you ever considered about adding a little bit more than just your articles? I mean, what you say is important and all. But just imagine if you added some great photos or videos to give your posts more, “pop”! Your content is excellent but with images and videos, this website could undeniably be one of the most beneficial in its field. Wonderful blog!
acheter mГ©dicament en ligne sans ordonnance Pharmacies en ligne certifiees pharmacie en ligne
Le gГ©nГ©rique de Viagra Viagra sans ordonnance 24h п»їViagra sans ordonnance 24h
pharmacie en ligne fiable https://viagrameilleurprix.com/# SildГ©nafil Teva 100 mg acheter
pharmacie en ligne france pas cher https://kamagrameilleurprix.com/# п»їpharmacie en ligne france
Pharmacie Internationale en ligne: pharmacie en ligne sans ordonnance – п»їpharmacie en ligne france
https://viagrameilleurprix.shop/# Viagra vente libre allemagne
pharmacie en ligne fiable
http://kamagrameilleurprix.com/# Pharmacie sans ordonnance
pharmacie en ligne france fiable
SildГ©nafil 100mg pharmacie en ligne: Acheter Viagra Cialis sans ordonnance – Viagra sans ordonnance 24h suisse
pharmacie en ligne fiable: Tadalafil sans ordonnance en ligne – Pharmacie Internationale en ligne
Prix du Viagra 100mg en France: Acheter Viagra Cialis sans ordonnance – Viagra homme prix en pharmacie sans ordonnance
acheter mГ©dicament en ligne sans ordonnance https://viagrameilleurprix.shop/# Viagra pas cher livraison rapide france
Viagra Pfizer sans ordonnance Viagra pharmacie Viagra pas cher livraison rapide france
Investors are typically looking for something like a 20 per year return on investment for the fund.
Achat mГ©dicament en ligne fiable https://viagrameilleurprix.com/# Viagra sans ordonnance pharmacie France
pharmacie en ligne france fiable https://pharmaciemeilleurprix.com/# acheter mГ©dicament en ligne sans ordonnance
pharmacie en ligne livraison europe: pharmacie en ligne france – pharmacie en ligne avec ordonnance