
Research
Security News
The Growing Risk of Malicious Browser Extensions
Socket researchers uncover how browser extensions in trusted stores are used to hijack sessions, redirect traffic, and manipulate user behavior.
Really lightweight lib for peeking into xlsx column/row size before you try to open the file with something else
Really lightweight lib for peeking into xlsx column/row size before you try to open the file with something else
pip install xlsxmetadata
from xlsxmetadata.metadata import get_dimensions, get_sheet_names
my_big_file = '/path/to/my/real_big_file.xlsx'
sheet_names = get_sheet_names(my_big_file)
print(sheet_names)
>>> {'test_sheet': 1}
dimensions = get_dimensions('/path/to/my/real_big_workbook.xlsx', 'test_sheet')
print(dimensions['end_column'])
>>> 16834
print(dimensions['end_row'])
>>> 1200000
from io import BytesIO
from xlsxmetadata.metadata import get_dimensions, get_sheet_names
my_big_file = request.files.get('my_big_file')
sheet_names = get_sheet_names(BytesIO(my_big_file.read()))
print(sheet_names)
>>> {'test_sheet': 1}
# you will probably have to reset the read-head
my_big_file.seek(0)
dimensions = get_dimensions(BytesIO(my_big_file.read()), 'test_sheet')
print(dimensions['end_column'])
>>> 16834
print(dimensions['end_row'])
>>> 1200000
This information is stored as metadata in the first few bytes of .xlsx
files. For some reason no other libraries (xlrd, openpyxl) seem to give the users access to this data directly.
FAQs
Really lightweight lib for peeking into xlsx column/row size before you try to open the file with something else
We found that xlsxmetadata 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.
Research
Security News
Socket researchers uncover how browser extensions in trusted stores are used to hijack sessions, redirect traffic, and manipulate user behavior.
Research
Security News
An in-depth analysis of credential stealers, crypto drainers, cryptojackers, and clipboard hijackers abusing open source package registries to compromise Web3 development environments.
Security News
pnpm 10.12.1 introduces a global virtual store for faster installs and new options for managing dependencies with version catalogs.