如何使用 pandas 操作 excel 并显示dataframe多行， 全列

转帖一个好文 excel 操作
https://shazhenyu.blog.csdn.net/article/details/83104653?utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7EBlogCommendFromMachineLearnPai2%7Edefault-12.baidujs&dist_request_id=1331645.9688.16183693663790175&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7EBlogCommendFromMachineLearnPai2%7Edefault-12.baidujs

coding: utf-8

import openpyxl
import xlrd
import xlwt
from xlutils.copy import copy
from decimal import Decimal
import pandas as pd
import numpy as np

import pprint

pprint.pprint()

#显示所有列
pd.set_option(‘display.max_columns’, None)
#显示所有行

pd.set_option(‘display.max_rows’, None)

np.set_printoptions(threshold = np.inf)
#若想不以科学计数显示:
np.set_printoptions(s