如何将串行端口的实时数据导入Microsoft Excel [英] How to get live data from a serial port into Microsoft Excel

问题描述

我正在尝试获取此产品

https://www.sparkfun.com/products / 11636 [ ^ ]

与Microsoft Excel通信，输入插入的硬币的值。有人可以帮忙吗？非常感谢

I'm attempting to get this product
https://www.sparkfun.com/products/11636[^]
to communicate with Microsoft Excel, inputting the value of the coins inserted. Can anyone help please? many thanks

推荐答案

由于那些永远不会直接与Excel通信，你需要将问题分解为几个阶段 - 你知道，有点设计，改进，测试等



想想： -



1）一个程序和测试床，可以通信RELIABLY使用设备 - 将信息输出到控制台

- 在开始获取时考虑输出，以及如何表示



）一个程序，它接收信息的测试信息并从中创建一个excel电子表格

- 考虑然后使用（1）的输出作为输入，模拟它，测试它



3）考虑最终程序的操作特性 - 例如，如果您决定使用服务，请编写一个服务，在任务/延迟中执行预定义的工作单元循环



然后合并1,2,3 ....

Since thats never going to directly communicate with Excel, you'll need to break the problem down into stages - you know, a bit of design, refinement, test etc

Think about :-

1) A program and test-bed that communicates RELIABLY with the device - output the info to the console
- think about the output when you start getting it, and how it should be represented

2) A Program that takes a test feed of information and creates an excel spreadsheet from it
- think about then using the output from (1) as input, mock it up, test it

3) think about the operating characteristics of the final program - if you decide to use a service for example, write a service that does a predefined unit of work in a duty/delay cycle

then combine 1,2,3 ....

这篇关于如何将串行端口的实时数据导入Microsoft Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！