Re: REST and Excel data
Re: REST and Excel data
- Subject: Re: REST and Excel data
- From: "Ruggentaler, JR" <email@hidden>
- Date: Mon, 04 Nov 2013 22:21:45 +0000
- Thread-topic: REST and Excel data
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