Aras Innovator – Export Excel Issue 匯出的Excel無法開啟

,

Aras Innovaor 11 SP5, SP12 (可能是所有版本但無法肯定), 匯出的.xls Excel檔無法使用LibreOffice 6.x開啟 (General input/output error).

該問題的原因為LibreOffice 無法解析該檔案(其為xml格式)的Style屬性, 故直接編輯或自己開發小程式移除即可。(下方為C#)

string filePath = "{target file path}";
XNamespace ss = "urn:schemas-microsoft-com:office:spreadsheet";
XDocument doc = XDocument.Load(filePath);
doc.Descendants().Attributes(ss + "StyleID").Remove();
XElement eWorkbook = doc.Element(ss + "Workbook");
XElement eStyles = eWorkbook.Element(ss + "Styles");
if (eStyles != null) eStyles.Remove();
doc.Save(filePath);

留言

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.