透過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, ]
порно худых русских женщин порно худых русских женщин .
русское порно худые русское порно худые .
купить диплом о высшем образовании в казани asxdiplomik24.ru .
Thanks for helping me to attain new concepts about computer systems. I also hold the belief that one of the best ways to keep your laptop in best condition has been a hard plastic-type case, and also shell, that fits over the top of the computer. These kinds of protective gear are usually model targeted since they are manufactured to fit perfectly in the natural outer shell. You can buy these directly from the owner, or via third party places if they are intended for your laptop, however its not all laptop could have a cover on the market. Yet again, thanks for your points.
tinidazole 500mg online
purchase leflunomide sale – generic calcium carbonate cartidin buy online
buy rogaine medication – purchase rogaine finpecia generic
Call for General Info877.871.6772 Accessible Amenities onlineRoulette Extend your visit to Bristol Casino by staying nearby. Our partner hotels below are conveniently located close to the action. At Coeur d’Alene Casino Resort Hotel, you’ll enjoy a premier hotel experience that’ll make you feel right at home. Here, you have the best of both worlds. Rest comfortably in several of the suites and rooms available and enjoy our many amenities including live music in our lounges on weekends, restaurants, a spa, shopping, golf and the endless entertainment found on our world-class gaming floor. Every stay at the St. Croix Casino Danbury Hotel is special. Our attached hotel features 47 comfortable guest rooms, including standard rooms and suites, high-roller suites and extra-spacious executive suites with second-story lofts. Highlights of our Danbury hotel include a deluxe indoor pool and Jacuzzi, fitness center, arcade, and well-equipped conference center.
https://wiki-wire.win/index.php?title=Poker_news_daily
Cash’em All is one of the best game apps if you want to earn free money. They won’t impede your gameplay with in-app purchases or ad walls. Instead, they will pay you in their app currency called “coins” for every second you play. They have many top games for you to choose from, so you’ll never get bored. But the same is not true with poker: You should practice the game with your friends first, at home, Bean said, until you are comfortable with it. Bean said novices are best off passing on the poker tables, where yes, the competition can be tough. During free spins, you’ll enter a bonus round where expanding wilds can boost your payouts. Catching two more scatter symbols during those free spins will trigger the Honeypot Prize Wheel, a mega wheel feature. On the wheel, you’ll find prizes that include 15 more free spins and multipliers of 5x-30x your stake. Honey Hive’s unique approach to the traditional free spins bonus adds an exciting twist that can be lucrative.
Its like you read my mind! You seem to know so much about this, like you wrote the book in it or something. I think that you could do with some pics to drive the message home a little bit, but instead of that, this is wonderful blog. An excellent read. I’ll certainly be back.
http://tehnoprice.in.ua/yak-obraty-sklo-dlya-far-porady-profesionaliv
Once your deposit is made, you’re ready to get started playing top casino games from all of the world’s best software developers right here at JeffBet! Remember, you can also grab our fantastic welcome bonus if you are a new player, just make sure you fulfil each wagering requirement to get the bonus. We offer hundreds of thrilling UK slots, jackpot slots, video poker games, casino and live casino games, so don’t delay any longer and make your pay by phone deposit today. The exclusive range of slot mobile games at Vegas Mobile Casino is enough to keep all the players entertained for a long time. Enchanting, magical themes compete with the modern and sci-fi for your attention in our Vegas themed casino! As mentioned above, avoiding unlicensed online casinos in America is the best way to ensure a safe, fair, and secure experience. We’ve created a list of blacklisted casinos, which don’t follow the rules and regulations of a casino license. Playing at blacklisted casinos on mobile or PC could result in unfair results, difficulty to withdraw, higher wagering requirements, and poor quality games.
https://www.pauljanosrealestate.com/forum/general-discussions/best-cash-poker-apps
Your request has been blocked due to a network policy. Always remember that all free casino deals are tied to certain rules that ought to be followed strictly, as it’s the only way you can cashout part or all of your winnings. code: 55CANDIES Operated by Ace Revenue Group, Planet 7 Casino is also one of the older online casinos still open to USA players for real money. I also appreciate both a no-deposit 50 free spin offer and a no-deposit $50 free chip. New post, thanhduy8012 replied to Top 4 Winners for the week of 11 March $285 no deposit bonus for Planet 7 CasinoYour bonus code: FALL28530X Playthrough$100 Max Cash-Out* If your last transaction was a free chip then make a deposit before claiming this one or you will not be able to cash out your winnings You can read Reddit’s Terms of Service here.
where to buy coreg
wow mythic raid carry for sale https://www.kreativwerkstatt-esens.de .
wow mythic raid boost wow mythic raid boost .
wow raid boosting kreativwerkstatt-esens.de .
wow mythic raid carry wow mythic raid carry .
wow the war within raid boost kreativwerkstatt-esens.de .
Thanks for your write-up on the vacation industry. I’d also like to include that if your senior thinking about traveling, its absolutely crucial that you buy traveling insurance for seniors. When traveling, older persons are at greatest risk being in need of a medical emergency. Obtaining right insurance coverage package in your age group can protect your health and provide you with peace of mind.
wow raid carry wow raid carry .
cheap. wow. raid. carry. http://kreativwerkstatt-esens.de .
En guvenilir online casino Sweet bonanza
mythic raid carry wow kreativwerkstatt-esens.de .
En populer kumarhaneyi deneyin Sweet bonanza
buy online prescription drugs
You have mentioned very interesting details! ps nice site.Leadership
Great post made here. One thing I’d like to say is the fact most professional areas consider the Bachelor Degree as the entry level requirement for an online college degree. Although Associate Qualifications are a great way to begin with, completing your Bachelors reveals many doorways to various careers, there are numerous on-line Bachelor Course Programs available through institutions like The University of Phoenix, Intercontinental University Online and Kaplan. Another thing is that many brick and mortar institutions make available Online variations of their certifications but commonly for a considerably higher payment than the firms that specialize in online qualification programs.
Привет, друзья!
Заказать диплом любого ВУЗа
Наша компания предлагает максимально быстро купить диплом, который выполняется на оригинальном бланке и заверен мокрыми печатями, водяными знаками, подписями официальных лиц. Наш диплом способен пройти любые проверки, даже при помощи специальных приборов. Достигайте цели быстро и просто с нашей компанией.
Где купить диплом специалиста?
https://www.import-moto.com/users/88
Окажем помощь!.
Привет, друзья!
Где купить диплом специалиста?
Заказать диплом о высшем образовании.
https://www.simplemachines.org/about/smf/stats.php
Успешной учебы!
Bu kumarhanedeki en iyi oyunlar Sweet bonanza
Отличный сатй! Всем рекомендую!скупка золота москва
Guvenilir bir kumarhanede oynay?n Sweet bonanza