opx-plus 0.1.1

Adds additional functionality on top of OpenPyXL

Introduction

OPX_Plus (OpenPyXL Plus) is an extension to OpenPyXL, a module for reading and writing .xlsx and similar files. OPX_Plus adds functions centred around creating regular reports based on a template file. You can log issues on the GitHub page.

Has the Following Dependencies

import openpyxl, glob, webbrowser, warnings, csv, datetime, os, time
from copy import copy
from openpyxl.formula.translate import Translator

Additional Functions

Files

get_file_path(file_path, name_search, *if_missing_urls)
check_mandatory_files(f_list)

0pen_template(template_path: object, *date_cells: str)
open_vals_only_sheet(from_wb_path, sheet_id=0)

save_file(new_file_location, file_name, workbook, afterdatetext="", previousday=False)
remove(file_path)

Move Data

paste_sheet_to_sheet(from_ws, to_ws, cell_range)
paste_csv_vals_to_sheet(csv_path, to_sheet, include_header=False)

copy_over_and_down_formulas(from_ws, to_ws, formula_cells)
paste_cells_to_cells(from_ws, to_ws, from_cell_range, offset=(0, 0))

Sub-Functions

count_rows(worksheet)
num_to_excel_col(n)
excel_col_to_num(a)

to_unix_time(year=datetime.datetime.now().year, month=datetime.datetime.now().month,
                 day=datetime.datetime.now().day, hour=datetime.datetime.now().hour,
                 minute=datetime.datetime.now().minute, second=datetime.datetime.now().second, add_3_zeros=False,
                 subtract=datetime.timedelta(0))
date_ranger()
worksheet_reset(sheet_nam, wb)