Opening spreadsheet from AxSpreadsheet component

How do you open a spreasheet inside the AxMicrosoft.Office.Interop.Owc11.AxSpreasheet component?
LVL 1
craigdevAsked:
Who is Participating?
 
JeffvClaytonConnect With a Mentor Commented:
As far as I know it has to be a spreadsheet saved as an xml file. Then to open you just enter:

 Ax1.XMLURL = "C:\MySpreadsheet.xml"


To Save

Ax1.Export(ExportPath, Microsoft.Office.Interop.Owc11.SheetExportActionEnum.ssExportActionNone, Microsoft.Office.Interop.Owc11.SheetExportFormat.ssExportXMLSpreadsheet)


ExportPath = say C:\MySpreadsheet.xml      
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.