7 ms·
> What I expected was a VBA editor for Python and maybe a library for Windows to access Excel objects from a Python script in a cmd or powershell prompt. This
by varunnrao 2y ago
> What I expected was a VBA editor for Python and maybe a library for Windows to access Excel objects from a Python script in a cmd or powershell prompt.
This is exactly it. The killer feature for including any modern scripting language in Excel. Both XlxsWriter and openpyxl can r/w from Excel files but I have to manipulate the data using another library like `pandas`. Instead if MSFT gave a library which I can import into a Python script and use like
import msft_excel_lib as xl
data = xl.get('A1:A3')
sum = xl.sum(data)
xl.write("B3", sum)
would be much better than whatever it is they have shipped today without having to make much changes to anything else. I wouldn't even grudge them if they say that this library can run under some weird virtual environment found only within Excel to maintain product retention.
- qsi 2y agoYou can do this through COM. I forgot which Python library I used but once you have an Excel application object you can do Data = xl.range('a1:a3') Sum = xl.worksheetfunction.sum(data) Xl.range('b3').value = sum Any library enabling the COM link will do. (sorry, typing this on my phone so formatting and capitalization are screwy)