.xlsx文件的帮助函数
xlsxutilit的Python项目详细描述
Xlsx文件类型实用程序函数
自动调整列:使用xlswriter自动调整写入xlsx文件的数据帧中的所有列
defautofit_columns(dataframe,worksheet,padding=1.1,index=True):""" :param dataframe: Base dataframe written to xlsx workbook :param worksheet: Sheet in xlsx workbook to be formatted :param padding: Optional, padding amount :param index: Optional, Index true/false in dataframe. Defaults true, use false for non-indexed dataframe outputs. :return: formatted worksheet """
示例调用
^{pr2}$对齐单元格:水平或垂直对齐给定数据框中的所有单元格。
注意-如果与autofit_列一起使用,则必须首先调用该列,否则将覆盖默认宽度(1)。
defalign_cells(dataframe,workbook,worksheet,align='center'):""" :param dataframe: Reference Dataset, Pandas Dataframe :type dataframe: Pandas Dataframe :param workbook: Xlsxwriter workbook :param worksheet: Xlsxwriter worksheet (must be within workbook) :param align (optional):Defaults to horizontal center. Alignment types Horizontal: (left / center/ right / fill / justify / center_across / distributed) or Vertical: (top, vcenter, bottom, vjustify, vdistributed) """
示例调用
importpandasaspdimportnumpyasnpfromxlsxutilityimportalign_cellsdf=pd.DataFrame(np.array([[1,2,3],[4,5,6],[7,8,9]]),columns=['a','b','c'])writer=pd.excelwriter("some_path",sheet_name='Example',engine='xlsxwriter')df.to_excel(writer)align_cells(df,writer,writer.sheets['Example'],'center')
- 项目
标签: