semvec/pypi-packages huggingface dataset:
OPX-Plus 0.1.1
Adds additional functionality on top of OpenPyXL
Requires Python: >=3.8

## Introduction

OPX_Plus (OpenPyXL Plus) is an extension to [OpenPyXL](https://pypi.org/project/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](https://github.com/StevenWilson9/OPX_Plus/issues).

### 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)
```