How to get Excel active sheet name in Python/Pandas?

Question

I'm processing Excel file with multiple sheets via Pandas (read_excel) and need to get the name of the active sheet. Active sheet contains most recent data and the name convention is subject to "creator's mood". So I cannot use simple reading a sheet by name or index... Is there a way how to do it?

UPDATE (solution): Except xlrd with sheet_visible property proposed in Eswar's link (thank you) I discovered another solution with usage of xlwings library:

import xlwings as xw
wb = xw.Book('myfile.xls')
active_sheet_name = wb.sheets.active.name

=> Python is almighty...in many ways ;)

May be the trick lies in getting to know in which sheet the active cell is? So,, probably a brute for method......read all the sheets and look for the active cell. That should be your active sheet. — Eswar
– Eswar, Commented Oct 1, 2018 at 11:18
stackoverflow.com/a/47558794/5658251 should help you solve the same.... — Eswar
– Eswar, Commented Oct 1, 2018 at 11:20

Radu · Accepted Answer · 2018-10-01 11:06:40Z

2

The only solution I see is this:

import pandas as pd

active_sheet = input("Enter the required sheet: ")
df = pd.read_excel(file_with_data, sheet_name = active_sheet)
...

You open the .xlsx file, see what the creator's mood was on that day and how he named the sheet that you need, then simply enter it's name when prompted.

Hope it helps.

answered Oct 1, 2018 at 11:06

Radu

357 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to get Excel active sheet name in Python/Pandas?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related