使用Python对齐Excel工作表中的某些列

Question

我在使用xlsxWriter对齐Excel工作表的列时遇到问题。为了更清楚起见，这里是数据帧

   Name        Employee ID      Year
John Miller    2014108          2014
Sarah Jones    2011548          2011
Jake Kenedy    2010546          2010

我试图对齐Name列，使值位于左侧而不是居中

我试过了

^{pr2}$

然而，什么也没发生。 如有任何建议，将不胜感激。在

Answer 1

您需要实际应用name列的格式。在

df = pd.DataFrame ({'Name': ['J Miller', 'S Jones', 'J Kenedy'],
                    'Employee ID': [1,2,3],
                    'Year': [2014, 2011, 2010]})

writer = pd.ExcelWriter('left_aligned_file.xlsx', engine='xlsxwriter')

# Add your dataframe to the writer
df.to_excel(writer, sheet_name='Sheet1')

workbook = writer.book
worksheet = writer.sheets['Sheet1']

new_format = workbook.add_format()
new_format.set_align('left')

# Apply new format to name column, which will be column C.
worksheet.set_column('C:C', 10, new_format)
writer.save()

可能值得一看：http://xlsxwriter.readthedocs.io/example_pandas_column_formats.html