I am looking for a way to open and populate a new sheet while population the sheet from a file.xml.
Any ideas?
Thanks
2
-
possible duplicate of declare/open excel file in vb.netKen White– Ken White2011-10-12 02:19:32 +00:00Commented Oct 12, 2011 at 2:19
-
@Ken White I am not opening a .xls or .xlsx workbook just a sheet that populates from a .XML file. I tried that with the .xml file and it didn't work.George– George2011-10-12 02:25:33 +00:00Commented Oct 12, 2011 at 2:25
Add a comment
|
2 Answers
- Include a reference to 'Microsoft.Office.Interop.Excel' in your project
- Then do something like this:
Imports Microsoft.Office.Interop.Excel
Public Class ReadExcel
Public Sub OpenDoc(ByVal Filename As String)
Dim excelApp As New Microsoft.Office.Interop.Excel.Application
excelApp.Workbooks.OpenXML(Filename)
' do something here...
End Sub
End Class
1 Comment
George
I tried this already and this opens a brand new workbook. Looking from something that will open a new sheet in the current active workbook.
In addition to what Derek Tomes has answered, you can specify the loading options for the openXML method.
- xlXmlLoadImportToList = 2
- xlXmlLoadMapXml = 3
- xlXmlLoadOpenXml = 1
- xlXmlLoadPromptUser = 0
You may use xlXmlLoadImportToList to open a new workbook with the xml data you want to load or you may use xlXmlLoadOpenXml to open the xml file itself in excel.
you can hide the alerts with the DisplayAlerts property set to false when loading your xml then just set it to true afterwards.
