#-*- coding:utf-8 -*-
#__author__ = 'liu-ke'
import xlrd
from xlutils.copy import copy
mybook = xlrd.open_workbook("E:\liu-ke\user.xls")
mysheet = mybook.sheet_by_name("name")
j=mysheet.nrows
b=copy(mybook)
c=b.get_sheet(0)
c.write(9,1,"liu-ke")
b.save("E:\liu-ke\user.xls") for i in range(1,j):
print mysheet.cell(i,0).value

Python Reading and writing excel More articles about

  1. [ turn ] use Python Reading and writing Excel file

    [ turn ] use Python Reading and writing Excel file   from :http://www.gocalf.com/blog/python-read-write-excel.html#xlrd-xlwt Although I communicate with data every day ...

  2. python Reading and writing Excel Functions of files -- Use xlrd/xlwt

    python Read from Excel There are many modules or tools for , Such as the following : Packages Document download explain openpyxl Download | Documentation | Bitbucket  The ...

  3. python The whole development of the stack ,Day86( Upload files , Upload your avatar ,CBV,python Reading and writing Excel, A virtual environment virtualenv)

    One . Upload files Upload a picture Use input type="file", To upload a file . Be careful :form The form must add properties enctype="multipart/form-data ...

  4. Python Reading and writing Excel( turn )

    Python Reading and writing Excel Basically , This page says it all : http://pypi.python.org/pypi/xlrd Write this page beautifully when you have time , Now remember some code . read Excel Build first ...

  5. Python Reading and writing Excel Files and regular expressions

    Python Reading and writing Excel file What we use here is xlwt and xlrd these two items. excel Read and write library . #_*_ coding:utf-8 _*_ #__author__=' It's not far from the sea ' #__date__ ...

  6. Python Reading and writing EXCEL File common methods

    Preface python Reading and writing excel There are many ways , Different modules are slightly different in reading and writing , Here I mainly introduce several commonly used methods . use xlrd and xlwt Conduct excel Reading and writing : use openpyxl Conduct excel Reading and writing : use pa ...

  7. use Python Reading and writing Excel file ( turn )

    original text :google.com/ncr Although dealing with data every day , Also used frequently Excel Do some simple data processing and presentation , But for a long time, always careful to avoid using Python Direct reading and writing Excel file . Usually I save the data as TA ...

  8. python Reading and writing Excel file

    Recently, with python Deal with a small project , It's about being right excel Read and write operations , Through checking the data and practice, I made a summary , For later use . python Reading and writing excel The file uses two libraries :xlrd and xlwt, First, download and install the two libraries . ...

  9. mac System install pip, use python Reading and writing excel(xlrd、xlwt) install

    1: Install first python, Download address :https://www.python.org/downloads/release/python-372/ 2: install pip Download a get-pip.py The file of   ...

  10. use Python Reading and writing Excel The way the files are compared

    Although dealing with data every day , Also used frequently Excel Do some simple data processing and presentation , But for a long time, always careful to avoid using Python Direct reading and writing Excel file . Usually I save the data as TAB Split text file (TSV), And then Ex ...

Random recommendation

  1. Asp.net Next use HttpModule simulation Filter, Realize the authority control

    stay asp.net in , We're trying to prevent users from going directly from Url To bypass login verification by accessing the specified page in , You need to add validation to each page , Or add validation to the template page . If the project is relatively large , Adding validation is a maddening thing , This time , I'll share it with you ...

  2. ArrayList Vector LinkedList Difference and usage

    Reprinted from : http://www.cnblogs.com/mgod/archive/2007/08/05/844011.html Recently used , So it's still reprinted ArrayList and Vector It's an array ...

  3. Asp.Net - 9.socket( The chat room )

    9.1 Socket Relevant concepts IP Address Every networked computer has a unique IP Address . length 32 position , It's divided into four sections , Each paragraph 8 position , Expressed in decimal digits , Range of each segment 0 ~ 255 special IP:127.0.0.1 User local network card test ...

  4. Java Virtual machine details 01---- First time to know JVM

    The main contents are as follows : JVM The concept of JVM The development history JVM species Java language norm JVM standard One .JVM The concept of : JVM: Java Virtual Machine, Meaning for Java virtual machine . virtual machine : By soft ...

  5. Image processing kit ImagXpress course :Accusoft Image data transfer between different components

    Image processing kit ImagXpress The developer of Accusoft Pegasus It has a variety of image processing related controls , But how to add and transfer image data between these image processing controls ? stay ImagXpress 11 Before the release , It is necessary to put ...

  6. structure XCache Basic steps

    structure XCache Basic steps Before we start , First, make sure PHP Install and verify phpize Whether it is located in shell Of PATH Next . meanwhile , I need one more C compiler , for example GNU Compiler Col ...

  7. Design patterns _Mediator_ Mediator mode

    Image examples : four MM Playing mahjong , It's not clear who should give each other how much money , Luckily I was there , Count the money according to their chips , Those who make money take it from me , I'll pay those who lose money , Everything is OK La , I got four MM The phone . Mediator mode : Mediator ...

  8. Click to display the submenu , Leave the hidden submenu (onmouseout Lower include a Labeled js resolvent )

    <div class="menu">     <a href="javascript:void(0);" id="a_all&quo ...

  9. SICP-1.5- Control structure

    test DOCSETS stay docstring Add tests directly to def sum_naturals(n): """Return the sum of the first n na ...

  10. 【 A topological sort 】 Boring slides (slides)

    1395: Boring slides (slides) The time limit : 1000 ms         Memory limit : 65536 KB Submission number : 753     Passing number : 416 [ Title Description ] Professor Li will give a very heavy lecture this afternoon ...