You can create and update Excel documents using the Apache POI Java library. I think formulas in the spreadsheet are fine but not VB. The newer Excel format (.xlsx) is XML.
JR On 11/4/13 3:43 PM, "prob...@macti.ca" <prob...@macti.ca> wrote: >The Excel file should communicate to the database by ODBC... Or try >Web Query (http://www.youtube.com/watch?v=q7SAqrUVHHw) > >> Hi .. >> I have a job coming up and wanted to know if anyone had any >>experience with interacting with Excel data spread-sheets over the >>net? >> >> The client has an internal spread-sheet that is edited and contains >>formulas for the creation of an order for items that are to be >>purchased. >> >> So I am building an iPhone app that will interact with a WO App, >>which I am building too, and then somehow with the excel sheet. >> >> Anyone have any knowledge of the best way to interact with the excel >>sheet. >> >> The Excel sheet needs to : >> >> 1. Be editable for the client in their office >> 2. Be accessible by the iPhone app through whatever means, XML, REST >>or HTTP etc.. and update the spread-sheet when an order is placedŠ >> >> Obviously concurrency an issue. >> >> I had thought about interacting with SQL server but I don¹t think >>that is excel file fronted. >> >> Any thoughts or direction to something else appreciated. >> >> Gino >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >> Help/Unsubscribe/Update your Subscription: >> >>https://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca >> >> This email sent to prob...@macti.ca > _______________________________________________ >Do not post admin requests to the list. They will be ignored. >Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >Help/Unsubscribe/Update your Subscription: >https://lists.apple.com/mailman/options/webobjects-dev/jr.ruggentaler%40ex >perian.com > >This email sent to jr.ruggenta...@experian.com _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com