i think question has been asked before it's not clear, in original question user has provided excel.exe windows executable extension , not mac.
- i need open new excel instance in python on mac.
which module should import?
i'm newbie have completed learning python language, have trouble understanding documentation.
from comments not clear if need 'update' excel file data, , assume need excel so, or need change excel files include new data.
it easier, , faster (wrt excution speed) go 'updating' excel file without starting excel. updating not right word: have read in file , write out new. can of course overwrite orginal file, looks update.
for 'updating' can use trio xlrd, xlwt, xlutils if files work .xls files (excel 2003). iirc xlwt not support .xlsx writing (but xlrd can read files).
for .xlsx files use openpyxl,
both enough writing things data, formula , basic formatting.
if have existing excel files use 'templates' information lost if read/write using 1 of above packages, then have go updating file in excel. had because had no easy way include visual basic macros , specific formatting specified client. , easier visually setup spreadsheet , fill cells programmatically. done on windows.
if have drive excel on mac, because need use existing files templates, suggest @ applescript. or, if option, @ openoffice/libreoffice pyuno interface.
Comments
Post a Comment