Excel edit using python

[suman]

Hi,

Is there any package to edit the existing excel cell data using python
or
to create excel charts using python

please help.

Thanks,
-- 
http://mail.python.org/mailman/listinfo/python-list

Python Information Form

[Suman Mupparapu]

Hi Team,

I am newbie to Python and glad to be part of the team. Sorry for starting
with a help.

Working on a creating a small information form ..and encountering issues
when trying to edit the details using Python Flask and MYSQL DB.

Placed the code below for your reference. Please help to fix this issue.
Let me know if you need any other details from my end.

1) HTML Page for the Form

Welcome






Name 
  

Email 
  
CRType 
New
 Old
  



The Output of the page is as below




The Python Code to Save and Display results is as below

>From flask import Flask, render_template, request, redirect
from flask_mysqldb import MySQL
# from flask_table import Table, Col, LinkCol



app = Flask(__name__)

# Configure db
#db = yaml.load(open('db.yaml'))
app.config['MYSQL_HOST'] = 'localhost'
app.config['MYSQL_USER'] = 'root'
#app.config['MYSQL_PASSWORD'] = 'P@$$w0rd'
app.config['MYSQL_DB'] = 'flaskapp'

mysql = MySQL(app)

@app.route('/', methods=['GET', 'POST'])
def index():
if request.method == 'POST':
# Fetch form data
userDetails = request.form
name = userDetails['name']
email = userDetails['email']
CRType = userDetails['CRType']
 #   CR_ID = userDetails['CR_ID']
cur = mysql.connection.cursor()
  #  cur.execute("""INSERT INTO users(name, email, CRType)
VALUES(%s, %s, % )""",(name, email, CRType)
cur.execute("""INSERT INTO users (name, email, CRType) VALUES
(%s, %s, %s)""", (name, email, CRType))
mysql.connection.commit()
cur.close()
return redirect ('/results')
  #  return redirect('/results')
return render_template('index.html')

@app.route('/results')
def results():
cur = mysql.connection.cursor()
resultValue = cur.execute("SELECT * from users")
if resultValue > 0:
userDetails = cur.fetchall()
#edit = LinkCol('Edit', 'edit', url_kwargs=dict(id='CR_ID'))
return render_template('results.html',userDetails=userDetails)

Results are displayed as below


If we click on the Edit for Example Row 1 .. the following data is displayed


When I click on Submit, the below error is displayed





Edit HTML Page and Python Code for Edit

h1>Welcome to Update Zone






CR_ID 
  
Name 
  

Email 
  
  
  



app.route('/Edit', methods=['GET', 'POST'])
def Edit():

CR_ID = request.args.get('CR_ID')
cur = mysql.connection.cursor()
result = cur.execute("""SELECT CR_ID, name, email from users where
CR_ID = %s""",CR_ID)
RV = cur.fetchall()
cur.close()
user = RV[0]
return render_template('Edit.html',user=user)


Thanks in Advance.
-- 
https://mail.python.org/mailman/listinfo/python-list

I encounter a problem during installations!!!

[SUMIT SUMAN]

I have reinstall windows 8.1 for some reasons, and when I installed Python
3.6.1 then, it shows error that"The program can't start because
api-ms-win-crt-runtime-I1-1-0.dll is missing from your computer. Try
reinstalling the program to fix this problem." Please,help me!!!
-- 
https://mail.python.org/mailman/listinfo/python-list

One more problem that.....................

[SUMIT SUMAN]

The C runtime Update(KB2999226) in Python 3.6.1 installation is taking very
much time to complete , what can I do? Please help!!!
-- 
https://mail.python.org/mailman/listinfo/python-list

I have a encountered a new problem.

[SUMIT SUMAN]

I have encountered a problem while opening the Python 3.6.1 IDLE


The error message is this-

[image: Inline image 1]
-- 
https://mail.python.org/mailman/listinfo/python-list

NEW JOB req: Python developer with Analytical risk

[Suman Bharathi Balasubramanian]

Python Developers with Analytical Risk Exp- NYC, Long Island, Wilmington, 
Columbus, Dallas
6 months plus 
* Implement statistical, economic, econometric or other mathematical 
models/code for Client's bank models in Python
* Ability to translate existing Excel / SAS Model implementations into 
requirements and high-performance Python implementation
* Work with Enterprise Data Warehouse (ICDW/Teradata) staff members to map 
variables from their source systems to tables and data sets used by the 
modeling team and to create necessary meta data to document sources and field 
definitions
* Responsible for all aspects of data management for the modeling team, data 
sourcing into containers (Numpy/Pandas), Documentation(Sphynx), Acceleration, 
(Numba/Cython) and graphics (Matplotlib/Ggplot/Bokeh)
* Assist modeling team members with questions surrounding sources of data files 
and definitions of data fields
* Develop and maintain report-writing programs used by modeling team members.

* Application Developer (Ad Hoc/Statistical Programmer) with 7+ experience 
years in Python
* Experience with Python programming using Data Containers (Numpy/Pandas), 
Documentation (Sphynx), Acceleration, (Numba/Cython) and graphics 
(Matplotlib/Ggplot/Bokeh)
* Translate Excel / SAS Model Implementations into Python
* Ability to produce queries/tables on request - Sourced from Oracle / Teradata 
Databases
* Preference will be provided to those with demonstrated modeling experience in 
consumer and retail business banking
* Excellent communication skills, as the incumbent will frequently be called 
upon to make presentations to senior management and to write documents that 
describe work products in a clear manner.

regards,
suma...@sstech.us
-- 
https://mail.python.org/mailman/listinfo/python-list