透過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, ]
These extremely supportive sneakers are the perfect for people with high arches.
https://gabapentin.auction/# neurontin 800 mg pill
Model 072. Vol. 1. Intel Corporation.
bs2site.at
bs2best.at
http://amoxil.llc/# where can i buy amoxicillin online
generic zithromax 500mg india
Thai farmer forced to kill more than 100 endangered crocodiles after a typhoon damaged their enclosure
kraken войти
A Thai crocodile farmer who goes by the nickname “Crocodile X” said he killed more than 100 critically endangered reptiles to prevent them from escaping after a typhoon damaged their enclosure.
Natthapak Khumkad, 37, who runs a crocodile farm in Lamphun, northern Thailand, said he scrambled to find his Siamese crocodiles a new home when he noticed a wall securing their enclosure was at risk of collapsing. But nowhere was large or secure enough to hold the crocodiles, some of which were up to 4 meters (13 feet) long.
To stop the crocodiles from getting loose into the local community, Natthapak said, he put 125 of them down on September 22.
“I had to make the most difficult decision of my life to kill them all,” he told CNN. “My family and I discussed if the wall collapsed the damage to people’s lives would be far bigger than we can control. It would involve people’s lives and public safety.”
Typhoon Yagi, Asia’s most powerful storm this year, swept across southern China and Southeast Asia this month, leaving a trail of destruction with its intense rainfall and powerful winds. Downpours inundated Thailand’s north, submerging homes and riverside villages, killing at least nine people.
Storms like Yagi are “getting stronger due to climate change, primarily because warmer ocean waters provide more energy to fuel the storms, leading to increased wind speeds and heavier rainfall,” said Benjamin Horton, director of the Earth Observatory of Singapore.
Natural disasters, including typhoons, pose a range of threats to wildlife, according to the International Fund for Animal Welfare. Flooding can leave animals stranded, in danger of drowning, or separated from their owners or families.
Rain and strong winds can also severely damage habitats and animal shelters. In 2022, Hurricane Ian hit Florida and destroyed the Little Bear Sanctuary in Punta Gorda, leaving 200 animals, including cows, horses, donkeys, pigs and birds without shelter.
The risk of natural disasters to animals is only increasing as human-caused climate change makes extreme weather events more frequent and volatile.
875 mg amoxicillin cost: amoxil best price – amoxicillin 875 125 mg tab
Профессиональный сервисный центр по ремонту моноблоков iMac в Москве.
Мы предлагаем: ремонт аймака в москве
Наши мастера оперативно устранят неисправности вашего устройства в сервисе или с выездом на дом!
Thai farmer forced to kill more than 100 endangered crocodiles after a typhoon damaged their enclosure
kraken onion
A Thai crocodile farmer who goes by the nickname “Crocodile X” said he killed more than 100 critically endangered reptiles to prevent them from escaping after a typhoon damaged their enclosure.
Natthapak Khumkad, 37, who runs a crocodile farm in Lamphun, northern Thailand, said he scrambled to find his Siamese crocodiles a new home when he noticed a wall securing their enclosure was at risk of collapsing. But nowhere was large or secure enough to hold the crocodiles, some of which were up to 4 meters (13 feet) long.
To stop the crocodiles from getting loose into the local community, Natthapak said, he put 125 of them down on September 22.
“I had to make the most difficult decision of my life to kill them all,” he told CNN. “My family and I discussed if the wall collapsed the damage to people’s lives would be far bigger than we can control. It would involve people’s lives and public safety.”
Typhoon Yagi, Asia’s most powerful storm this year, swept across southern China and Southeast Asia this month, leaving a trail of destruction with its intense rainfall and powerful winds. Downpours inundated Thailand’s north, submerging homes and riverside villages, killing at least nine people.
Storms like Yagi are “getting stronger due to climate change, primarily because warmer ocean waters provide more energy to fuel the storms, leading to increased wind speeds and heavier rainfall,” said Benjamin Horton, director of the Earth Observatory of Singapore.
Natural disasters, including typhoons, pose a range of threats to wildlife, according to the International Fund for Animal Welfare. Flooding can leave animals stranded, in danger of drowning, or separated from their owners or families.
Rain and strong winds can also severely damage habitats and animal shelters. In 2022, Hurricane Ian hit Florida and destroyed the Little Bear Sanctuary in Punta Gorda, leaving 200 animals, including cows, horses, donkeys, pigs and birds without shelter.
The risk of natural disasters to animals is only increasing as human-caused climate change makes extreme weather events more frequent and volatile.
אפשר לחגוג את החופש שלך, גברים. זהו כמובן פתרון פרקטי עבור גברים, בעיקר כאשר אין להם פרטיות בביתם והם זקוקים למקום בילוי. אך על הצורך בסקס נובע מתוך ”מערכת ההפעלה“ של הגבר. תפקידו הביולוגי של הגבר הוא להבטיח דיסקרטיות, אלא שירות מעולה בזמינות גבוהה. תמיד נערת ליווי
Basic Decimal Arithmetic. IBM.
Профессиональный сервисный центр по ремонту моноблоков iMac в Москве.
Мы предлагаем: imac ремонт
Наши мастера оперативно устранят неисправности вашего устройства в сервисе или с выездом на дом!
https://amoxil.llc/# rexall pharmacy amoxicillin 500mg
We thought we would give Jodhpur a miss altogether.
The primary crops grown are maize, sorghum and sunflowers.
Отличный сайт! Всем рекомендую!Детская оптика СПб
minocycline for acne ivermectin 8 mg where to buy stromectol
בילוי צריך קצת שקט – כאן יש נערות שיודעות כיצד להעניק לך את מה שאתה צריך. דירות דיסקרטיות בחולון הן חוויה שלמה. זוהי לא רק ואין להם פרטיות. דירות כל כאב ומחשבה שלילית. בילוי המעורר את הגבר, אפילו אם הוא רדום תחת מעטפת לחצים. אלו הן תחושות הנאה מרגשות link
Excellent beat ! I wish to apprentice while you amend your site, how can i subscribe for a blog site? The account aided me a acceptable deal. I had been a little bit acquainted of this your broadcast offered bright clear idea
order amoxiclav for sale – buy clavulanate generic synthroid pills
It’s all the time good to have a pair of rain boots that aren’t made from low-cost plastic.
https://zithromax.company/# buy zithromax 500mg online
Hey there! This is my 1st comment here so I just wanted to give a quick shout out and tell you I truly enjoy reading through your posts. Can you recommend any other blogs/websites/forums that cover the same subjects? Thank you so much!
https://zithromax.company/# purchase zithromax z-pak
zithromax prescription online
ivermectin cost: stromectol best price – what is minocycline
https://semaglutide.win/# Buy compounded semaglutide online
Профессиональный сервисный центр по ремонту моноблоков iMac в Москве.
Мы предлагаем: ремонт аймаков в москве
Наши мастера оперативно устранят неисправности вашего устройства в сервисе или с выездом на дом!
It’s prime swan actual estate, evident from the birds’ traces everywhere in the towpath by the faculty boathouses, but apart from that Eton is far quieter, with a historical past path, some good pubs and establishments such as the a lot-beloved wine bar Gilbey’s.
Then again, hydraulic divan beds can swimsuit the guest bedrooms beautifully.