What if your operators could enter machine data on their phones and that data automatically appeared in a Microsoft^®Excel^®电子表格？

What if production or usage data from your spreadsheet was automatically updated in your supervisor's凹槽移动操作员界面？

Could be pretty handy, right?

好吧，我们有几个代码示例向您展示如何实现它。

一个非常简单和简单的；另一个更细节。两者都使用A凹槽Data Store和格鲁夫的RESTful API to move the data.

简单：记录凹槽data to Microsoft Excel

如果您只想从凹槽to Excel, this is the sample for you. Here's what you need:

• A凹槽AR1 Box或者凹槽服务器跑步凹槽R3.3 or higher
• Microsoft Excel 2007（或更高）

该示例包括一个获得和日志的Excel工作簿凹槽data, a凹槽project with a pre-built Data Store, and instructions.

To use this sample, you should already be familiar with凹槽. If you run across anything you don't understand, check the凹槽构建和查看用户指南求助。

更详细：分享凹槽data with Microsoft Excel

该样本在两个方向上移动数据时更为复杂。它在应用程序中使用Visual Basic^®（vba）读写凹槽通过RESTFUL API存储数据。对于任何想建立自己的人来说，这都是一个很好的例子自定义应用程序凹槽和Excel, because it explains the基础代码。

For this sample you'll need the same things as the simple sample:

• A凹槽AR1 Box或者凹槽服务器跑步凹槽R3.3 or higher
• Microsoft Excel 2007（或更高）

其中包括Excel工作簿和工作表。当您为您的地址和API键时格鲁夫，视觉基本代码将读取凹槽数据存储和填充下拉列表，因此您可以选择要使用的特定标签。

Instructions show you how to use the sample and its underlying code in your own applications.

查看所有代码样本

We're building a library of code samples to help with your applications. Be sure to check out the samples in these locations:

Opto 22开发人员网站- 代码样本：包括使用两者的样本凹槽和SNAP PAC controller RESTful APIs, and for using Node-RED with凹槽和Pacs. You'll also find Raspberry Pi samples (a Pi with ourindustrial digital I/O对于原型和不需要工业硬化设备的位置来说，可能是廉价的选择）。

OptoForum- 代码样本和提示: Here you'll find samples and tips for all Opto 22 products.