4 ms·
There are many little things that just aren't available in Python-Excel libraries, that are available in VSTO. There are also odd little things that Python dat
by wenc 8y ago
There are many little things that just aren't available in Python-Excel libraries, that are available in VSTO.
There are also odd little things that Python database libraries don't implement, like SqlClient.SqlBulkCopy. Native bulk inserting is generally unsupported on Python, so I either have to spit out a CSV and use bcp.exe to bulk insert, or I have to use TurbODBC, a Python library (which has certain limitations, like not supporting certain datatypes like VARCHAR(MAX) or GUIDs).