python操作爬取excel中的数据

• 官方qq群：591191475
• 快手群：K225545989167
• 官方qq号：258167139
• 点击链接加入群聊【IT交流Java,Python,云计算，大数据

import pandas as pd

data = pd.read_excel("test.xls")
list = []
for i in data["票据号码"].values:
    list.append(str(i))
print(tuple(list))

import openpyxl

from openpyxl.utils import get_column_letter, column_index_from_string

# 打开excel文件
wb = openpyxl.load_workbook('相对路径/shizuishan.xlsx')

# 获取表
sheet = wb.active
max_row = sheet.max_row

# columnB = sheet['D1':'D%d' % max_row]
columnB = sheet['B1':'B%d' % max_row]

# 获取B列对应的所有单元格对象
for column_cells in columnB:
    for cell in column_cells:
        # print(cell.coordinate, cell.value)
        # print("'" + str(cell.value)+ "'" + "," , end="")
        print("'" + str(cell.value) + "'" + ",",end="")
        # "'" + cell.value + "'" + ","
        # p=cell.value
        # str('cell')
        # print("'"+str(p)+"'"+",")

• 数字是字符串

a = '123456789'
print(a[::-1])

• 数字是整型

a = 123456789
print(str(a)[::-1])

import numpy
from openpyxl import load_workbook
##读取路径
wb = load_workbook(filename=r'绝对路径/shizuishan.xlsx')
##读取名字为Sheet1的sheet表
ws = wb.get_sheet_by_name("Sheet1")
arr1 = []
arr2 = []
#循环取出来数据并封装数据
for row_A in range(1, 10000):
  #遍历第2行到10000行，第1列
  a1 = ws.cell(row=row_A, column=2).value
  ## 遍历第2行到10000行，第3列
  a2 = ws.cell(row=row_A, column=3).value
  if a1:
    # 写入数组1
    arr1.append(a1)
  if a2:
    # 写入数组2
    arr2.append(a2)

for a,b in map(list,zip(arr1,arr2)):
    print(a+b)

print（a，end=''）
# 需要加特殊符号的话字符拼接
print（“aaa”+“bbb”+“。”）