Hello!
I need get data of PivotCaches to ODC File, but a have the following error:
---------------------------------------------------------------------------
com_error Traceback (most recent call last)
<ipython-input-5-8ecf280d3302> in <module>
5 print(odc_name)
6
----> 7 nivel_1.SaveAsODC(ODCFileName=odc_name)
c:\users\mdabati\appdata\local\programs\python\python36\lib\site-packages\win32com\gen_py\00020813-0000-0000-C000-000000000046x0x1x9\PivotCache.py
in SaveAsODC(self, ODCFileName, Description, Keywords)
59 def SaveAsODC(self, ODCFileName=defaultNamedNotOptArg,
Description=defaultNamedOptArg, Keywords=defaultNamedOptArg):
60 return self._oleobj_.InvokeTypes(2082, LCID, 1, (24, 0), ((8,
1), (12, 17), (12, 17)),ODCFileName
---> 61 , Description, Keywords)
62
63 _prop_map_get_ = {
com_error: (-2147352567, 'Exceção.', (0, None, None, None, 0, -2147024809),
None)
I'm use Python 3.65, my code:
import urllib
import pandas as pd
import random
import win32com.client
Excel = win32com.client.gencache.EnsureDispatch('Excel.Application')
# URL file
url =
'http://www.anp.gov.br/images/DADOS_ESTATISTICOS/Vendas_de_Combustiveis/Vendas_de_Combustiveis_m3.xls'
# Load URL
file_name, headers = urllib.request.urlretrieve(url)
# Load XLS
arq = Excel.Workbooks.Open(file_name)
PivotCaches = arq.PivotCaches()
for nivel_1 in PivotCaches.__iter__():
odc_name = 'ODCFile_'+str(random.randint(1,100))
print(odc_name)
nivel_1.SaveAsODC(ODCFileName=odc_name)
Att.
Maikon Abati
_______________________________________________
python-win32 mailing list
python-win32@python.org
https://mail.python.org/mailman/listinfo/python-win32
