"Package should contain a content type part [M1.13]"

Question

I am attempting to write to an Excel file however I keep getting the error:

Exception in thread "main" org.apache.poi.POIXMLException: org.apache.poi.openxml4j.exceptions.InvalidFormatException: Package should contain a content type part [M1.13]

From what I understand I am missing a jar file.

Can anyone help me identify which file it is?

P.S. I am using 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);

    }      

}

The error is not about missing jar file. It is about missing content type part within the ShowDetails.xlsx file. So I suspect the ShowDetails.xlsx is not generated by Excel but by some third party software which does something wrong. Open the ShowDetails.xlsx with Excel, save it again with Excel and then try again with POI. — Axel Richter, Oct 01 '15 at 05:56
@AxelRichter You were right, I re saved it and it worked however I got another error now haha. Exception in thread "AWT-EventQueue-0" java.lang.NoSuchMethodError: org.apache.poi.util.POILogger.log(I[Ljava/lang/Object;)V — Tephrite, Oct 01 '15 at 06:57
There is a mix of different POI versions in the ClassPath. See: http://poi.apache.org/faq.html#faq-N10006. But I've no experience with Netbeans. So I don't know how to clean up the ClassPath there. Maybe others know. — Axel Richter, Oct 01 '15 at 07:27

score 16 · Answer 1 · answered Jun 07 '17 at 06:37

Use file extension to handle WorkSheet Type

  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\"";
                    }

For XLSX file: use XSSFWorkbook & XSSFSheet

    XSSFWorkbook workbook = new XSSFWorkbook(new FileInputStream(new File(path)));

    XSSFSheet sheet = workbook.getSheetAt(0);

For XLS file: use HSSFWorkbook & HSSFSheet

    HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(new File(path)));

    HSSFSheet sheet = workbook.getSheetAt(0);

score 7 · Answer 2 · answered Nov 17 '16 at 11:05

7

This may happen when your create your XLS/XLSX file through LibreOffice. Apparently something is lost in the conversion and the file is not the same as a spreadsheet made in Microsoft Office. I had the same error and the solution for me was copying all the work I have done in LibreOffice Calc to a MS Excel spreadsheet and then save a new file.

answered Nov 17 '16 at 11:05

Gabriel Ullmann

151
4
11

Thanks! It may also be because the hidden file starting with `~$` was selected instead of the normal one, if it is still open for editing in the application (my case). – Martin Patsov May 19 '20 at 12:03

score 3 · Answer 3 · edited Nov 03 '17 at 01:36

What you have is version mismatch between your Excel file and workbook you are trying to create. The best way to avoid is: choose Interface implementation.

I built on top of Hitesh Sahu's solution:

import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;

Workbook workbook = null;

// parse files from request
MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
MultipartFile multipartDataPointsFile = multipartRequest.getFile("yourFileHere");

try {
    if(multipartDataPointsFile!=null) {
        String originalFileName= multipartDataPointsFile.getOriginalFilename();
        if(originalFileName!=null && originalFileName.length()>0) {
            switch (originalFileName.substring(originalFileName.lastIndexOf(".") + 1,
                    originalFileName.length())) {
                case "xls":
                    try {
                        workbook = WorkbookFactory.create(multipartDataPointsFile.getInputStream());
                    }catch(org.apache.poi.openxml4j.exceptions.InvalidFormatException ie){
                        logger.error("Malformed Excel");
                        throw new IOException();
                    }
                    if(workbook!=null) {
                        // Do something in here
                    }else{
                        logger.error("Could not pass along the workbook");
                        throw new IOException();
                    }
                case "xlsx":
                    try {
                        workbook = WorkbookFactory.create(multipartDataPointsFile.getInputStream());
                    }catch(org.apache.poi.openxml4j.exceptions.InvalidFormatException ie){
                        logger.error("Malformed Excel");
                        throw new IOException();
                    }
                    if(workbook!=null) {
                          // Do something in here
                    }else{
                        logger.error("Could not pass along the workbook");
                        throw new IOException();
                    }
                default:
                    logger.error("File type is not  recognized  Excell type");
                    throw new IOException();
            }

        }else{
            logger.error("Can Not Read File Name");
            throw new IOException();  
        }
    }else{
        logger.error("Did not select a file");
        throw new IOException();
    }
} catch (IOException e) {
    throw new ApplicationErrorException("Can't parse  Excel file");
}

score 1 · Answer 4 · answered Oct 04 '17 at 04:00

1

I have the same problem. When you open excel file it will generate some file like ~$______.xlsx Just find and delete all of them worked for me.

answered Oct 04 '17 at 04:00

Long Nguyen

9,898
5
53
52

These are temporary copies of the file to prevent it from being corrupted so you could restore them... But, this indeed solved my problem!!!! Just unbelievable!! – Shai Alon Dec 27 '20 at 20:18

score 0 · Answer 5 · answered Mar 14 '16 at 08:16

CHECK EXCEL FORMAT .... Firstly I created an sample excel with poi and I changed the columns with mine first attempt it give same error but after few try it successfully read .I wonder why it didn't worked first run :( but If you have right library please check the correct excel format

score 0 · Answer 6 · answered Jul 06 '17 at 07:57

0

I got the same problem. Your excel isn't in right format. You can copy all work to new sheet or do Clear Format. Good luck.

answered Jul 06 '17 at 07:57

Pham Hung

308
1
4
14

Michał Sokołowski · Answer 7 · 2018-03-06T13:28:46.150

0

Another possible solution is

Workbook workbook = WorkbookFactory.create(source)

WorkbookFactory should be provided by Apache POI you are using (if not upgrade to newer version). It recognize file format and creates concrete implementation of Workbook interface (XSSFWorkbook or HSSFWorkbook). The source parameter can be java.io.InputStream or java.io.File.

edited Mar 06 '18 at 13:28

answered Mar 06 '18 at 11:58

Michał Sokołowski

326
3
10

score 0 · Answer 8 · answered Jun 06 '18 at 22:43

The excel file which your application trying to access is not responding due to network issues or corrupted format causes this error. If it is due to network issue try to run application later (or) If file is corrupted, try to put new file and test your application. Good Luck.

score 0 · Answer 9 · answered Aug 21 '18 at 10:28

Ok in my case this is how I had it and line3 was throwing this exception:

File xlsxFile = new File( "C:\\myWorkbook.xlsx" );
FileInputStream finXLSX = new FileInputStream( xlsxFile ); //line1

FileOutputStream foutXLSX = new FileOutputStream( xlsxFile ); //line2

XSSFWorkbook workSheet = new XSSFWorkbook( finXLSX ); //line3

But I figured out that line3 wasn't working as I had also opened an output stream on my xlsx file via line2 and then doing line3 was failing. I removed line2 to make it work.

score 0 · Answer 10 · answered Jul 03 '19 at 21:57

0

My excel sheet was encrypted. Deleted the password and it worked.

answered Jul 03 '19 at 21:57

Manpreet

11

score 0 · Answer 11 · answered Mar 11 '20 at 11:26

0

I came across similar issue, finally found that file was having sensitivity --> as confidential, change it to public ..solved my issue. all the best

answered Mar 11 '20 at 11:26

rahmatulla

1

score 0 · Answer 12 · answered Jun 11 '22 at 04:08

0

The file could be opened in the background.... that just happened to me

answered Jun 11 '22 at 04:08

Capps99

111
1
3

"Package should contain a content type part [M1.13]"

12 Answers12

Linked