C# Import XML file into XLSX using OpenXML?

See more:

C#

XML

OpenXML

Hi Guys,

I have a program that creates xml files, I have to import these into XLSX spread sheets. I can do this using COM but when the xml file gets big (+50mb) it can up to an hour to open. I've done some looking around and I have found OpenXML - which is apparently faster.

I've had a play around and found what looks like it should work:

string fileName = @"xxx.xlsx";
SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Create(fileName, SpreadsheetDocumentType.Workbook);
WorkbookPart workbookpart = spreadsheetDocument.AddWorkbookPart();
workbookpart.Workbook = new Workbook();
WorksheetPart worksheetPart = workbookpart.AddNewPart<WorksheetPart>();
worksheetPart.Worksheet = new Worksheet(new SheetData());
Sheets sheets = spreadsheetDocument.WorkbookPart.Workbook.AppendChild<Sheets>(new Sheets());
Sheet sheet = new Sheet() { Id = spreadsheetDocument.WorkbookPart.GetIdOfPart(worksheetPart), SheetId = 1, Name = "mySheet1" };
XmlDocument xwb = new XmlDocument();
xwb.Load(@"Data.xml");
Stream wbStream = worksheetPart.GetStream();
xwb.Save(wbStream);
sheets.Append(sheet);
workbookpart.Workbook.Save();
spreadsheetDocument.Close();

has anyone had experience of using OpenXML?
any guidance would be great! :)

many thanks,

Phil