The non-profit I work for is a free clinic and we use an electronic medical record program. One of the features is to upload documents, however, the primary format is HTML. I have created an excel file of the document and saved it as an html. I then opened it and viewed source code. But when I...
Hi everyone,
I defined
a ActiveX ComboBox named "cmbPeymankar",
a Text Box (ActiveX control) called "txtNewPeymankar".
a Command Button (ActiveX control) called "Add".
I have a table named "Table1" in sheet "DATA" so that the first column of Table1 contains the names that should be displayed...
Hi All,
I have
2 -> .XLS files (with header),
1 -> .XLSX file and
1 -> .XLSX file (password protected)
I have to read these files optimally and create respective .CSV files
- What would be the best optimized approach?
- What are the necessary libraries required? Can one library solve this...
I am new to VBA and this is the first Macro I've tried to write. I have an excel table which has five columns titled Address, location , works , action and completed. I want to create a new worksheet for each unique address and then copy the relevant rows for that address on that new worksheet...
How do I make this script ignore certain words when renaming files? Please help!
---
import pandas as pd
import os
from pathlib import Path as path
df = pd.read_excel("KODAIX.xlsx")
df = df.set_index('code')
folder = path(r'C:\Users\X\PycharmProjects\pythonProject3\MOZAIKX')
for file...
Dear bros (and hoes),
I’m a 25 y.o virgin looking to be pointed in the right direction :notworthy:
My personal development goal is to learn how to create the following:
Cloud-based web application
User-friendly interface
Purpose built application for financial analysis
Replicates what Excel...
i need help with my data scraper it gets all the data and writes it to an excel sheet , but whenever i want to run it again it replaces the old data and id like it to be wrote a few coloums to the right instead without replacing all data can anyone help with this please?(i run this in pycharm)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.