Metadata-Version: 2.1 Name: Excelutilities Version: 0.0.9 Summary: Useful functions for writing code for Excel applications Home-page: https://github.com/EthanTheMathmo/excel-utilities/ Author: Ethan Horsfall Author-email: ethan.horsfall@gmail.com License: UNKNOWN Platform: UNKNOWN Classifier: Programming Language :: Python :: 3.8 Classifier: License :: OSI Approved :: GNU General Public License v3 (GPLv3) Description-Content-Type: text/markdown Requires-Dist: PySimpleGUI (>=4.0.0) Requires-Dist: xlwings (>=0.24.0) Requires-Dist: openpyxl (>=3.0.0) Requires-Dist: numpy (>=1.20.0) Requires-Dist: jellyfish (>=0.8.8) # excel-utilities Contains some functions we have found useful when using python with Excel. Note that we are experimenting with using it as a python package and is not fully debugged yet Currently: ## index_helpers Contains some useful functions for working with Excel notation and other helper functions for indices. This is the sheet of functions we've found we re-use most, and are currently adding to once or twice a week. ## attach_data A small function which allows you to select to columns, and a root file, and then attaches file locations as notes. ## worksheet_remove_data Is for removing data from a sheet and instead writing some summary data. The purpose of this is to remove sensitive information while keeping useful information for designing code and debuggong