What's the right way to build ExcelPython

[Brian]

Two questions:

• #include "ExcelPython_h.h" where is ExcelPython_h.h?

• It would be nice if there was a 64 bit configuration in the .sln. Are there plans for this?

Edit: never mind! I figured it out (the .h file gets generated and platform is separate from config in VS)

Some suggestions too if you're interested ;)

• Get rid of your dependency on boost: http://stackoverflow.com/questions/8624146/c11-standard-scoped-array-wrappers

• Raw .dlls would be nice to get for those without admin rights

• Develop on a separate branch and get rid of all the comments in your codebase :P

Thanks a lot though: this is awesome :) I've just got to get it to work!

[Eric Reynolds]

Quick reply, will take a closer look when I have a moment: 1) that header
file is generated automatically by the compiler from ExcelPython.idl and 2)
there should be a 64-bit setting in the sln, unless I forgot to commit it
to the repository.
Regards, Eric

[Eric Reynolds]

If you want a quick fix to get the DLLs you can try opening the installer exe with 7zip or similar. You need to place them somewhere on the path (the installer places them in ...\Windows\System32) and register the typelib with regtlb or regtlbv12.

Thanks for the suggestions I will definitely try to follow them when I have some spare time.

Please let me know how you get on, your feedback is very valuable.

Best, Eric

[rss351]

Hi Eric!

Thank you for your work on this program. It looks to be extremely useful!

As mentioned above, I was wondering if you could post or release .zip file versions of the .dll and .tlb files. I was unable to unzip the .exe files with 7zip. Also, is it possible to store the .dll files in a user-space directory (e.g. not \Windows\System32) and point Excel to call ExcelPython from that location?

Thanks!

[Eric Reynolds]

Hi rss,

No it does not need to be in the system folder, Excel.exe just needs to be able to find it: check out how Windows looks for DLLs http://msdn.microsoft.com/en-us/library/windows/desktop/ms682586(v=vs.85).aspx#standard_search_order_for_desktop_applications

Basically the easiest way is to use VBA to add the folder containing the DLL to the PATH environment variable when the workbook is opened.

I won't release zips as it is a very minor use case, however if you want to do this please be my guest! ExcelPython is open source, don't ask, do! :)

Hope this helps

Eric