跳到主要內容

Python-開啟檔案-excel

Python
開啟檔案
excel

安裝:
linux、mac :pip3 install openpyxl、pip3 install xlwt、pip3 install xlrd
windows    :之後補上

程式碼說明

2007年版後
寫入
from openpyxl import Workbook,load_workbook
wb = Workbook()
ws = wb.active

ws1 = wb.create_sheet('Mysheet')
ws2 = wb.create_sheet('Mysheet', 0)
ws1.title = 'New Title'

print(wb.sheetnames)

ws['A4'] = 4
ws.cell(row=4, column=2, value=10)

wb.save('demo.xlsx') 

讀取
wb_load = load_workbook('demo.xlsx') 
sheet_ranges = wb_load['Sheet']
print(sheet_ranges['A4'].value)
2007年版前
寫入
import xlwt
from datetime import datetime

style0 = xlwt.easyxf('font: name Times New Roman, \
color-index red, bold on',num_format_str='#,##0.00')

style1 = xlwt.easyxf(num_format_str='D-MMM-YY')

wb = xlwt.Workbook()
ws = wb.add_sheet('A Test Sheet')


ws.write(0, 0, 124, style0)
ws.write(1, 0, datetime.now(), style1)
ws.write(2, 0, 1)
ws.write(2, 1, 1)
ws.write(2, 2, xlwt.Formula("A3+B3"))
wb.save('demo.xls')

 讀取
import xlrd
book = xlrd.open_workbook("demo.xls")
print("The number of worksheets is {0}".format(book.nsheets))
print("Worksheet name(s): {0}".format(book.sheet_names()))
sh = book.sheet_by_index(0)
print("{0} {1} {2}".format(sh.name, sh.nrows, sh.ncols))
print("Cell A1 is {0}".format(sh.cell_value(rowx=2, colx=1)))
for rx in range(sh.nrows):
    print(sh.row(rx))


程式碼說明

openpyxl同時能夠讀寫
xlwt只能夠寫
xlrd只能夠讀

2007年後板本

匯入必要模組
建立workbook()
啟動worksheet
建立sheet，一共三個，中階還有改名字
給ws['A4']值
給ws row=4 column=2值
存檔
讀檔
指定ws特定sheet
印出特定位置資料


2007年前板本

匯入必要模組
定義sytle
建立workbook()
啟動worksheet
建立sheet，一共三個，中階還有改名字
給ws特定位置值
存檔

匯入必要模組
讀檔
印出特定資料表各種屬性


標籤：

留言

張貼留言

這個網誌中的熱門文章

Python-程式優化設計-module

class Objects, values and types CPython implementation detail:  For CPython,  The standard type hierarchy User-defined functions __doc__ The function’s documentation string, or  None  if unavailable; not inherited by subclasses Writable __name__ The function’s name Writable __qualname__ The function’s  qualified name New in version 3.3. Writable __module__ The name of the module the function was defined in, or  None  if unavailable. Writable __defaults__ A tuple containing default argument values for those arguments that have defaults, or  None  if no arguments have a default value Writable __code__ The code object representing the compiled function body. Writable __globals__ A reference to the dictionary that holds the function’s global variables — the global namespace of the module in which the function was defined. Read-only __dict__ The namespace supporting arbitrary function attributes. Writable __closure__ None ...
張貼留言
閱讀完整內容

python-設計模式-原型模式

python 設計模式 原型模式 import copy  class Prototype:     def __init__(self):        self.obj = {}     def Registor(self, key,new_obj):        self.obj[key] = new_obj     def UnRegistor(self, key):        del self.obj[key]    def DeepClone(self, name, **attr):        obj_clone = copy.deepcopy(self.obj.get(name))        obj_clone.__dict__.update(attr)        return obj_clone     def Clone(self, name, **attr):        obj_clone = copy.copy(self.obj.get(name))        obj_clone.__dict__.update(attr)        return obj_clone  class a:     def __init__(self):        self.name = ['a1','a2']  class b:     def __init__(self):        self.name = 'b'...
張貼留言
閱讀完整內容

Python-資料庫-mysql-sqlalchemy

Python 資料庫 mysql-sqlalchemy 安裝 Linux、mac : pip3 install SQLAlchemy windows     :之後補充 第一部分 from sqlalchemy import create_engine from sqlalchemy.ext.declarative import declarative_base from sqlalchemy.orm import sessionmaker engine = create_engine('sqlite:///:memory', echo=False) Base = declarative_base() Session = sessionmaker(bind=engine) 第二部分 from test_sqlalchemy import * from sqlalchemy import Column, Integer, String class User(Base): __tablename__ = 'users' id = Column(Integer, primary_key=True) name = Column(String) fullname = Column(String) password = Column(String) def __repr(self): return "<User(name={})>".format(self.name) 第三部分 from test_sqlalchemy import * from build_model import * Base.metadata.create_all(engine) user1 = User(name='user1', fullname='user1', password='user1') user2 = User(name='user2', fullname='user2...
張貼留言
閱讀完整內容