the problem is as the title states. I have a column AX filled with values. The name of the column is “Remarks” and it will contain remarks but some of those remarks are dates and some are full blown notes like “Person A owes Person B X amount.”

the problem is as the title states. I have a column AX filled with values. The name of the column is “Remarks” and it will contain remarks but some of those remarks are dates and some are full blown notes like “Person A owes Person B X amount.”

I’m not able to open or call the current active workbook using xlwings.
I’m on macOS Sonoma 14.5 and xlwings v0.31.10.

I have a use case where I want to automate and interface an Excel model from The workflow would be something like:

I am trying to figure out how to pass several selected cells into python via xlwings. I found code that passes cell notation but not all of the values.

import os
import datetime
import xlwings as xw
from google.cloud import bigquery

import os
import datetime
import xlwings as xw
from google.cloud import bigquery

I’m trying to use the xlwings add-in to run Python modules from excel. I’m starting with this basic Python script, named xlwings_test.py: