Read a file in OfficeLive - from an Office AddIn

Question

We use the filename returned by the office app to read the file when generating a report. Word, Excel, & PowerPoint all have variations on this problem. Here is what occures with Excel:

1.       In OfficeLive the file is http://workspace.office.live.com/#davidwindward/Documents/DavidT - simple test.xlsx

1.       Requesting the file (1) above in a browser works!

2.       Requesting the file (1) above returns an XLSX file that appears to be some javascript.

2.       Application.ActiveWorkbook.FullName returns http://davidwindward.workspace.office.live.com/Docs/DavidT - simple test.xlsx

1.       Requesting the file (2) above returns an error 505 if pasted in a browser.

2.       Requesting the file (2) above in my C# code it returns an error 501 (not implemented).

Note: we want to be able to read not just the Office files (which are our report templates) but also XML files as data files.

---

Cubicle Wars - www.windwardreports.com/film.htm