I am working on a simple import modify and export program and when I open the exported file it tells me there are errors in the table xml. It is capable of fixing these errors and everything looks great, but it is rather annoying to have that pop up when you open the file for the first time after export.
I tried to simplify the code as much as possible while still getting the error and it ended up as:
Workbook importedWorkbook = Workbook.Load("C:\\Users\\admin\\Documents\\import.xlsx"); importedWorkbook.Save("C:\\Users\\admin\\Documents\\export.xlsx");
With no modification to the file I am still getting table xml errors!
I am using Infragistics 4 Excel v15.1. Unfortunately I can not give you the excel document I am working with but the original table xml is:
<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<table headerRowBorderDxfId="637" totalsRowDxfId="636" headerRowDxfId="638" totalsRowCount="1" ref="A1:N5" displayName="Table2436784757" name="Table2436784757" id="56" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<autoFilter ref="A1:N4"/>
-<sortState ref="A2:Q92">
<sortCondition ref="K1:K92"/>
</sortState>
-<tableColumns count="14">
<tableColumn totalsRowDxfId="634" name="Test Name" id="1" dataDxfId="635"/>
<tableColumn totalsRowDxfId="632" name="Assignee" id="12" dataDxfId="633"/>
<tableColumn totalsRowDxfId="630" name="Automated?" id="10" dataDxfId="631"/>
<tableColumn totalsRowDxfId="628" name="FV GDS Status" id="2" dataDxfId="629"/>
<tableColumn totalsRowDxfId="626" name="# Validation or Functional_x000a_Points" id="7" dataDxfId="627"/>
<tableColumn totalsRowDxfId="624" name="# Validation or Functional_x000a_Points Passed" id="8" dataDxfId="625"/>
<tableColumn totalsRowDxfId="622" name="# Tot Reqs" id="5" dataDxfId="623"/>
<tableColumn totalsRowDxfId="620" name="Reqs Passed" id="15" dataDxfId="621"/>
<tableColumn totalsRowDxfId="618" name="Reqs Failed" id="16" dataDxfId="619"/>
<tableColumn totalsRowDxfId="616" name="Reqs Not Tested" id="6" dataDxfId="617"/>
<tableColumn totalsRowDxfId="614" name="Reqs#" id="9" dataDxfId="615"/>
<tableColumn totalsRowDxfId="612" name="Notes" id="3" dataDxfId="613"/>
<tableColumn totalsRowDxfId="610" name="Date Testing Completed" id="4" dataDxfId="611"/>
<tableColumn totalsRowDxfId="608" name="Data Used" id="11" dataDxfId="609"/>
</tableColumns>
<tableStyleInfo name="TableStyleMedium9" showColumnStripes="0" showRowStripes="1" showLastColumn="0" showFirstColumn="0"/>
</table>
The exported table xml is:
-<table xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" totalsRowCellStyle="Normal" headerRowCellStyle="Normal" totalsRowBorderDxfId="3" headerRowBorderDxfId="1" totalsRowDxfId="2" headerRowDxfId="0" totalsRowCount="1" ref="A1:N5" displayName="Table2436784757" name="Table2436784757" id="56">
-<sortState ref="A1:N4">
<sortCondition ref="K1:K4"/>
<tableColumn totalsRowCellStyle="Normal" totalsRowDxfId="5" name="Test Name" id="1" dataCellStyle="Normal" dataDxfId="4"/>
<tableColumn totalsRowCellStyle="Normal" totalsRowDxfId="7" name="Assignee" id="12" dataCellStyle="Normal" dataDxfId="6"/>
<tableColumn totalsRowCellStyle="Normal" totalsRowDxfId="9" name="Automated?" id="10" dataCellStyle="Normal" dataDxfId="8"/>
<tableColumn totalsRowCellStyle="Normal" totalsRowDxfId="11" name="FV GDS Status" id="2" dataCellStyle="Normal" dataDxfId="10"/>
<tableColumn totalsRowCellStyle="Normal" totalsRowDxfId="13" name="# Validation or Functional Points" id="7" dataCellStyle="Normal" dataDxfId="12"/>
<tableColumn totalsRowCellStyle="Normal" totalsRowDxfId="15" name="# Validation or Functional Points Passed" id="8" dataCellStyle="Normal" dataDxfId="14"/>
<tableColumn totalsRowCellStyle="Normal" totalsRowDxfId="17" name="# Tot Reqs" id="5" dataCellStyle="Normal" dataDxfId="16"/>
<tableColumn totalsRowCellStyle="Normal" totalsRowDxfId="19" name="Reqs Passed" id="15" dataCellStyle="Normal" dataDxfId="18"/>
<tableColumn totalsRowCellStyle="Normal" totalsRowDxfId="21" name="Reqs Failed" id="16" dataCellStyle="Normal" dataDxfId="20"/>
<tableColumn totalsRowCellStyle="Normal" totalsRowDxfId="23" name="Reqs Not Tested" id="6" dataCellStyle="Normal" dataDxfId="22"/>
<tableColumn totalsRowCellStyle="Normal" totalsRowDxfId="25" name="Reqs#" id="9" dataCellStyle="Normal" dataDxfId="24"/>
<tableColumn totalsRowCellStyle="Normal" totalsRowDxfId="27" name="Notes" id="3" dataCellStyle="Normal" dataDxfId="26"/>
<tableColumn totalsRowCellStyle="Normal" totalsRowDxfId="29" name="Date Testing Completed" id="4" dataCellStyle="Normal" dataDxfId="28"/>
<tableColumn totalsRowCellStyle="Normal" totalsRowDxfId="31" name="Data Used" id="11" dataCellStyle="Normal" dataDxfId="30"/>
Any help would be appreciated.
Thanks!
Hi Kyle,
While I understand your concern about posting a live Excel file, I am going to need a complete sample file to test against to better understand the issue. Just copy your live file, and replace all the live data with a few rows of dummy data and verify that the dummy file has the same issue. We will need a file to work from.
Thanks,
Funnily enough it will not let me attach an xlsx file, so I changed the extension to zip. I've narrowed the problem down specifically to a cell having multiple lines, which is all the attached worksheet has in it.