topic Re: openpyxl in Python Questions

openpyxl

CCWeedcontrol — Sat, 11 Dec 2021 23:10:02 GMT

I have the following script, i am trying to export sql table to an excel file. I have installed the openpyxl library using. C:\Python27\ArcGISx6410.4\Scripts>pip install openpyxl. everything installed fine. I have the following folders openpyxl & openpyxl-2.4.9.dist-info in C:\Python27\ArcGIS1040\Lib\site-packages. Any ideas on what i am doing wrong?

When i runt he following script i get the error.

line 3, in <module>
import openpyxl
ImportError: No module named openpyxl

Script

import pyodbc
import pandas as pd
import openpyxl

cnxn = pyodbc.connect('DRIVER={SQL Server};SERVER=csde18;Trusted_Connection=yes', autocommit=True)

cursor = cnxn.cursor()
script = """
SELECT * FROM dbo.Characteristics 
"""

df = pd.read_sql(script, cnxn)

writer = pd.ExcelWriter('C:\\Temp\\Characteristics.xlsx')
df.to_excel(writer, sheet_name='bar')
writer.save()

print 'Done'
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: openpyxl

DanPatterson_Retired — Wed, 10 Jan 2018 21:51:27 GMT

installed using the instructions from? https://openpyxl.readthedocs.io/en/default/

most links I have seen use

from openpyxl import Workbook

Re: openpyxl

CCWeedcontrol — Thu, 11 Jan 2018 16:28:58 GMT

inst it just C:\Python27\ArcGISx6410.4\Scripts>pip install openpyxl?

if i try $ pip install openpyxl i get '$' is not recognized as an internal or external command.

Re: openpyxl

CCWeedcontrol — Thu, 11 Jan 2018 18:11:12 GMT

So i uninstalled openpyxl with pip uninstall openpyxl. Then i tried to reinstall it with C:\Python27\ArcGISx6410.4\Scripts>pip install openpyxl. i get following, why is it referring to c:\python27\arcgis10.4?

C:\Python27\ArcGISx6410.4\Scripts>pip install openpyxl
Collecting openpyxl
Requirement already satisfied: et-xmlfile in c:\python27\arcgis10.4\lib\site-packages (from openpyxl)
Requirement already satisfied: jdcal in c:\python27\arcgis10.4\lib\site-packages (from openpyxl)
Installing collected packages: openpyxl
Successfully installed openpyxl-2.4.9

Re: openpyxl

DanPatterson_Retired — Thu, 11 Jan 2018 19:17:33 GMT

sounds like you have 2 versions of 2.7 installed. dump the 64 bit version, the one in the arcgis10.4 folder is the correct one, you will get conflicts that may be difficult to resolve until you move on to Pro and use the Anaconda distributions of python 3.x and can set up other installations of python. Besides, you can install your module and others much more readily using a conda distribution.

Re: openpyxl

CCWeedcontrol — Thu, 11 Jan 2018 20:39:31 GMT

ya I do, i am trying to think why i installed 64 bit version. I think i have one script that benefited from the 64 bit but i can't remember. Wouldn't i want to keep the 64 bit version, 64 bit better than 32 bit? Dumb question but how do i remove a python version?

Re: openpyxl

DanPatterson_Retired — Thu, 11 Jan 2018 22:01:22 GMT

uninstall the version not in the arcgis10.4 folder. You should be able to uninstall it through windows install/uninstall in Windows Control panel

Re: openpyxl

CCWeedcontrol — Thu, 11 Jan 2018 22:46:12 GMT

I have two folders in C:\Python27 - ArcGIS10.4 & ArcGISx6410.4.

I do see python in install/uninstall windows control panel. i have windows 10.

Re: openpyxl

DanPatterson_Retired — Thu, 11 Jan 2018 23:01:34 GMT

C:\Python27\ArcGIS10.4 is the one that came with arcmap... you must have installed the one for 64 bit later. If you need 64 bit, install Pro, everything is just better managed in Pro

Re: openpyxl

DanPatterson_Retired — Thu, 11 Jan 2018 23:09:51 GMT

proof from pro...

Re: openpyxl

CCWeedcontrol — Thu, 11 Jan 2018 23:14:01 GMT

Sorry Dan, i meant "I do not see Python in install/uninstall windows control panel". I haven't had any issues with 64 bit until now. I am not sure how to uninstall 64 bit if i don't see it in the install/uninstall windows control panel.

Re: openpyxl

DanPatterson_Retired — Fri, 12 Jan 2018 00:07:48 GMT

you did pip? I don't use it, but I suspect there is a pip uninstall/remove or check in that python's distribution for 'uninstall' py or exe

Re: openpyxl

CCWeedcontrol — Fri, 12 Jan 2018 15:27:49 GMT

I was able to uninstall it through the install/uninstall windows control panel, it was under Arcgis Background Geoprocessing 64 bit. I have removed the 64 bit, but know my IDLE is gone. How can i get IDLE back with 32 bit? I do have Pro installed but i currently now using it because i don't edit capabilities yet

Re: openpyxl

DanPatterson_Retired — Fri, 12 Jan 2018 15:40:57 GMT

repair you install of arcmap through windows control panel install/uninstall then select repair

Re: openpyxl

CCWeedcontrol — Fri, 12 Jan 2018 16:11:35 GMT

Ok, i removed the Arcgis Background Geoprocessing 64 bit and once i repair it and i deleted the ArcGISx6410.4 folder. Do i do an pip install openpyxl to the C:\python27\ArcGIS10.4\scrips - pip install openpyxl?

Re: openpyxl

DanPatterson_Retired — Fri, 12 Jan 2018 16:17:16 GMT

My suggestion is to skip arcmap and install Pro, it is more accommodating and you will have your 64bit world

Nothing I have said has helped apparently, so I will let the other viewers of this post leap in to finish the task.

Re: openpyxl

CCWeedcontrol — Fri, 12 Jan 2018 16:57:29 GMT

Dan, you have helped me. i had to uninstall Arcmap and reinstall it. removal of the ArcMap Geoprocessing 64 bit corrupted my arcmap to where i could not uninstall. I had to use Microsofts Uninstall Troubleshooter https://support.microsoft.com/en-us/help/17588/fix-problems-that-block-programs-from-being-installed-or-removed. Once i ran this i was able to uninstall arcmap, reinstalled and now i have python 32 bit and idle. After add some libraries (pyodbc & openpxyl) i was able to get past the error. but now i have another error ha ha.

thank you.