• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1275
  • Last Modified:

Opening spreadsheet from AxSpreadsheet component

How do you open a spreasheet inside the AxMicrosoft.Office.Interop.Owc11.AxSpreasheet component?
0
craigdev
Asked:
craigdev
1 Solution
 
JeffvClaytonCommented:
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

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now