generated from ual-alpa-ssc/catapult
-
Notifications
You must be signed in to change notification settings - Fork 0
A fast python CLI tool to strip empty rows from Excel workbooks
License
NickFabry/xl_strip_null_rows
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
xl_strip_null_rows is designed to solve a specific problem - Excel sheets with a huge number of blank rows after the real data, often up to the maximum allowable number of rows, 1,048,576. Stripping out these empty rows in Excel is often difficult or impossible because of the massive size in memory such an Excel file takes, slowing manipulations to a crawl. This program aims to do that, stripping out blank rows in a much more efficient fashion, approximately 100x as fast as in Excel. The algorthim used is limited. It iterates over all the Worksheets in the Workbook. In each Worksheet, it reads each cell in the first column sequentially from top to bottom. When it finds the FIRST blank/null cell, it then copies the all the rows above that blank/null cell, and puts them in a brand-new Workbook and identically named Worksheet. Note that all formatting, formulas, charts, etc. are not preserved in the copy; only the values. Note also that a stray blank row will cause the program to ignore all the rows (even if non-blank) below it. It also makes no attempt to strip away or detect empty columns. In the future, we may add additional options for these use cases.
About
A fast python CLI tool to strip empty rows from Excel workbooks
Resources
License
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published