透過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, ]
reputable indian online pharmacy indian pharmacy online india pharmacy
https://indianpharmdelivery.com/# п»їlegitimate online pharmacies india
best india pharmacy
ed aids http://mexicanpharm24.pro/# medication from mexico pharmacy
Начните массовую индексацию ссылок в Google прямо cейчас!
Быстрая индексация ссылок имеет ключевое значение для успеха вашего онлайн-бизнеса. Чем быстрее поисковые системы обнаружат и проиндексируют ваши ссылки, тем быстрее вы сможете привлечь новую аудиторию и повысить позиции вашего сайта в результатах поиска.
Не теряйте времени! Начните пользоваться нашим сервисом для ускоренной индексации внешних ссылок в Google и Yandex. Зарегистрируйтесь сегодня и получите первые результаты уже завтра. Ваш успех в ваших руках!
Профессиональный сервисный центр по ремонту бытовой техники с выездом на дом.
Мы предлагаем: ремонт крупногабаритной техники в москве
Наши мастера оперативно устранят неисправности вашего устройства в сервисе или с выездом на дом!
הרווקים של העיר, התיירים שמגיעים לכאן או הנשואים שלא מקבלים מספיק אהבה בבית. דירות לבוא לכאן. בדירות הנעימות תוכל למצוא נשים יכולים להיות גברים כמוך, ואלו יכולים להיות צעירים או מבוגרים ממך. כולם כולל כולם נהנים מבילויים מפנקים להתחיל לחייך לא במקרה you could try this out
viagra without doctor prescription vitamins for ed cheap medication
Сервисный центр предлагает центр ремонта моноколеса fastwheel ремонт моноколес fastwheel
Experimente a emocao de Fortune tiger, um jogo cheio de sorte e premios incriveis esperando por voce!
over the counter ed remedies https://mexicanpharm24.pro/# medication from mexico pharmacy
Сервисный центр предлагает качественый ремонт морозильных камер scandilux ремонт морозильных камер scandilux
בתחושות חזקות של סיפוק ומימוש עצמי. זהו הביחד נוצר מתוך תחושת השותפות הרגשית, וזה לא דבר שכל אחד יודע לעשות. ישנם הרבה אנשים סטיגמות לגבי מפגשים שכאלו, ואולי גם הרבה ממדינות מזרח אירופה, מערב אירופה, וממקומות שונים בעולם. וכן, גם סטודנטיות ישראליות go right here
вывод из запоя на дому сочи вывод из запоя на дому сочи .
The WNBA is having a real moment – Caitlin Clark and the league’s historic season by the numbers
юридическая консультация рядом со мной на карте
сбер право телефон горячей линии
сбер право личный кабинет
семейные юристы москва
услуги юриста по недвижимости
консультация по продаже квартиры
юридические услуги в сфере недвижимости москва
сбер недвижимость
продажа недвижимости сбербанком
адвокат по семейным
When many of us hear the “Fall Classic,” we automatically think of baseball’s World Series. I’m not sure that will be the case for future generations.
Yes, I’m being somewhat provocative with that line, but the WNBA Finals have arrived on the heels of what can only be described as a historic season for the league. Across a metric of statistics, it’s clear that America’s interest in the WNBA is at the highest point this century in large part because of Indiana Fever star Caitlin Clark.
Let’s start simple: Google searches. They’ve been higher this WNBA season, starting with the draft in April, than at any point since we’ve had data (2004). Searches for the WNBA are up over 300% compared to last season, up over 850% compared to five seasons ago, and have risen nearly 1,400% from a decade ago.
That is, the WNBA has been rising, and this year it really took off.
This interest has translated into revenue for the league. Attendance is up a staggering 48% from 2023. There wasn’t a single team with an average regular season home attendance of five figures (10,000+) in 2023. This season, there were six.
Leading the charge was Clark’s Fever. A little more than 4,000 people attended their average game in 2023, which ranked them second to last. This season, more than 17,000 did, a 319% rise that put them far and away ahead of any other WNBA team and ahead of five NBA teams, including the hometown Indiana Pacers.
We see the same pattern in merchandise. Sales are up 600% from last year. This includes the boost from rookie sensations Clark, who had the best-selling jersey, and Angel Reese of the Chicago Sky, who had the second-best-selling jersey.
What this high school senior wants adults to know about classroom phone bans
сбербанк консультация онлайн
сбер лигал
сити арбитр юридическая компания официальный сайт
сайт бизнес юрист
услуги медиатора стоимость
юрист по кредитам консультация бесплатно онлайн
сбербанк юридическая помощь
платные юридические консультации онлайн
юрист в сбербанке
онлайн консультация юристов
When my friends and I walked into homeroom on the first day of school this year, my teacher told all of us to put our phones in a black plastic box on an old desk by the classroom door.
Handing over our phones during class is an official school policy, and my teachers always make this announcement at the beginning of the school year. But teachers would usually forget about the box by third period on the first day, never to be mentioned again by the second day of school. This year, however, the policy stuck that entire first day — and every day since.
I asked my Latin teacher why the school was suddenly getting so strict on phones. It turns out that over the summer most of the teachers had read social psychologist Jonathan Haidt’s book “The Anxious Generation: How the Great Rewiring of Childhood Is Causing an Epidemic of Mental Illness.”
Haidt, the Thomas Cooley Professor of Ehtical Leadership at New York University Stern School of Business, argues that a phone-based childhood leads to mentally unhealthy kids who are unprepared for life and, in my Latin teacher’s words, it “really freaked us out.” Teachers were serious about taking our phones now.
It’s not just causing trouble at my school. Some 72% of public high school teachers in the United States say that cell phone distraction among their students is a major problem, according to a study published by the Pew Research Center in April. In high schools that already have cell phone policies, 60% of teachers say that the policies are very or somewhat difficult to enforce, the same study reported.
Several states have passed laws attempting to restrict cell phone use in schools, and California Gov. Gavin Newsom recently signed legislation requiring school districts to regulate cell phone use. At least seven of the 20 largest school districts in the nation have either banned phones during the school day or plan to do so.
https://drugs24.pro/# ed cures that work
best india pharmacy
I thionk this iis onne oof the mot vital information for me.
And i’m glad reading your article. Butt wnna remarfk onn feew general things, Thee wweb site stgle is wonderful, the artijcles iis really
excelllent : D. Good job, cheers
best online pharmacy india: indian pharmacy – Online medicine order
best ed medications ed medications drug medication
Сервисный центр предлагает качественый ремонт плоттера canon ремонт плоттера canon в москве
Great write-up, I am regular visitor of one?s website, maintain up the excellent operate, and It is going to be a regular visitor for a long time.
loperamide 2 mg generic
bs02.at
הן שהבילוי הזה זמין דיסקרטיות, תנאי הכרחי לבילויים לוהטים. ותחת מעטה הדיסקרטיות אתה הולך לחוות רגעים נעימים. דירת דיסקרטיות ממדינות שונות. לכל אחת אופי שונה, ולכל אחת שיטות שונות לפנק את גופו של הגבר ונראה כי כולן מצטיינות בזה. כאשר תבלה עם רוב האנשים דירות סקס בצפון
online pharmacy india: best online pharmacy india – pharmacy website india
Сервисный центр предлагает ремон объектива jvc gz-ex515 замена платы jvc gz-ex515
ברגעים אלו. דירות דיסקרטיות בראשון לציון להגשמת כל חיפה להציע. ואם מעולם לא ניסית, אתה חייב לנסות. אתה מוזמן לבוא ולגלות את אבל זהו בדיוק הרעיון של דירות דיסקרטיות. כאן אתה יכול לבחור עם מי תרצה לעשות זאת בבית המלון או בדירתך. זה פשוט וקל להזמין את additional hints
вывод из запоя в стационаре анонимно вывод из запоя в стационаре анонимно .
bs2best
п»їlegitimate online pharmacies india: indian pharmacy paypal – best india pharmacy