VB NET Microsoft.Office.Interop open XML file as XML table

Question

I have a piece of code where I am opening an XML file from VB NET console app, than I Save As this file as XLSX file

Dim oxl As Excel.Application
Dim owbs As Excel.Workbooks
Dim owb As Excel.Workbook
Dim osheets As Excel.Worksheets
Dim osheet As Excel.Worksheet

oxl = CreateObject("Excel.Application")
oxl.DisplayAlerts = True
oxl.Visible = True
owb = oxl.Workbooks.Open(file)
Dim newfile As String = Replace(file, ".xml", ".xlsx")
owb.SaveAs(newfile)
owb.Close()
oxl.Quit()

When I manualy open Excel 365, then I choose "Open file", I choose an XML file, Excel ask me, if I want to open it as an XML table and if I choose yes, table has another format, is coloured and headers in table are correct. When I open XML from my code, table isn't coloured, nevermind, but I have wrong table headers. Is it possible somehow open XML file as XML table from oxl.Workbooks.Open(file)?

I couldn't find a solution to my problem anywhere.

Show the output you get and the desired output. It's unclear what you are asking — djv
– djv, Commented Sep 22 at 13:58
Is it possible somehow open XML file as XML table from oxl.Workbooks.Open(file) - by replacing it with oxl.Workbooks.OpenXML(file)? — GSerg
– GSerg, Commented Sep 22 at 14:06
@GSerg I tried oxl.Workbooks.OpenXML(file) with same results like oxl.Workbooks.Open(file) — Petr Šmejkal
– Petr Šmejkal, Commented Sep 23 at 7:07

Petr Šmejkal · Accepted Answer · 2025-09-23 08:04:16Z

0

Got it.

owb = oxl.Workbooks.OpenXML(file,, 2)

did the trick.

https://learn.microsoft.com/en-us/office/vba/api/excel.xlxmlloadoption

answered Sep 23 at 8:04

Petr Šmejkal

1

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VB NET Microsoft.Office.Interop open XML file as XML table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related