难点:随机取一行,取值这行内容。
解决代码及注意点如下:
from openpyxl import load_workbook
import random
def get_news():
wb = load_workbook(filename='新闻清单.xlsx')
st = wb.active
#print(st.min_row, st.max_row, st.max_column, st.min_column)
random_row = random.randint(st.min_row + 1, st.max_row + 1) #this is only a number
random_row_value = [] #cannot put under for cycle, otherwise it return one value
for col in range(st.min_column - 1, st.max_column):
cell = st[random_row][col] #read every cell in order
random_row_value.append(cell.value)
return random_row_value
news=get_news()
print(news)