Converting Excel XML-Spreadsheet into xlsx

Question

i have got a XML-Excel file (SpreadsheetML format):

<?xml version="1.0" encoding="utf-8"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-    microsoft-com:office:excel"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
 <Company>My Company</Company>
 </DocumentProperties>
 <Styles>
 <Style ss:ID="Default" ss:Name="Normal">
 <Alignment ss:Vertical="Bottom"/>
 <Borders/>
 <Font/>
 <Interior/>
 <NumberFormat/>
 <Protection/>
 </Style>
 <Style ss:ID="stTxt">
<Font ss:FontName="Arial" ss:Size="8"/>
<Alignment ss:Horizontal="Left"/>
<NumberFormat ss:Format="@"/>
 </Style>
<Style ss:ID="stTopHeadline">
<Font ss:FontName="Arial" ss:Size="8" />
<Alignment ss:Horizontal="Left"/>
<NumberFormat ss:Format="@"/>
 </Style>
...

Now i need to convert those files into XLSX-Files with C#. Is there a way with Open Xml or other libraries to convert it into Excel 2010 XLSX format?

score 0 · Answer 1 · answered Jan 15 '17 at 10:19

0

What you got is called the Flat OPC format. Here is an article about converting it to the regular Open XML format.

answered Jan 15 '17 at 10:19

Marek Dzikiewicz

2,844
1
22
24

In Flat OPC you got tags like this: `` SpreadsheetML is different: [link](https://de.wikipedia.org/wiki/SpreadsheetML) – Saftpresse99 Jan 27 '17 at 13:39
@Saftpresse99 The SpreadsheetML is contained inside the package. – Marek Dzikiewicz Jan 27 '17 at 14:38
The sample code in the article cannot convert SpreadsheetML into a package. Because namespaces and attributes are different. – Saftpresse99 Jan 31 '17 at 13:37

score 0 · Answer 2 · answered Jun 25 '19 at 18:30

Here is an easy example how to convert it with Python and an installed Excel. Prerequisite: Microsoft Excel must be installed on the computer!

import os
from win32com.client import Dispatch

def convert_xls_to_xlsx(oldName:str, newName:str):
    oldName = os.path.abspath(oldName)
    newName = os.path.abspath(newName)
    xlApp = Dispatch("Excel.Application")
    wb = xlApp.Workbooks.Open(oldName)
    wb.SaveAs(newName,51)
    wb.Close(True)

Converting Excel XML-Spreadsheet into xlsx

2 Answers2