tagashira / pyinex

Automatically exported from code.google.com/p/pyinex
0 stars 0 forks source link

Get an error message when trying to install the add-on #3

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Move the xll file to the Addons folder for MS Office (C:\Program 
Files\Microsoft Office\Office12\ADDINS)
2. Add new Addon to Excel using normal procedure (Excel circle button/Excel 
options/Add-Ins/Manage: Excel Add-ins [Go]/Check Pyinex082-Py25-Vc90-Mt/[OK]
3. Close Excel
4. Re-open Excel

What is the expected output?  I expected to see a blank Excel spreadsheet
What do you see instead? A dialog box saying:

=====
Microsoft Office Excel
----------------------
{Exclamation point}The file you are trying to open, 
'Pyinex082-py25-vc90-mt.xll', is in a different format than specified by the 
file extension.  Verify that the file is not corrupted and is from a trusted 
source before opening the file.  Do you want to open the file now?
[Yes] [No] [Help]
=====

I can click [Yes],[No],[Help]

If I click yes, I can see some relative gibberish on the screen.  If I click 
no, a plain Excel spreadsheet opens.  Help explains what 'different format than 
file extension' means.

I expect to see the example spreadsheets, instead, I see this: dialog box.

If I load an example spreadsheet, it loads.  I can change the location of the 
python example file, but the spreadsheet doesn't work (I assume because the 
add-on is not really loaded).

What version of the product are you using? 
Pyinex082-py25-vc90-mt.xll

On what operating system?
Windows XP
Office 12 (Excel 2007)
Python 2.5.4 at c:\Program Files\Python
python25.dll at c:\Program Files\Python

Please provide any additional information below.
Other than this, Excel works as expected.  Other than this, python works as 
expected.

I was very excited at the thought of being able to use Python instead of VBA  I 
hope this is a simple fix.

Original issue reported on code.google.com by patents...@gmail.com on 22 Mar 2011 at 5:31

GoogleCodeExporter commented 9 years ago
i have the same issue except my office is 2010 and i'm loading the 3.1 version 
of the dll - was this ever resolved?

Original comment by natalia....@gmail.com on 3 Jun 2012 at 6:08

GoogleCodeExporter commented 9 years ago
Hi,

I am new user of pyinex and I went through the source code and got the same 
problem as you.

Loading the xll into Excel in safe mode solves this problem. FYI, I used Excel 
2010 32-bit wih Python 2.7. No changes in the code is necessary if you are 
using Python 2.7 as far as I have seen so far.

Let me know if you have any questions.

Regards,
Chandra.

Original comment by chandrus...@gmail.com on 18 Mar 2013 at 2:59