Open Worksheet of Excel File in URL

Question

I want to open a particular worksheet on a Excel file through URL. Googling suggested to use this format for the path "http://ags.mydomain.com/MyPMReports/Files/Doc33_HighwaySafety.xls#FreewayCrashRates"

Where Exce File name : Doc33_HighwaySafety.xls Worksheet inside it : FreewayCrashRates

But this doesn't seem to work.

Any help would be appreciated.

My application is in Flex + .NET

thanks, capton.

Answer 1

You can load the xls file using URLLoader as long as the file is in the same domain as your SWF or the server hosting it has a crossdomain.xml file that permits your domain to access it.

The #FreewayCrashRates syntax won't work for xls (in flex at least). You have to parse the xls with some converter (Google it) before you can use it.