Python中使用第三方库xlutils来追加写入Excel文件示例
目前还没有更好的方法来追写Excel，lorinnn在网上搜索到以及之后用到的方法就是使用第三方库xlutils来实现了这个功能，主体思想就是先复制一份Sheet然后再次基础上追加并保存到一份新的Excel文档中去。
使用xlutils
代码实现如下：
# -*- coding: utf-8 -*-
'''
Created on 2012-12-17
@author: walfred
@module: XLRDPkg.write_append
@description:
'''
import os
from xlutils.copy import copy
import xlrd as ExcelRead
def write_append(file_name):
values = ["Ann", "woman", 22, "UK"]
r_xls = ExcelRead.open_workbook(file_name)
r_sheet = r_xls.sheet_by_index(0)
rows = r_sheet.nrows
w_xls = copy(r_xls)
sheet_write = w_xls.get_sheet(0)
for i in range(0, len(values)):
sheet_write.write(rows, i, values[i])
w_xls.save(file_name + '.out' + os.path.splitext(file_name)[-1]);
if __name__ == "__main__":
write_append("./test_append.xls")追写前
name sex age country jim man 19 USA hmm woman 24 CHN lilei man 24 CHN
追写后
name sex age country jim man 19 USA hmm woman 24 CHN lilei man 24 CHN Ann woman 22 UK
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1378
52
The 2-Hour Python Plan: A Realistic Approach
Apr 11, 2025 am 12:04 AM
You can learn basic programming concepts and skills of Python within 2 hours. 1. Learn variables and data types, 2. Master control flow (conditional statements and loops), 3. Understand the definition and use of functions, 4. Quickly get started with Python programming through simple examples and code snippets.
How to read redis queue
Apr 10, 2025 pm 10:12 PM
To read a queue from Redis, you need to get the queue name, read the elements using the LPOP command, and process the empty queue. The specific steps are as follows: Get the queue name: name it with the prefix of "queue:" such as "queue:my-queue". Use the LPOP command: Eject the element from the head of the queue and return its value, such as LPOP queue:my-queue. Processing empty queues: If the queue is empty, LPOP returns nil, and you can check whether the queue exists before reading the element.
How to view server version of Redis
Apr 10, 2025 pm 01:27 PM
Question: How to view the Redis server version? Use the command line tool redis-cli --version to view the version of the connected server. Use the INFO server command to view the server's internal version and need to parse and return information. In a cluster environment, check the version consistency of each node and can be automatically checked using scripts. Use scripts to automate viewing versions, such as connecting with Python scripts and printing version information.
How to start the server with redis
Apr 10, 2025 pm 08:12 PM
The steps to start a Redis server include: Install Redis according to the operating system. Start the Redis service via redis-server (Linux/macOS) or redis-server.exe (Windows). Use the redis-cli ping (Linux/macOS) or redis-cli.exe ping (Windows) command to check the service status. Use a Redis client, such as redis-cli, Python, or Node.js, to access the server.
How to set the Redis memory size according to business needs?
Apr 10, 2025 pm 02:18 PM
Redis memory size setting needs to consider the following factors: data volume and growth trend: Estimate the size and growth rate of stored data. Data type: Different types (such as lists, hashes) occupy different memory. Caching policy: Full cache, partial cache, and phasing policies affect memory usage. Business Peak: Leave enough memory to deal with traffic peaks.
What is the impact of Redis persistence on memory?
Apr 10, 2025 pm 02:15 PM
Redis persistence will take up extra memory, RDB temporarily increases memory usage when generating snapshots, and AOF continues to take up memory when appending logs. Influencing factors include data volume, persistence policy and Redis configuration. To mitigate the impact, you can reasonably configure RDB snapshot policies, optimize AOF configuration, upgrade hardware and monitor memory usage. Furthermore, it is crucial to find a balance between performance and data security.
Python vs. C : Applications and Use Cases Compared
Apr 12, 2025 am 12:01 AM
Python is suitable for data science, web development and automation tasks, while C is suitable for system programming, game development and embedded systems. Python is known for its simplicity and powerful ecosystem, while C is known for its high performance and underlying control capabilities.
What are the Redis memory configuration parameters?
Apr 10, 2025 pm 02:03 PM
**The core parameter of Redis memory configuration is maxmemory, which limits the amount of memory that Redis can use. When this limit is exceeded, Redis executes an elimination strategy according to maxmemory-policy, including: noeviction (directly reject write), allkeys-lru/volatile-lru (eliminated by LRU), allkeys-random/volatile-random (eliminated by random elimination), and volatile-ttl (eliminated by expiration time). Other related parameters include maxmemory-samples (LRU sample quantity), rdb-compression
