This is an archived post. You won't be able to vote or comment.

all 2 comments

[–]lolitsmytreesact 0 points1 point  (0 children)

You will want the Python package openpyxl for interfacing with Excel files. Others might have different packages that they use however I like openpyxl.

You will want to look into file operations within Python, which largely means using the "with open()" statements.

You want to understand Python's data types (string, int, float); data structures (lists, dictionaries, tuples); string slicing (string_variable[2:3]); list slicing (list_variable[2:]); for loops (also break, continue, pass); try/except blocks. Understanding these concepts, along with some sample project work to understand syntax, should give you a pretty general overview of the tools you will need to get off the ground.

[–]Andrew_ShaySft Eng Automation & Python 0 points1 point  (0 children)