python使用openpyxl模块操作excel

Question

最近使用openpyxl模块来读写excel，比如有一个单元格A1，我想把连续的几条数据都插进在A1中应该使用openpyxl中的什么方法？求大神解答。谢谢

Answer 1

你可以把数据拼接然后放到单元格里面啊，比如说字符串

from openpyxl import Workbook


wb = Workbook()
ws = wb.active

data1 = 'this '
data2 = 'is '
data3 = 'awesome.'

ws.title = 'first sheet'
ws['A1'] = data1 + data2 + data3
wb.save('test.xls')

Answer 2

import openpyxl

wb = openpyxl.Workbook()
ws = wb.active

data1 = 'this '
data2 = 'is '
data3 = 'awesome.'

ws.title = 'first sheet'
ws['A1'].value = data1 + data2 + data3
wb.save('test.xls')