
Security News
Node.js Moves Toward Stable TypeScript Support with Amaro 1.0
Amaro 1.0 lays the groundwork for stable TypeScript support in Node.js, bringing official .ts loading closer to reality.
xlsxparse is a Python command-line application that extracts cell references from an Excel file and outputs their locations to a JSON file. The tool provides two main commands:
create
: Parses an Excel (.xlsx
) file for references and exports them to a JSON file.search
: Searches the generated JSON file for specific references.You can install xlsxparse via pip:
pip install xlsxparse-joeypas
Ensure you have Python 3.8+ installed.
Extracts references from an Excel file and saves them to a JSON file.
xlsxparse create <xlsx_file> [--sheet <sheet_name>] --output <json_file>
<xlsx_file>
: Path to the Excel file.--sheet <sheet_name>
(optional): Name of the specific sheet to parse. If omitted, all sheets are parsed.--output <json_file>
: (optional): Path to save the extracted references in JSON format.xlsxparse create data.xlsx --sheet Sheet1 --output refs.json
Searches the JSON file for specific references.
xlsxparse search [OPTIONS] STRING [FILE]
STRING
(required): String to search for.FILE
(optional): Path to the file. Defaults to output.json
.--stype [metric|sheet-metric|ref-file|ref-file-sheet]
(default: metric
): Search type.--help
: Show help message and exit.xlsxparse search "Book2.xlsx, Sheet2" refs.json --stype ref-file-sheet
The output JSON file follows this structure:
[
{
"Sheet": "Sheet1",
"Metric": [
"Test",
"Three"
],
"Cell": "B4",
"Formula": "=B2+B3",
"References": [
{
"sheet": "Sheet1",
"cell": "B2"
},
{
"sheet": "Sheet1",
"cell": "B3"
}
]
},
{
"Sheet": "Sheet2",
"Metric": [
null,
null
],
"Cell": "A2",
"Formula": "=SUM(30,[1]Sheet1!D12)",
"References": [
{
"file": "Book2.xlsx",
"sheet": "Sheet1",
"cell": "D12"
}
]
}
]
feature-branch
).This project is licensed under the MIT License.
FAQs
A .xlsx parser
We found that xlsxparse-joeypas demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
Amaro 1.0 lays the groundwork for stable TypeScript support in Node.js, bringing official .ts loading closer to reality.
Research
A deceptive PyPI package posing as an Instagram growth tool collects user credentials and sends them to third-party bot services.
Product
Socket now supports pylock.toml, enabling secure, reproducible Python builds with advanced scanning and full alignment with PEP 751's new standard.