Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
org.dhatim.fastexcel.reader.OPCPackage Maven / Gradle / Ivy
package org.dhatim.fastexcel.reader;
import org.apache.commons.compress.archivers.zip.ZipArchiveEntry;
import org.apache.commons.compress.archivers.zip.ZipFile;
import org.apache.commons.compress.utils.IOUtils;
import org.apache.commons.compress.utils.SeekableInMemoryByteChannel;
import javax.xml.stream.XMLStreamException;
import java.io.File;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.Collections;
import java.util.Enumeration;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Optional;
import java.util.concurrent.atomic.AtomicBoolean;
import java.util.regex.Pattern;
import static java.lang.String.format;
import static org.dhatim.fastexcel.reader.DefaultXMLInputFactory.factory;
class OPCPackage implements AutoCloseable {
private static final Pattern filenameRegex = Pattern.compile("^(.*/)([^/]+)$");
// Following is a listing of number formats whose formatCode
// value is implied rather than explicitly saved in the file.
// https://learn.microsoft.com/en-us/dotnet/api/documentformat.openxml.spreadsheet.numberingformat?view=openxml-2.8.1
private static final Map IMPLICIT_NUM_FMTS = new HashMap() {{
put("1", "0");
put("2", "0.00");
put("3", "#,##0");
put("4", "#,##0.00");
put("9", "0%");
put("10", "0.00%");
put("11", "0.00E+00");
put("12", "# ?/?");
put("13", "# ??/??");
put("14", "mm-dd-yy");
put("15", "d-mmm-yy");
put("16", "d-mmm");
put("17", "mmm-yy");
put("18", "h:mm AM/PM");
put("19", "h:mm:ss AM/PM");
put("20", "h:mm");
put("21", "h:mm:ss");
put("22", "m/d/yy h:mm");
put("37", "#,##0 ;(#,##0)");
put("38", "#,##0 ;[Red](#,##0)");
put("39", "#,##0.00;(#,##0.00)");
put("40", "#,##0.00;[Red](#,##0.00)");
put("45", "mm:ss");
put("46", "[h]:mm:ss");
put("47", "mmss.0");
put("48", "##0.0E+0");
put("49", "@");
}};
private final ZipFile zip;
private final Map workbookPartsById;
private final PartEntryNames parts;
private final List formatIdList;
private Map fmtIdToFmtString;
private OPCPackage(File zipFile) throws IOException {
this(zipFile, false);
}
private OPCPackage(File zipFile, boolean withFormat) throws IOException {
this(new ZipFile(zipFile), withFormat);
}
private OPCPackage(SeekableInMemoryByteChannel channel, boolean withStyle) throws IOException {
this(new ZipFile(channel), withStyle);
}
private OPCPackage(ZipFile zip, boolean withFormat) throws IOException {
try {
this.zip = zip;
this.parts = extractPartEntriesFromContentTypes();
if (withFormat) {
this.formatIdList = extractFormat(parts.style);
} else {
this.formatIdList = Collections.emptyList();
}
this.workbookPartsById = readWorkbookPartsIds(relsNameFor(parts.workbook));
} catch (XMLStreamException e) {
throw new IOException(e);
}
}
private static String relsNameFor(String entryName) {
return filenameRegex.matcher(entryName).replaceFirst("$1_rels/$2.rels");
}
private Map readWorkbookPartsIds(String workbookRelsEntryName) throws IOException, XMLStreamException {
String xlFolder = workbookRelsEntryName.substring(0, workbookRelsEntryName.indexOf("_rel"));
Map partsIdById = new HashMap<>();
SimpleXmlReader rels = new SimpleXmlReader(factory, getRequiredEntryContent(workbookRelsEntryName));
while (rels.goTo("Relationship")) {
String id = rels.getAttribute("Id");
String target = rels.getAttribute("Target");
// if name does not start with /, it is a relative path
if (!target.startsWith("/")) {
target = xlFolder + target;
} // else it is an absolute path
partsIdById.put(id, target);
}
return partsIdById;
}
private PartEntryNames extractPartEntriesFromContentTypes() throws XMLStreamException, IOException {
PartEntryNames entries = new PartEntryNames();
final String contentTypesXml = "[Content_Types].xml";
try (SimpleXmlReader reader = new SimpleXmlReader(factory, getRequiredEntryContent(contentTypesXml))) {
while (reader.goTo(() -> reader.isStartElement("Override"))) {
String contentType = reader.getAttributeRequired("ContentType");
if (PartEntryNames.WORKBOOK_MAIN_CONTENT_TYPE.equals(contentType)
|| PartEntryNames.WORKBOOK_EXCEL_MACRO_ENABLED_MAIN_CONTENT_TYPE.equals(contentType)) {
entries.workbook = reader.getAttributeRequired("PartName");
} else if (PartEntryNames.SHARED_STRINGS_CONTENT_TYPE.equals(contentType)) {
entries.sharedStrings = reader.getAttributeRequired("PartName");
} else if (PartEntryNames.STYLE_CONTENT_TYPE.equals(contentType)) {
entries.style = reader.getAttributeRequired("PartName");
}
if (entries.isFullyFilled()) {
break;
}
}
if (entries.workbook == null) {
// in case of a default workbook path, we got this
// extractFormat(String styleXml) throws XMLStreamException, IOException {
List fmtIdList = new ArrayList<>();
fmtIdToFmtString = new HashMap<>();
try (SimpleXmlReader reader = new SimpleXmlReader(factory, getRequiredEntryContent(styleXml))) {
AtomicBoolean insideCellXfs = new AtomicBoolean(false);
while (reader.goTo(() -> reader.isStartElement("numFmt") ||
reader.isStartElement("cellXfs") || reader.isEndElement("cellXfs") ||
insideCellXfs.get())) {
if (reader.isStartElement("cellXfs")) {
insideCellXfs.set(true);
} else if (reader.isEndElement("cellXfs")) {
insideCellXfs.set(false);
}
if ("numFmt".equals(reader.getLocalName())) {
String formatCode = reader.getAttributeRequired("formatCode");
fmtIdToFmtString.put(reader.getAttributeRequired("numFmtId"), formatCode);
} else if (insideCellXfs.get() && reader.isStartElement("xf")) {
String numFmtId = reader.getAttribute ("numFmtId");
fmtIdList.add(numFmtId);
if (IMPLICIT_NUM_FMTS.containsKey(numFmtId)) {
fmtIdToFmtString.put(numFmtId, IMPLICIT_NUM_FMTS.get(numFmtId));
}
}
}
}
return fmtIdList;
}
private InputStream getRequiredEntryContent(String name) throws IOException {
return Optional.ofNullable(getEntryContent(name))
.orElseThrow(() -> new ExcelReaderException(name + " not found"));
}
static OPCPackage open(File inputFile) throws IOException {
return open(inputFile, false);
}
static OPCPackage open(File inputFile, boolean withFormat) throws IOException {
return new OPCPackage(inputFile, withFormat);
}
static OPCPackage open(InputStream inputStream) throws IOException {
return open(inputStream, false);
}
static OPCPackage open(InputStream inputStream, boolean withFormat) throws IOException {
byte[] compressedBytes = IOUtils.toByteArray(inputStream);
return new OPCPackage(new SeekableInMemoryByteChannel(compressedBytes), withFormat);
}
InputStream getSharedStrings() throws IOException {
return getEntryContent(parts.sharedStrings);
}
private InputStream getEntryContent(String name) throws IOException {
if (name == null) {
return null;
}
if (name.startsWith("/")) {
name = name.substring(1);
}
ZipArchiveEntry entry = zip.getEntry(name);
if (entry == null) {
// to be case insensitive
Enumeration entries = zip.getEntries();
while (entries.hasMoreElements()) {
ZipArchiveEntry e = entries.nextElement();
if (e.getName().equalsIgnoreCase(name)) {
return zip.getInputStream(e);
}
}
return null;
}
return zip.getInputStream(entry);
}
@Override
public void close() throws IOException {
zip.close();
}
public InputStream getWorkbookContent() throws IOException {
return getRequiredEntryContent(parts.workbook);
}
public InputStream getSheetContent(Sheet sheet) throws IOException {
String name = this.workbookPartsById.get(sheet.getId());
if (name == null) {
String msg = format("Sheet#%s '%s' is missing an entry in workbook rels (for id: '%s')",
sheet.getIndex(), sheet.getName(), sheet.getId());
throw new ExcelReaderException(msg);
}
return getRequiredEntryContent(name);
}
public List getFormatList() {
return formatIdList;
}
public Map getFmtIdToFmtString() {
return fmtIdToFmtString;
}
private static class PartEntryNames {
public static final String WORKBOOK_MAIN_CONTENT_TYPE =
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml";
public static final String WORKBOOK_EXCEL_MACRO_ENABLED_MAIN_CONTENT_TYPE =
"application/vnd.ms-excel.sheet.macroEnabled.main+xml";
public static final String SHARED_STRINGS_CONTENT_TYPE =
"application/vnd.openxmlformats-officedocument.spreadsheetml.sharedStrings+xml";
public static final String STYLE_CONTENT_TYPE =
"application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml";
String workbook;
String sharedStrings;
String style;
boolean isFullyFilled() {
return workbook != null && sharedStrings != null && style != null;
}
}
}
