Skip to content

A simple tool for grepping .xlsx files using only the Python standard library. Includes a Notepad++ UI.

License

Notifications You must be signed in to change notification settings

molsonkiko/excel_grepper_npp

Repository files navigation

Notepad++ Excel grepping tool

Tired of people responding Why would you use Notepad++ to view Excel files? They're binary! when you ask about using Notepad++ with Excel? Well, now you can (sort of) read Excel files in Notepad++!

The original version supported only choosing text patterns in Excel files, but now you can filter filename patterns and sheet names, and you can also list worksheets names in each file.

Note that this tool does not work with .xls files (super old Excel worksheets made more than a decade ago).

To use in Notepad++, you must have PythonScript 3.0.15 or higher installed, and add grep_in_excel.py to the plugins\PythonScript\scripts folder of your Notepad++ installation. You can then execute the plugin with Plugins->PythonScript->Scripts->grep_in_excel from the main menu.

The user interface is VERY SIMPLE (because I didn't feel like making something fancier).

There is also a CLI tool that just prints JSON to the terminal. It has the same options as the Notepad++ add-in shown below.

user interface of excel grepping tool example of results from successful grep

CHANGES

[0.2.0] (2023-02-07)

Added

  • Filename filtering (by glob)
  • sheet name filtering (by regex, case-insensitive only)
  • option to list sheets that match filename and sheet name filters
  • now automatically starts in directory of currently open file (in Notepad++) or current directory (in CLI)

Fixed

Previously, the sheet names given didn't match the names as they would appear in an Excel workbook (e.g., the first sheet was sheet1 even if it was actually named foo bar)

[0.1.0] (2023-02-04)

Basic functionality added. Only filter text, no filename or sheet name filtering, no option to list only sheet names.

About

A simple tool for grepping .xlsx files using only the Python standard library. Includes a Notepad++ UI.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages