Solved

Opening spreadsheet from AxSpreadsheet component

Posted on 2006-11-02
1
1,207 Views
Last Modified: 2012-06-21
How do you open a spreasheet inside the AxMicrosoft.Office.Interop.Owc11.AxSpreasheet component?
0
Comment
Question by:craigdev
1 Comment
 
LVL 3

Accepted Solution

by:
JeffvClayton earned 250 total points
ID: 17865160
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Exit the loop 4 49
Convert datetime to time string 10 28
Iteration Help (Asp.net VB) 5 24
MailAddress in vb 4 29
Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question