Re: REST and Excel data
Re: REST and Excel data
- Subject: Re: REST and Excel data
- From: Gino Pacitti <email@hidden>
- Date: Mon, 04 Nov 2013 22:55:24 +0000
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@hidden> 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@hidden" <email@hidden> 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@hidden)
>>> Help/Unsubscribe/Update your Subscription:
>>>
>>>
>>> This email sent to email@hidden
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list (email@hidden)
>> Help/Unsubscribe/Update your Subscription:
>> perian.com
>>
>> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden