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)...