Das deutsche Python-Forum

Code: Alles auswählen

import pandas as pd

input_file = "C:\\Users\\colling\\Desktop\\DM-Dateiimport\\Dateiimport - Vollversion\\input\\Auftragsstellen.xlsx"

process_dict = {}
process_name = "Niederlassungen.xlsx"
sheet = 'Tabelle4'
xls = pd.ExcelFile(input_file)
if process_name not in process_dict:
    process_dict[process_name] = {}
for sheet_name in xls.sheet_names:
    df = pd.DataFrame(pd.read_excel(input_file, sheet_name=sheet_name))
    process_dict[process_name][sheet_name] = xls.parse(sheet_name)
for key, value in process_dict.items():
    print(key)
    for tabelle, zeilen  in value.items():
        if tabelle== sheet:
            print(tabelle)
            print(zeilen )


HIER DIE AUSGABE DES PRINT-BEFEHLS:

Auftragsstellen.xlsx
Tabelle3
  Spalte11:TEXT Spalte12:TEXT       ...        Spalte14:TEXT Spalte15:INTEGER
0             k             l       ...                    n        123456789

[1 rows x 5 columns]
Tabelle4
  Spalte16:TEXT Spalte17:TEXT
0             p             q
1             r             s
2             T             u
3             v             w
4             x             y
5             z            aa
---

Code: Alles auswählen

Auftragsstellen.xlsx Tabelle4 3

Code: Alles auswählen

#!/usr/bin/env python3
from pathlib import Path

import pandas as pd


def main():
    input_filename = (
        Path("C:")
        / "Users"
        / "colling"
        / "Desktop"
        / "DM-Dateiimport"
        / "Dateiimport - Vollversion"
        / "input"
        / "Auftragsstellen.xlsx"
    )

    process_name = "Niederlassungen.xlsx"
    wanted_sheet_name = "Tabelle4"
    process_name_to_sheets = {}

    process_name_to_sheets[process_name] = pd.read_excel(
        input_filename, sheet=None
    )

    for process_name, sheet_name_to_sheet in process_name_to_sheets.items():
        print(process_name)
        sheet = sheet_name_to_sheet.get(wanted_sheet_name)
        if sheet:
            print(wanted_sheet_name)
            print(sheet)


if __name__ == "__main__":
    main()