java – “包应包含内容类型部分[M1.13]”
发布时间:2020-12-14 16:21:32 所属栏目:Java 来源:网络整理
导读:我试图写入Excel文件,但我一直收到错误: Exception in thread “main” org.apache.poi.POIXMLException: org.apache.poi.openxml4j.exceptions.InvalidFormatException: Package should contain a content type part [M1.13] 根据我的理解,我错过了一个jar
我试图写入Excel文件,但我一直收到错误:
根据我的理解,我错过了一个jar文件. 任何人都可以帮我识别它是哪个文件? 附:我正在使用Netbeans. import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import javax.swing.JOptionPane; import org.apache.poi.openxml4j.exceptions.InvalidFormatException; import org.apache.poi.xssf.usermodel.XSSFCell; import org.apache.poi.xssf.usermodel.XSSFRow; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; /** * * @author nicholaskissaun */ public class Tester { public static void main (String args [])throws FileNotFoundException,IOException,InvalidFormatException{ int RowCount = 7,iChoice; String sChoice; XSSFSheet s; XSSFRow row1; XSSFWorkbook wb; XSSFCell r1c1,r1c2,r1c8,r1Episodes; FileInputStream fis = new FileInputStream("/Users/nicholaskissaun/Google Drive/Grade 11_12/Computer Science/Java/Term1/src/IA/Profiles/Becky/ShowDetails.xlsx"); wb = new XSSFWorkbook(fis); s = wb.getSheetAt(0); } } 解决方法
使用文件扩展名来处理WorkSheet类型
String inputFilename = new File(path).getName(); switch (inputFilename.substring(inputFilename.lastIndexOf(".") + 1,inputFilename.length())) { case "xls": return readXLS(path); case "xlsx": return readXLSX(path); default: Log.e(TAG,"No XLS file chosen"); return "Please select valid "Excel" File""; } 对于XLSX文件:使用XSSFWorkbook& XSSFSheet XSSFWorkbook workbook = new XSSFWorkbook(new FileInputStream(new File(path))); XSSFSheet sheet = workbook.getSheetAt(0); 对于XLS文件:使用HSSFWorkbook& HSSFSheet HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(new File(path))); HSSFSheet sheet = workbook.getSheetAt(0); (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |