Showing posts with label python. Show all posts

Friday, September 8, 2017

Reading Excel Spreadsheets with Python

Excel & Python

Reading an Excel Spreadsheet

In this section, we will look at a function that demonstrates reads the Excel sheet data and convert that data into XML file.

We Used the following libraries to do the above functionality

Openpyxl : Openpyxl is a Python library for reading and writing Excel 2010 xlsx/xlsm/xltx/xltm files.
xml.etree.ElementTree: To create the xml tree elements
datetime: to conver the date time column values to specified format

	from openpyxl import load_workbook
	import datetime

	import xml.etree.cElementTree as ET
	wb = load_workbook(filename = 'Sku Assignment 8.24 Furniture Content.xlsx')

	sheet = wb.get_sheet_by_name('Output Sheet')#sheet name

	root = ET.Element("skuProducts")

	i=0
	for rowOfCellObjects in sheet.rows:
	doc = ET.SubElement(root, "skuProduct"+str(i))
	j=0

	for cellObj in rowOfCellObjects:
	print(cellObj.coordinate, cellObj.value)
	print type(cellObj.value)

	datatype = type(cellObj.value)
	if( datatype is unicode):
	ET.SubElement(doc, cellObj.coordinate).text = cellObj.value
	elif( datatype is long):
	print int(cellObj.value)
	ET.SubElement(doc, cellObj.coordinate).text = str(int(cellObj.value))
	elif isinstance(cellObj.value, datetime.date):
	#print cellObj.value.strftime('%m/%d/%Y')
	#pass
	ET.SubElement(doc, cellObj.coordinate).text = str(cellObj.value.strftime('%m/%d/%Y'))

	else:
	print "pass"
	pass



	j=j+1

	i=i+1
	print('--- END OF ROW ---')

	tree = ET.ElementTree(root)
	tree.write("filename.xml")

view raw convert.py hosted with ❤ by GitHub

Friday, September 1, 2017

Install mysql-python in windows

To Enable the mysql extension related python need to run the below command

pip install mysqlclient

If you are trying to use mysqlclient on WINDOWS with this failure,

"_mysql.c(29) : fatal error C1083: Cannot open include file: 'my_config.h': N
such file or directory"

try to install the lower version instead:

pip install mysqlclient==1.3.4

Configure Apache web server for Python on Windows

Run Python script as CGI program with Apache2.4 in Windows

1. Install Python and Apache

Python: http://python.org/download/.

Apache: http://httpd.apache.org/download.cgi

2. Configure Apache to run Python CGI

The next step is to edit ‘httpd.conf’ apache configuration file located in the apache
install directory in the conf directory.

Uncomment the below line
#LoadModule cgi_module modules/mod_cgi.so

After Uncomment
LoadModule cgi_module modules/mod_cgi.so

Search the httpd.conf file for the line

Options Indexes FollowSymLinks

Add ExecCGI to the end of the line. After adding total line looks like below

Options Indexes FollowSymLinks ExecCGI

Next, search for the following:

#AddHandler cgi-script .cgi

Uncomment this line by removing the # in front of the line,
and add a .py to the end of the line. The new line should look like this:

AddHandler cgi-script .cgi .py

Search for the line: ScriptAlias /cgi-bin/ /whatever-path/ – when you find it,
comment out the line: that is add a # in front of the line:
(or)Other wise add the below line

ScriptAlias /cgi-bin/ "C:/Apache2.4/cgi-bin/"

3. Restart Apache

4. Run the sample python file

Here is an example assuming Python is installed in the C:\Python27 location

	#!/Python27/python.exe


	print("Content-type: text/html")
	print("")
	print("<html><head>")
	print("")
	print("</head><body>")
	print("Hello from Python27 .")
	print("</body></html>")

view raw test.py hosted with ❤ by GitHub

Save this file as test.py to your htdocs folder under your apache installation directory.
Open your web browser and type in your apache host
(and :port if the port is something other than 80) followed by test.py,
for example: http://localhost/test.py

Lamp MAK