Excel-report-evaluator - A simple Python GUI application to aid with bulk evaluation of Microsoft Excel reports.

Overview

Excel Report Evaluator

Simple Python GUI with Tkinter for evaluating Microsoft Excel reports (.xlsx-Files).

Usage

Start main.py and choose one of the example rules that are currently included via the dropdown at the top left corner.

Application started

The rules will be explained in more detail below. The default is looking for a red background in any Excel-cell.

Now click "Choose directory" and select a directory that contains .xlsx-files for evaluation.

Reports were added

All .xlsx-files will be added to the list. Click "Start evaluation" to process the reports. Depending on file size this may take a while.

Reports are processed

When the reports are processed the background color of the report in the list will change according to the selected ruleset. In the above example, test2 did not contain any cells with a red background, but test1 and test3 did. To see more details and extract the rows that contain the searched parameters, click on the report in the list.

Found lines are extracted and displayed

When a report is flagged according to the specified rules, the affected lines will be displayed on the right in the Text widget.

more example extracted lines

JSON rule description

The sample json file provided rules.json is an example for every possible rule currently implemented. The json file always needs to be named "rules.json" for now. Within the ruleset-list you can add, adjust or delete any of the components to your liking.

Every rule is required to have several parameters.

parameter purpose
col Column to use for evaluation. -1 means all columns will be evaluated.
compare The value that is being compared to the cell value within the Excel file. For Color this is an Excel-compatible Color Code, for values this is an alphanumeric value.
name The name of the rule that will be displayed in the GUI.
operator The operator that will be used when comparing the cell value with the compare-value. Currently supports ==, >=, <=, !=, <, > .
type The type of rule. See below for more information.

An example JSON-description of the rule looking for a red background within a cell would look like this:

    {
        "col": -1,
        "compare": "FFFF0000",
        "name": "RED BG",
        "operator": "==",
        "type": "BGCOLOR"
    }

If you wanted to modify this example to only look for a red background in column 7, it could look like this:

    {
        "col": 7,
        "compare": "FFFF0000",
        "name": "RED BG C7",
        "operator": "==",
        "type": "BGCOLOR"
    }

Rule Types

Rule Type description
BGCOLOR Looks for the background color of a cell.
FONTCOLOR Looks for the color of the font within a cell.
VALUE Looks to compare the cell value to the compare value based on the operator provided.
Owner
Alexander H.
Software Developer / System Integrator.
Alexander H.
Use a docx as a jinja2 template

python-docx-template Use a docx as a jinja2 template Introduction This package uses 2 major packages : python-docx for reading, writing and creating s

Eric Lapouyade 1.4k Dec 28, 2022
Please use openpyxl where you can...

xlrd xlrd is a library for reading data and formatting information from Excel files in the historical .xls format. Warning This library will no longer

2k Dec 29, 2022
xlwings is a BSD-licensed Python library that makes it easy to call Python from Excel and vice versa. It works with Microsoft Excel on Windows and macOS. Sign up for the newsletter or follow us on twitter via

xlwings - Make Excel fly with Python! xlwings CE xlwings CE is a BSD-licensed Python library that makes it easy to call Python from Excel and vice ver

xlwings 2.5k Jan 06, 2023
Single API for reading, manipulating and writing data in csv, ods, xls, xlsx and xlsm files

pyexcel - Let you focus on data, instead of file formats Support the project If your company has embedded pyexcel and its components into a revenue ge

1.1k Dec 29, 2022
Xiaobo Zhang 30 Jan 08, 2023
Reads Data from given Excel File and exports Single PDFs and a complete PDF grouped by Gateway

E-Shelter Excel2QR Reads Data from given Excel File and exports Single PDFs and a complete PDF grouped by Gateway Features Reads Excel 2021 Export Sin

Stefan Knaak 1 Nov 13, 2021
A set of Python scripts for finding threats in Office365

Py365 A collection of scripts for finding threats in Office365 Risky Rules A tool for finding risky or suspicious inbox rules - more detail in this po

Martin Rothe 49 May 18, 2022
xlwings is a BSD-licensed Python library that makes it easy to call Python from Excel and vice versa. It works with Microsoft Excel on Windows and macOS.

xlwings - Make Excel fly with Python! xlwings (Open Source) xlwings is a BSD-licensed Python library that makes it easy to call Python from Excel and

xlwings 2.5k Jan 06, 2023
A wrapper library to read, manipulate and write data in xlsx and xlsm format using openpyxl

pyexcel-xlsx - Let you focus on data, instead of xlsx format pyexcel-xlsx is a tiny wrapper library to read, manipulate and write data in xlsx and xls

110 Nov 16, 2022
According to the received excel file (.xlsx,.xlsm,.xltx,.xltm), it converts to word format with a given table structure and formatting

According to the received excel file (.xlsx,.xlsm,.xltx,.xltm), it converts to word format with a given table structure and formatting

Diakonov Andrey 2 Feb 18, 2022
A Python module for creating Excel XLSX files.

XlsxWriter XlsxWriter is a Python module for writing files in the Excel 2007+ XLSX file format. XlsxWriter can be used to write text, numbers, formula

John McNamara 3.1k Dec 29, 2022
Python Module for Tabular Datasets in XLS, CSV, JSON, YAML, &c.

Tablib: format-agnostic tabular dataset library _____ ______ ___________ ______ __ /_______ ____ /_ ___ /___(_)___ /_ _ __/_ __ `/__ _

Jazzband 4.2k Dec 30, 2022
PowerShell module to import/export Excel spreadsheets, without Excel

PowerShell + Excel = Better Together Automate Excel via PowerShell without having Excel installed. Runs on Windows, Linux and MAC. Creating Tables, Pi

Doug Finke 2k Dec 30, 2022
Excel-report-evaluator - A simple Python GUI application to aid with bulk evaluation of Microsoft Excel reports.

Excel Report Evaluator Simple Python GUI with Tkinter for evaluating Microsoft Excel reports (.xlsx-Files). Usage Start main.py and choose one of the

Alexander H. 1 Dec 29, 2021
ExcelPeek is a tool designed to help investigate potentially malicious Microsoft Excel files.

ExcelPeek is a tool designed to help investigate potentially malicious Microsoft Excel files.

James Slaughter 37 Apr 16, 2022
Library to create spreadsheet files compatible with MS Excel 97/2000/XP/2003 XLS files, on any platform.

xlwt This is a library for developers to use to generate spreadsheet files compatible with Microsoft Excel versions 95 to 2003. The package itself is

1k Dec 24, 2022
ObjTables: Tools for creating and reusing high-quality spreadsheets

ObjTables: Tools for creating and reusing high-quality spreadsheets ObjTables is a toolkit which makes it easy to use spreadsheets (e.g., XLSX workboo

Karr whole-cell modeling lab 7 Jun 14, 2021
Universal Office Converter - Convert between any document format supported by LibreOffice/OpenOffice.

Automated conversion and styling using LibreOffice Universal Office Converter (unoconv) is a command line tool to convert any document format that Lib

2.4k Jan 03, 2023
A suite of utilities for converting to and working with CSV, the king of tabular file formats.

csvkit is a suite of command-line tools for converting to and working with CSV, the king of tabular file formats. It is inspired by pdftk, GDAL and th

wireservice 5.2k Dec 31, 2022
Create Open XML PowerPoint documents in Python

python-pptx is a Python library for creating and updating PowerPoint (.pptx) files. A typical use would be generating a customized PowerPoint presenta

Steve Canny 1.7k Jan 05, 2023