All Questions
7 questions
0
votes
1
answer
647
views
Why does changing the value of streamlit selectbox cause the entire page to refresh each time?
I'm building a Streamlit app to analyze Excel files. In the app, I have a selectbox where users can choose a column from the uploaded Excel file. However, each time I change the value of the selectbox ...
- 118
0
votes
0
answers
81
views
excel sheet automation that contains a dependent dropdown list using python(If possible Pandas otherwise any lib is ok)
An excel workbook in XSLB format named "master excel" that contains many worksheet like "master sheet ","sheet1","sheet2" etc. "Master sheet" contains ...
0
votes
0
answers
397
views
OpenPyXL: Data Validation - Dependent Drop Down List
I managed to create a drop down list:
from openpyxl import Workbook
from openpyxl.worksheet.datavalidation import DataValidation
wb = Workbook()
ws = wb.active
dv = DataValidation(type="list&...
- 181
0
votes
0
answers
153
views
How to import specific cell values from excel by giving input from tkinter dropdown?
from tkinter import *
from tkinter import ttk
import openpyxl
from openpyxl import load_workbook
win=Tk()
BLOCK_NAME=StringVar()
VILLAGE_NA=StringVar()
head=StringVar()
# Load the xlsx file, then ...
- 49
0
votes
1
answer
1k
views
Export a dataframe into a xlsx-file with a dropdown column
I would like to export a Dataframe into a xlsx-file and have one of the column as a dropdown column
4
votes
1
answer
5k
views
Python Dash application with drop down menu that selects excel file sheets and displays in a table
I am in the process of learning Dash with the final goal being the development of an app that allows quick analysis of data sets in an excel file. I'd like a drop down menu that will allow for ...
- 103
1
vote
1
answer
4k
views
Can't get Excel drop-down list (combobox) value with python
I have an excel file with a drop-down list and I would like to access its current value from python.
In vba the code is really simple :
Sheets("name_of_my_sheet").name_of_my_list.value
I looked for ...
- 231