Hi guys, I’m trying to deploy my app, and in the app I need to update financial data when user open the app, my sollution was use win32.client, I understand that streamlit cloud uses Linux machine. So I want to know options for this situation.
My code that I’m using is:
# Importing the pywin32 module
# Opening Excel software using the win32com
File = win32com.client.Dispatch("Excel.Application")
# Optional line to show the Excel software
#File.Visible = 1
# Opening your workbook
Workbook = File.Workbooks.open(r"<path>\<file>.xlsx")
# Refeshing all the shests
# Saving the Workbook
# Closing the Excel File
There are other ways to manipulate Excel files that are platform-independent like using these modules, pandas and openpyxl.
import pandas as pd
# Load workbook
data = pd.read_excel('<file>.xlsx')
# Update data (this would be your custom logic)
updated_data = data # apply your updates
# Save workbook
Let me know if this is helpful. Otherwise, please share more of your code so we can better help you troubleshoot the issue.
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.
Hello there 👋🏻
Strictly necessary cookies
These cookies are necessary for the website to function and cannot be switched off. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us understand how visitors move around the site and which pages are most frequently visited.
These cookies are used to record your choices and settings, maintain your preferences over time and recognize you when you return to our website. These cookies help us to personalize our content for you and remember your preferences.
These cookies may be deployed to our site by our advertising partners to build a profile of your interest and provide you with content that is relevant to you, including showing you relevant ads on other websites.