透過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, ]
dark market url https://github.com/darkwebsitesyhshv/darkwebsites – darkmarket link
official site backpack download
Or scrapped rebasing for CGT, so that tax solely imposed on precise disposals.
The crypto industry is advancing. (Just don’t ask it where it’s going.)
trust wallet
After a dramatic start to the year, the crypto industry is settling into a new reality — one in which the White House is laying out the red carpet and promising an unprecedented level of support.
Crypto, a roughly 15-year-old industry that’s largely operated on the fringes of finance, is at a crossroads. For years, it has blamed a hostile regulatory environment for not allowing it to unleash its supposedly revolutionary technology on Americans. Now, though, their favorite bogeyman, Gary Gensler, the Securities and Exchange Commission chief under President Joe Biden, is gone. Crypto cheerleaders have been installed throughout the government.
The SEC has dropped several enforcement cases against crypto companies and, starting Friday, is hosting a series of public roundtables “to discuss key areas of interest in the regulation of crypto assets.”
Under President Donald Trump, there’s virtually nothing stopping crypto companies from creating and selling their products.
At the same time, the same White House’s chaotic trade policy is undermining financial markets’ appetite for risk, leaving bitcoin in limbo, more than 20% off from its record high in January. And while the industry is grateful for all the attention, the White House’s embrace of some of crypto’s less savory aspects, like meme coins, has given serious investors pause.
Given the enormous potential for the $3 trillion industry in this moment, I checked in with Eswar Prasad, a Cornell University professor of international trade and the author of the 2021 book “The Future of Money,” about the forces disrupting financial technologies.
Fundamentally, Prasad brings a pragmatist’s view of crypto that is as refreshing as it is rare in a subject area that tends to attract zealots and loudmouths. We spoke over the phone shortly after the first-of-its-kind White House crypto summit earlier this month.
The following interview has been edited for length and clarity.
Nightcap: We just saw a pretty wild thing happen with the crypto summit — hard to imagine a scenario like that taking place under any previous administration. What were your takeaways?
Eswar Prasad: The crypto industry is kissing the ring, and I think it’s getting exactly what it wants from the Trump administration, which is the legitimacy provided by government oversight, coupled with what is almost certain to be quite light touch and non-inclusive regulation.
And I think we saw many of the major players in the crypto industry essentially using the opportunity to not just thank Trump, but try to make the point, which seemed to resonate with Trump, that this industry can power, in some sense, a resurgence of a certain part of the US economy.
see
backpack xnft
Wow! This could be one particular of the most beneficial blogs We’ve ever arrive across on this subject. Basically Great. I am also an expert in this topic so I can understand your hard work.
darknet markets url https://github.com/abacuslink4jjku/abacuslink – darknet market links
darknet markets links https://github.com/aresmarketdarknetl9khn/aresmarketdarknet – darknet market
darknet marketplace darknet drug store
darknet websites dark markets 2025
dark market list https://github.com/darkwebsitesyhshv/darkwebsites – darknet drug links
this link crypto backpack
A lot of thanks for all of your labor on this blog. Betty really loves engaging in research and it’s simple to grasp why. My partner and i notice all relating to the dynamic form you give valuable things by means of the web blog and invigorate response from the others on the concept and our favorite princess is being taught a lot. Enjoy the remaining portion of the year. You are doing a terrific job.
check my reference
backpack extension
dark market list https://github.com/abacuslink4jjku/abacuslink – darknet site
darknet market links dark web market links
onion dark website darknet markets onion
darknet links tor drug market
tor drug market https://github.com/aresmarketdarknetl9khn/aresmarketdarknet – darknet sites
darknet drug market dark markets
промокод пари на фрибет без депозита
onion dark website https://github.com/nexusdarkrtv1u/nexusdark – darknet markets onion
great post to read xnft backpack
darknet drug market darknet marketplace
darknet drugs https://github.com/darkwebsitesyhshv/darkwebsites – dark web market list
Knowledgeable handyman can repair a loose wire or make different minor repairs.
click to read backpack app
image source backpack chrome
1xbet bet slip code today free
that site backpack extension