org.sejda.impl.sambox.PdfToExcelTask Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of sejda-sambox Show documentation
Show all versions of sejda-sambox Show documentation
Package containing tasks implemented using sambox.
/*
* Copyright 2016 by Eduard Weissmann ([email protected]).
*
* This file is part of the Sejda source code
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as
* published by the Free Software Foundation, either version 3 of the
* License, or (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see {
private static final Logger LOG = LoggerFactory.getLogger(PdfToExcelTask.class);
private PDDocumentHandler sourceDocumentHandler = null;
private PDDocumentHandler destinationDocument = null;
private MultipleOutputWriter outputWriter;
private PdfSourceOpener documentLoader;
@Override
public void before(PdfToExcelParameters parameters, TaskExecutionContext executionContext) throws TaskException {
super.before(parameters, executionContext);
documentLoader = new DefaultPdfSourceOpener();
outputWriter = OutputWriters.newMultipleOutputWriter(parameters.getExistingOutputPolicy(), executionContext);
}
@Override
public void execute(PdfToExcelParameters parameters) throws TaskException {
int currentStep = 0;
int totalSteps = parameters.getSourceList().size();
for (PdfSource source : parameters.getSourceList()) {
executionContext().assertTaskNotCancelled();
currentStep++;
LOG.debug("Opening {}", source);
sourceDocumentHandler = source.open(documentLoader);
File tmpFile = createTemporaryBuffer(".xlsx");
LOG.debug("Created output temporary buffer {}", tmpFile);
this.destinationDocument = new PDDocumentHandler();
destinationDocument.setVersionOnPDDocument(parameters.getVersion());
destinationDocument.initialiseBasedOn(sourceDocumentHandler.getUnderlyingPDDocument());
destinationDocument.setCompress(parameters.isCompress());
int numberOfPages = sourceDocumentHandler.getNumberOfPages();
List all = new ArrayList<>();
for (int pageNumber = 1; pageNumber <= numberOfPages; pageNumber++) {
DataTable dataTable = new DataTable(pageNumber);
LOG.debug("Extracting tables from page {}", pageNumber);
long start = System.currentTimeMillis();
PDPage page = sourceDocumentHandler.getPage(pageNumber);
for (Table table : parameters.getTables(pageNumber)) {
List cellAreas = new ArrayList<>();
for (TopLeftRectangularBox row : table.getRows()) {
for (TopLeftRectangularBox column : table.getColumns()) {
TopLeftRectangularBox cell = row.intersection(column);
if (!cell.asRectangle().isEmpty()) {
cellAreas.add(cell.withPadding(1).asRectangle());
} else {
LOG.warn("Column and row do not intersect: row: " + row.toString() + ", column: "
+ column.toString());
cellAreas.add(new Rectangle(0, 0, 0, 0));
}
}
}
LOG.debug("Extracting text for {} table cells", cellAreas.size());
long startTimingCells = System.currentTimeMillis();
List cellValues = new PdfTextExtractorByArea().extractTextFromAreas(page, cellAreas);
LOG.debug("Text extraction took {} seconds",
(System.currentTimeMillis() - startTimingCells) / 1000);
int i = 0;
ArrayList rowData = new ArrayList<>();
for (TopLeftRectangularBox row : table.getRows()) {
for (TopLeftRectangularBox column : table.getColumns()) {
rowData.add(cellValues.get(i));
i++;
}
dataTable.addRow(rowData);
rowData = new ArrayList<>();
}
all.add(dataTable);
}
LOG.debug("Done extracting tables from page {}, took {} seconds", pageNumber,
(System.currentTimeMillis() - start) / 1000);
}
if (parameters.isMergeTablesSpanningMultiplePages()) {
all = mergeTablesSpanningMultiplePages(all);
}
writeExcelFile(all, tmpFile);
String outName = nameGenerator(parameters.getOutputPrefix())
.generate(nameRequest("xlsx").originalName(source.getName()).fileNumber(currentStep));
outputWriter.addOutput(file(tmpFile).name(outName));
notifyEvent(executionContext().notifiableTaskMetadata()).stepsCompleted(currentStep).outOf(totalSteps);
nullSafeCloseQuietly(sourceDocumentHandler);
}
parameters.getOutput().accept(outputWriter);
LOG.debug("Input documents cropped and written to {}", parameters.getOutput());
}
private List mergeTablesSpanningMultiplePages(List dataTables) {
List results = new ArrayList<>();
DataTable current = null;
for (DataTable dt : dataTables) {
if (current != null) {
if (current.hasSameColumnsAs(dt)) {
current = current.mergeWith(dt);
} else {
results.add(current);
current = dt;
}
} else {
current = dt;
}
}
if (current != null) {
results.add(current);
}
return results;
}
private void writeExcelFile(List dataTables, File tmpFile) throws TaskException {
LOG.debug("Writing data to excel file");
long start = System.currentTimeMillis();
Workbook wb = new XSSFWorkbook();
try (FileOutputStream fileOut = new FileOutputStream(tmpFile)) {
for (int t = 0; t < dataTables.size(); t++) {
LOG.debug("Writing data table " + t);
DataTable dataTable = dataTables.get(t);
List> data = dataTable.getData();
Sheet sheet = wb.createSheet(String.format("Table %d (%s)", t + 1, dataTable.getPagesAsString()));
for (int r = 0; r < data.size(); r++) {
List dataRow = data.get(r);
LOG.debug("Writing row " + r + " of " + dataRow.size() + " values");
Row row = sheet.createRow(r);
for (int i = 0; i < dataRow.size(); i++) {
String stringValue = dataRow.get(i);
row.createCell(i).setCellValue(stringValue);
}
}
for (int c = 0; c < sheet.getRow(0).getPhysicalNumberOfCells(); c++) {
sheet.autoSizeColumn(c);
}
}
wb.write(fileOut);
LOG.debug("Done writing data to excel file, took {} seconds", (System.currentTimeMillis() - start) / 1000);
} catch (IOException ioe) {
throw new TaskException("Could not save .xlsx file", ioe);
}
}
@Override
public void after() {
nullSafeCloseQuietly(sourceDocumentHandler);
nullSafeCloseQuietly(destinationDocument);
}
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy