@JoinQuant-PM 你好!
请问,这个代码错在哪里?我在自己电脑的python 可以这么用的。
writer=pd.ExcelWriter('Equity Style Analysis' +datetime.now().date().isoformat()+'.xlsx')
df_equity_style_sheet.to_excel(writer,'Equity Style Analysis')
writer.save()
最后输出这个错误:
---------------------------------------------------------------------------
ImportError Traceback (most recent call last)
in ()
1 writer=pd.ExcelWriter('Equity Style Analysis' +datetime.now().date().isoformat()+'.xlsx')
----> 2 df_equity_style_sheet.to_excel(writer,'a')
3 writer.save()
/opt/conda/lib/python3.4/site-packages/pandas/core/frame.py in to_excel(self, excel_writer, sheet_name, na_rep, float_format, columns, header, index, index_label, startrow, startcol, engine, merge_cells, encoding, inf_rep)
1272 formatted_cells = formatter.get_formatted_cells()
1273 excel_writer.write_cells(formatted_cells, sheet_name,
-> 1274 startrow=startrow, startcol=startcol)
1275 if need_save:
1276 excel_writer.save()
/opt/conda/lib/python3.4/site-packages/pandas/io/excel.py in write_cells(self, cells, sheet_name, startrow, startcol)
747 def write_cells(self, cells, sheet_name=None, startrow=0, startcol=0):
748 # Write the frame cells using openpyxl.
--> 749 from openpyxl.cell import get_column_letter
750
751 sheet_name = self._get_sheet_name(sheet_name)
ImportError: cannot import name 'get_column_letter'
2017-02-20