officeParser
A Node.js library to parse text out of any office file.
Supported File Types
Update
- 2024/11/12 - Added ArrayBuffer as a type of file input. Generating bundle files now which exposes namespace officeParser to be able to access parseOffice and parseOfficeAsync directly on the browser. Extracting text out of pdf files does not work currently in browser bundles.
- 2024/10/21 - Replaced extracting zip files from decompress to yauzl. This means that we now extract files in memory and we no longer need to write them to disk. Removed config flags related to extracted files. Added flags for CLI execution.
- 2024/10/15 - Fixed erroring out while deleting temp files when multiple worker threads make parallel executions resulting in same file name for multiple files. Fixed erroring out when multiple executions are made without waiting for the previous execution to finish which resulted in deleting the file from other execution. Upgraded dependencies.
- 2024/10/13 - Fixed parsing text from xlsx files which contain no shared strings file and files which have inlineStr based strings.
- 2024/05/06 - Replaced pdf parsing support from pdf-parse library to natively building it using pdf.js library from Mozilla by analyzing its output. Added pdfjs-dist build as a local library.
- 2023/11/25 - Fixed error catching when an error occurs within the parsing of a file, especially after decompressing it. Also fixed the problem with parallel parsing of files as we were using only timestamp in file names.
- 2023/10/24 - Revamped content parsing code. Fixed order of content in files, especially in word files where table information would always land up at the end of the text. Added config object as argument for parseOffice which can be used to set new line delimiter and multiple other configurations. Added support for parsing pdf files using the popular npm library pdf-parse. Removed support for individual file parsing functions.
- 2023/04/26 - Added support for file buffers as argument for filepath for parseOffice and parseOfficeAsync
- 2023/04/07 - Added typings to methods to help with Typescript projects.
- 2022/12/28 - Added command line method to use officeParser with or without installing it and instantly get parsed content on the console.
- 2022/12/10 - Fixed memory leak issues, bugs related to parsing open document files and improved error handling.
- 2021/11/21 - Added promise way to existing callback functions.
- 2020/06/01 - Added error handling and console.log enable/disable methods. Default is set at enabled. Everything backward compatible.
- 2019/06/17 - Added method to change location for decompressing office files in places with restricted write access.
- 2019/04/30 - Removed case sensitive file extension bug. File names with capital lettered extensions now supported.
- 2019/04/23 - Added support for open office files *.odt, *.odp, *.ods through parseOffice function. Created a new method parseOpenOffice for those who prefer targetted functions.
- 2019/04/23 - Added feature to delete the generated dist folder after function callback.
- 2019/04/22 - Added parseOffice method to avoid confusion between type of file and their extension.
- 2019/04/22 - Added file extension validations. Removed errors for excel files with no drawing elements.
- 2019/04/19 - Support added for *.xlsx files.
- 2019/04/18 - Support added for *.pptx files.
Install via npm
npm i officeparser
Command Line usage
If you want to call the installed officeParser.js file, use below command
node <path/to/officeParser.js> [--configOption=value] [FILE_PATH]
node officeparser [--configOption=value] [FILE_PATH]
Otherwise, you can simply use npx without installing the node module to instantly extract parsed data.
npx officeparser [--configOption=value] [FILE_PATH]
Config Options:
--ignoreNotes=[true|false]
Flag to ignore notes from files like PowerPoint. Default is false.--newlineDelimiter=[delimiter]
The delimiter to use for new lines. Default is \n
.--putNotesAtLast=[true|false]
Flag to collect notes at the end of files like PowerPoint. Default is false.--outputErrorToConsole=[true|false]
Flag to output errors to the console. Default is false.
Library Usage
const officeParser = require('officeparser');
officeParser.parseOffice("/path/to/officeFile", function(data, err) {
if (err) {
console.log(err);
return;
}
console.log(data);
})
officeParser.parseOfficeAsync("/path/to/officeFile");
.then(data => console.log(data))
.catch(err => console.error(err))
try {
const data = await officeParser.parseOfficeAsync("/path/to/officeFile");
console.log(data);
} catch (err) {
console.log(err);
}
const fileBuffers = fs.readFileSync("/path/to/officeFile");
officeParser.parseOfficeAsync(fileBuffers);
.then(data => console.log(data))
.catch(err => console.error(err))
Configuration Object: OfficeParserConfig
Optionally add a config object as 3rd variable to parseOffice for the following configurations
Flag | DataType | Default | Explanation |
---|
outputErrorToConsole | boolean | false | Flag to show all the logs to console in case of an error. Default is false. |
newlineDelimiter | string | \n | The delimiter used for every new line in places that allow multiline text like word. Default is \n. |
ignoreNotes | boolean | false | Flag to ignore notes from parsing in files like powerpoint. Default is false. It includes notes in the parsed text by default. |
putNotesAtLast | boolean | false | Flag, if set to true, will collectively put all the parsed text from notes at last in files like powerpoint. Default is false. It puts each notes right after its main slide content. If ignoreNotes is set to true, this flag is also ignored. |
const config = {
newlineDelimiter: " ",
ignoreNotes: true
}
officeParser.parseOffice("/path/to/officeFile", function(data, err){
if (err) {
console.log(err);
return;
}
console.log(data);
}, config)
officeParser.parseOfficeAsync("/path/to/officeFile", config);
.then(data => console.log(data))
.catch(err => console.error(err))
Example - JavaScript
const officeParser = require('officeparser');
const config = {
newlineDelimiter: " ",
ignoreNotes: true
}
officeParser.parseOfficeAsync("/Users/harsh/Desktop/files/mySlides.pptx", config);
.then(data => {
const newText = data + " look, I can parse a powerpoint file";
callSomeOtherFunction(newText);
})
.catch(err => console.error(err));
function searchForTermInOfficeFile(searchterm, filepath) {
return officeParser.parseOfficeAsync(filepath)
.then(data => data.indexOf(searchterm) != -1)
}
Example - TypeScript
import { OfficeParserConfig, parseOfficeAsync } from 'officeparser';
const config: OfficeParserConfig = {
newlineDelimiter: " ",
ignoreNotes: true
}
parseOfficeAsync("/Users/harsh/Desktop/files/mySlides.pptx", config);
.then(data => {
const newText = data + " look, I can parse a powerpoint file";
callSomeOtherFunction(newText);
})
.catch(err => console.error(err));
function searchForTermInOfficeFile(searchterm: string, filepath: string): Promise<boolean> {
return parseOfficeAsync(filepath)
.then(data => data.indexOf(searchterm) != -1)
}
Please take note: I have breached convention in placing err as second argument in my callback but please understand that I had to do it to not break other people's existing modules.
Browser Usage
Download the bundle file available as part of the release asset.
Include this bundle file in your browser html file and access parseOffice
and parseOfficeAsync
under the officeParser
namespace.
Example
<head>
...
<script src="officeParserBundle@5.1.0.js"></script>
</head>
<body>
...
<input type="file" id="fileInput" />
...
<script>
document.getElementById('fileInput').addEventListener('change', async function(event) {
const outputDiv = document.getElementById('output');
const file = event.target.files[0];
try {
const config = {
outputErrorToConsole: false,
newlineDelimiter: '\n',
ignoreNotes: false,
putNotesAtLast: false
};
const arrayBuffer = await file.arrayBuffer();
const result = await officeParser.parseOfficeAsync(arrayBuffer, config);
}
catch (error) {
}
});
</script>
</body>
Known Bugs
- Inconsistency and incorrectness in the positioning of footnotes and endnotes in .docx files where the footnotes and endnotes would end up at the end of the parsed text whereas it would be positioned exactly after the referenced word in .odt files.
- The charts and objects information of .odt files are not accurate and may end up showing a few NaN in some cases.
- Extracting texts in browser bundles does not work for pdf files.
npm
https://npmjs.com/package/officeparser
github
https://github.com/harshankur/officeParser