[Python] Reading Excel data and named ranges into Python script

Discussão em 'Python' iniciado por Stack, Fevereiro 16, 2025.

  1. Stack

    Stack Membro Participativo

    I am new to Python but have used Excel and named ranges for some time. I have a football workbook, several worksheets, with several named ranges for team name, colors, plays, rules, formations, etc. The workbook is used to create a wristband for football players. I have userforms and sheet change code that handles various activities. I would like to create this in python and be able to send out to other coaches in an exe file. Some named ranges are 1 cell others are multiple columns and rows.
    For example a list of formations is 15 plus. Each play has up to 20 columns of rules for each player and data for the wristband. The 'playbook' as a whole could be several hundred plays potentially. That is a table. I am trying to better understand how to read in varying data into python, assign it to a variable, and then later write it back out to a data file tagged to the exe. I know, alot to ask Thanks

    In python, I am able to open windows and create buttons, textblocks, etc. I am able to convert a py file into exe. (Without a data file) Just trying to get to the next step in my mind

    Continue reading...

Compartilhe esta Página