Great thanks.. Does microsoft offer any type of Excel management software like a Excel Database Server that allows file management such as concurrency and multiuser environments? If something like that exists there might be some sort of API to hook into?
GIno On 4 Nov 2013, at 22:21, Ruggentaler, JR <[email protected]> wrote: > 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, "[email protected]" <[email protected]> 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 ([email protected]) >>> Help/Unsubscribe/Update your Subscription: >>> >>> https://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca >>> >>> This email sent to [email protected] >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list ([email protected]) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/jr.ruggentaler%40ex >> perian.com >> >> This email sent to [email protected] _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
