Open zhuj opened 7 years ago
i.e. by calling Java+POI, if it's available:
http://stackoverflow.com/questions/23885116/is-there-any-way-to-create-a-pivot-table-in-excel-using-apache-poi
see
https://www.py4j.org/index.html http://pyjnius.readthedocs.io/en/latest/ https://pypi.python.org/pypi/JCC
or directly from VBA
https://msdn.microsoft.com/ru-ru/library/office/hh243933(v=office.14).aspx https://support.office.com/en-us/article/Automatically-run-a-macro-when-opening-a-workbook-1e55959b-e077-4c88-a696-c3017600db44?ui=en-US&rs=en-US&ad=US&fromAR=1
i.e. by calling Java+POI, if it's available:
http://stackoverflow.com/questions/23885116/is-there-any-way-to-create-a-pivot-table-in-excel-using-apache-poi
see
https://www.py4j.org/index.html http://pyjnius.readthedocs.io/en/latest/ https://pypi.python.org/pypi/JCC
or directly from VBA
https://msdn.microsoft.com/ru-ru/library/office/hh243933(v=office.14).aspx https://support.office.com/en-us/article/Automatically-run-a-macro-when-opening-a-workbook-1e55959b-e077-4c88-a696-c3017600db44?ui=en-US&rs=en-US&ad=US&fromAR=1