read an excel file in .xlsx format

[anvi kon]

Is it possible to read an excel file in .xlsx format not xls format using JXL?

Please send me some examples .


thanks

[Paul Clapham]

It tells you the answer to that question right on the project's home page: http://jexcelapi.sourceforge.net/

[jammy chen]

                Workbook wrokBook = Workbook.getWorkbook(input);
                book = Workbook.createWorkbook(file, wrokBook);

use above getting a try or read the offical reference guide from the project url http://jexcelapi.sourceforge.net/

[Rob Spoor]

Paul Clapham wrote:It tells you the answer to that question right on the project's home page: http://jexcelapi.sourceforge.net/

And since .xlsx is Excel 2007 and that one's not mentioned, the answer is no.

Apache POI has support for Excel 2007 through XSSF.

[metin lapo]

this solution involves using the zip and stax(read/write xml) api

http://www.mets-blog.com/java-read-excel-xlsx-file-part-1/

Usage:

String filename = "test.xlsx";

ZipFile zipFile = new ZipFile(filename);

ArrayList list = getSheetsXML(zipFile);

List input = getSharedStrings(zipFile);

System.out.println(getCellValues(list.get(0), input).toString());

zipFile.close();

Source

public static Map getCellValues(InputStream input, List sharedStrings) throws XMLStreamException, FactoryConfigurationError{

        HashMap cellValues = new HashMap();

        boolean isString = false;
        String cellID = null;

        XMLStreamReader xmlStreamReader = XMLInputFactory.newInstance().createXMLStreamReader(input);

        while (xmlStreamReader.hasNext()) {

            xmlStreamReader.next();

            if (xmlStreamReader.getEventType() == XMLStreamConstants.START_ELEMENT) {

                if (xmlStreamReader.getLocalName().equals("c") && xmlStreamReader.getAttributeCount() > 0) {

                    for (int i = 0; i  0)) {

                if(isString){

                    int sharedStringKey = Integer.valueOf(xmlStreamReader.getText());
                    cellValues.put(cellID, sharedStrings.get(sharedStringKey));
                    isString = false;

                }else {
                    cellValues.put(cellID, xmlStreamReader.getText());
                }

            }


        }

        return cellValues;
    }

    public static ArrayList getSheetsXML(ZipFile zipFile) throws IOException  {

        Enumeration em = zipFile.entries();

        ArrayList sheets = new ArrayList();

        ZipEntry zipEntry = null;

        while(em.hasMoreElements()){

            zipEntry = em.nextElement();

            if(zipEntry.getName().contains("sheet")){

                sheets.add(zipFile.getInputStream((zipEntry)));

            }
        }

        return sheets;
    }

    public static List getSharedStrings(ZipFile zipFile) throws IOException, XMLStreamException  {

        Enumeration em = zipFile.entries();

        InputStream strings = null;

        ZipEntry zipEntry = null;

        while(em.hasMoreElements()){

            zipEntry = em.nextElement();

            if(zipEntry.getName().contains("sharedStrings")){

                strings = zipFile.getInputStream(zipEntry);
                break;
            }
        }


        /* Now we have the xml stream with all unique strings, I'll use stax to read the xml and add them to a list */

        ArrayList stringList = new ArrayList();

        XMLStreamReader xmlStreamReader = XMLInputFactory.newInstance().createXMLStreamReader(strings);

        while (xmlStreamReader.hasNext()) {

            // go to next event
            xmlStreamReader.next();

            // the current event is characters and the content is not all white space
            if ((xmlStreamReader.getEventType() == XMLStreamConstants.CHARACTERS) && (xmlStreamReader.getText().trim().length() > 0)) {

                stringList.add(xmlStreamReader.getText());

            }

        }

        xmlStreamReader.close();

        return stringList;
    }

[Ulf Dittmer]

I wouldn't call that "a solution". The mere fact that Office 2007 formats are a zipped collection of XML files, and can be treated as such, is not at all the same as what you gain by using a library such as jExcelAPI for Office 2003 files, and POI for Office 2003 and Office 2007 files.