py2exe and Tableau Python API -

first of all, please excuse me if i'm using of terminology incorrectly (accountant trade ...)

i'm writing piece of code planning pack .exe product.

i've included number of standard libraries (xlrd, csv, math, operator, os, shutil, time, datetime, , xlwings). unfortunately, when i've added 'dataextract' library program stopped working.

dataextract api written software called tableau (one of leading bi solutions on market). tableau website says not provide maintenance support @ moment.

i've tested on basic setup:

from xlwings import workbook, sheet, range workbook.set_mock_caller(r'x:\jac reporting\tables\pawel\development\_devxl\test1.xlsx')  f = workbook.caller() s = raw_input('type in anything: ')  range(1, (2, 1)).value = s 

this works fine. after adding:

import dataextract tde 

the console (black box) flash on screen , nothing happens.

questions:

1. does library (in case 'dataextract') has meet criteria compatible py2exe?

2. as tableau not maintain original code, mean won't able pack .exe using py2exe?

finally: i'm using 'dataextract' 2 years , long run program through .py file works charm :) decided take 1 step further.

any comments/input appreciated.

edit: not sure or not, when tried run same script using cx_freeze compiler got below error:

first of massive @andris pointed me @ correct direction.

it turned out dataextrac library dlls not automatically copied while compiler running. therefore need copy them 'site-package/dataextrac/bin' 'dist' folder.

also 12 dlls need 9 of them (i tried running exe file each of them). 1 don't need are: icin44.dll, msvcp100.dll , msvcr100.dll.

to on safe side coping them anyway though.

hope post otheres :)