Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

In Excel, how do I store each data reading in a new cell?

April 26, 2017CELL Data Excel Reading store

0

10 Posted

In Excel, how do I store each data reading in a new cell?

2 Answers

0

Posted

This depends on whether you wish to analyse the data in Excel after collection has finished, or whether you need the data in Excel in “real-time”. In the first case you simply use Windmill Logger to save the data, then later open the data file in Excel. In the second you need to set up DDE data links using the DDE Panel, and then create an Excel macro to read and store the data. For full details open the DDE Panel Help file, wmdde.hlp, and see the “Example Excel Macro to Repeatedly Sample Data” topic. The information is also on our Excel web page.

0

Posted

This depends on whether you wish to analyse the data in Excel after collection has finished, or whether you need the data in Excel in “real-time”. In the first case you simply use Windmill Logger to save the data, then later open the data file in Excel. In the second you need to set up DDE data links using the DDE Panel, and then create an Excel macro to read and store the data. For full details open the DDE Panel Help file, wmdde.hlp, and see the “Example Excel Macro to Repeatedly Sample Data” topic. The information is also on our Connect to Excel pageData Logging with Excel page.