No, that is not a remote access security limitation, AIR should not have it.
It is a Java FileNotFoundException - Java server code (on JBoss on Linux) has no knowledge
how to open Excel 2007 file on the client (my PC), like: C:\temp\somefile.xlsx
Or update or save file.
Any idea how to fix that ?
At the moment AS3XLS lib doesn't support Office 2007, but Java POI 3.5 does.
It looks like Flex doesn't support SOAP with Attachment : https://bugs.adobe.com/jira/browse/SDK-13381
so it might be impossible to pass XLSX binary file (i.e. zipped archive with 12 XML files and subdirs)
So that lives me with one of 2 choices:
- always install web server on local PC, maybe using embedded in AIR2 Tomcat (haven't tried that):
- maybe scrap Web Service and use Flash Remoting to connect to Java POI side.
I am not sure is it easy to upload (XLSX) file to the server for reading
and later download it back to the client PC for saving (as XLSX).
Can anyone suggest how to do that ? FileReference ? FileStream ?
Any other ideas ?
You wouldn't need to install a local web server for option one. In AIR 2 you could call a Java program directly using the new NativeProcess API.
FileReference is one way to upload and download files to/from a server. The URLLoader class should also work. You could even use sockets.