import pyautogui
import keyboard
import pandas as pd
import pyperclip
import time
import sys
def on_hotkey_triggered():
try:
print("Ctrl + D detected. Processing clipboard data...")
# Small delay to allow any UI changes to settle
time.sleep(0.5)
# Get clipboard content
clipboard_data = pyperclip.paste()
if not clipboard_data:
print("Clipboard is empty. Please copy the Excel table first.")
return
# Attempt to read the clipboard as a DataFrame
try:
df = pd.read_clipboard(sep=None) # Let pandas infer the separator
except Exception as e:
print("Failed to parse clipboard data as a table. Ensure it's copied from Excel.")
print(f"Error: {e}")
return
if df.empty:
print("The clipboard does not contain any data.")
return
print(f"Table detected with {len(df)} rows and {len(df.columns)} columns.")
# Iterate through each cell in row-major order
for row_idx, row in df.iterrows():
for col_idx, cell in enumerate(row😞
cell_text = str(cell)
# Type the cell content
pyautogui.typewrite(cell_text, interval=0.05) # Adjust interval as needed
# Press Tab to move to the next cell
pyautogui.press('tab')
# Optional: You can add a small delay if needed
# time.sleep(0.01)
print("Table input completed successfully.")
except Exception as e:
print("An unexpected error occurred:")
print(e)
def main():
print("AutoCAD Property Lookup Table Automation Script")
print("Press Ctrl + D to paste the clipboard table into AutoCAD.")
print("Press Esc to exit.")
# Register the hotkey Ctrl + D
keyboard.add_hotkey('ctrl+d', on_hotkey_triggered)
# Wait until the user decides to exit
keyboard.wait('esc')
print("Exiting the script.")
sys.exit()
if __name__ == "__main__":
main()
