我有一个CSV文件,我正在放入一个数据框,然后将数据写入Excel。CSV看起来像:
ID, Number, Date, Code, Plan
我现在的代码是:
^{pr2}$我遇到的是,当我打开Excel工作表时,我会有一个ID,我希望有四行,但是在Excel单元格中,A2和A3被合并,然后A4和A5被合并,这是同一个ID
以下是我打开Excel时收到的消息:
<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error046640_01.xml</logFileName><summary>Errors were detected in file 'Y:\Client Files\Weis\Automated Reports\Payroll Report\Weis Chart.xlsx'</summary>
-<removedRecords summary="Following is a list of removed records:">
<removedRecord>Removed Records: Merge cells from /xl/worksheets/sheet1.xml part</removedRecord>
<removedRecord>Removed Records: Merge cells from /xl/worksheets/sheet2.xml part</removedRecord>
</removedRecords>
</recoveryLog>
目前没有回答
相关问题 更多 >
编程相关推荐