How To Read Serial Port Data In Excel 2016

Welcome to our site!

Electro Tech is an online community (with over 170,000 members) who enjoy talking about and edifice electronic circuits, projects and gadgets. To participate yous demand to register. Registration is free. Click here to register now.

• Welcome to our site! Electro Tech is an online community (with over 170,000 members) who enjoy talking near and building electronic circuits, projects and gadgets. To participate you need to register. Registration is complimentary. Click hither to register at present.

• Forums
• Electronics Forums
• Electronic Projects Design/Ideas/Reviews

You are using an out of appointment browser. It may not display this or other websites correctly.
Yous should upgrade or apply an alternative browser.

Injecting Alive-data into an open excel spreadsheet?

• Thread starter Click-Here
• Showtime date May 10, 2020

Status

Not open for farther replies.

• #1

I have seen this done and want to know if I can get aid with this.
I desire to use C++ to
- read an ARDUINO
- ship data to an open excel spread sheet such that as data changes in my ARDUINO I tin transport information technology to the excel sheet and the values on screen continue to update.
It would non exist new data gets a new line, just a field of values updates so I can have a live graph update for example as matter alter.

This thread is most sending data from c++ to an agile and open spreadsheet.

I accept no idea how to inject alive data into excel, and since I am asking, can I read a field back out again and have my c++ "dispense it"?

Is this advanced or easy ???

Suggestions and (+) comments welcome.

• #ii

Utilise the series port and VBA ?

• #iii

I accept done something like this a few years ago.

I had a PIC running a modest plan written in assembler, the programme read the ADC and wrote the digitised value to the UART every second or and then.
The UART sent the data as 9600bps asynchronous data to an RS 232 series interface.

In a laptop PC I had MS Excel (2003 !) which had an "add together-in" chosen PLX-DAQ.
The PLX DAQ intercepted the data which appeared on a serial port and wrote it into a prison cell in the spreadsheet.
All in all it worked quite well.

For PLX-DAQ, await here:

JimB

• #four

Sorry click-here, non intending to derail this thread.

What if in that location is no more serial port, but Win 10 and USB? Plain a much more avant-garde Excel; 2016 IIRC.

Wanted to practice something similar that for years.

• #5

What if in that location is no more than serial port, just Win 10 and USB?

The laptop which I used did not have a conventional series port with a D9 connector, I used a USB to serial interface converter.

Win10 ?
I dont know, but download PLX-DAQ and try it.

JimB

• #6

As Pickbits said.... I accept likewise used VBA to practice this... BUT!! It merely seems to piece of work with EXEL and non of the alternatives... Also the "Scripting" has to be unlocked..

• #7

I have done something like this a few years ago.

I had a PIC running a small plan written in assembler, the program read the ADC and wrote the digitised value to the UART every 2nd or and then.
The UART sent the data as 9600bps asynchronous data to an RS 232 series interface.

In a laptop PC I had MS Excel (2003 !) which had an "add-in" called PLX-DAQ.
The PLX DAQ intercepted the information which appeared on a serial port and wrote it into a cell in the spreadsheet.
All in all it worked quite well.

For PLX-DAQ, look here:

JimB

System Requirements

• Microsoft Windows 98
• Microsoft Office/Excel 2000 to 2003
• May not work with newer software; no longer supported

I tin can work within that
But going to keep looking too.

• #8

Tin y'all piece of work with VBA????

• #9

Tin you work with VBA????

I bet I could. I am going to start looking into it right now, literally.
This page will all the same be open...
So I will answer yes.

"If you lot can use the keyboard shortcut Alt + F11 to bring upward the Visual Basic Editor within an Office Application, then it has VBA capabilities."

That works... I'm in !!!

Last edited: May 10, 2020

• #10

If your version of excel still had DDE (dynamic data exchange), information technology is super easy. However, lots of antivirus software tries to plough it off because of vulnerabilities in this former-school data exchange.

I used it back in the 1990s to do exactly what y'all are trying to do and I am certain it is nevertheless part of excel. It uses some core MSwindows apppication-to-application information sharing in Windows. I retrieve the new, less hazardous version is now OLE but not nearly equally easy to use.

Updating data in a saved excel file is much easier because these are only zipped sql files. The need to have a live display of unsaved data in a spreadsheet and the subsequent chart is much more than difficult because you lot demand to use a Windows data exchange protocol.

• #11

Win7:
start EXCEL: ALT + F11 (opens VBA)
VIEW: F7 (code)
Paste :
(Re: Data from the serial port straight in Excel table past Peter (invitee)2007-03-13 06:35)... gaggle will translate from German...

Information technology accepts and colorizes the code, so it's happy so far.
"cmnd $ = "How-do-you-do earth" " ... delete infinite from stringvariablename and $ ---> cmnd$ = "Hello world" now it will compile
annotate-out all com references and while/wend
then add: answer = "give-and-take" after close#ane, compile and single step [F8], and it works.
"word" appears in excel jail cell 1,1

I did it

Last edited: May 10, 2020

• #12

And then I read a little nigh certificates.

Looks like whatever lawmaking I write can only exist released as source because my compiled code will not work on any car but mine.
So every laptop of mine I want to apply my code on has to compile the code separately ?
Or do I accept "all certificates" from this computer to use on each of my other computers?

$474/year for signing to share compiled code.
Does my software stop working after a year, or can I merely not sign with that anymore?

Is C++ similar that as well???
Is this how everyone shares, past passing source and compiling themselves?

• #thirteen

What source code are you referring to? Excel macro sheets tin can have the code password protected and the user has to place information technology every bit a "trusted" certificate.

Mike.

• #xiv

Not exactly what yous are doing , even so I fiddled effectually with an Esp32, and excel can read information via the network into a nautical chart using json, simply I never managed to get it to work automatically, information technology might be possible to do.

• #xv

So I read a piffling about certificates.

Looks like any code I write tin can only be released as source because my compiled code will non work on any motorcar only mine.
So every laptop of mine I desire to apply my code on has to compile the code separately ?
Or do I accept "all certificates" from this computer to utilise on each of my other computers?

$474/yr for signing to share compiled lawmaking.
Does my software terminate working after a year, or can I only not sign with that anymore?

Is C++ similar that too???
Is this how everyone shares, past passing source and compiling themselves?

No, you seem to be speaking nonsense, y'all're making no sense at all.

No 'certificates' required, I've no thought at all what you're in about?.

• #16

I read many manufactures yesterday and sounds like I jumped the gun.

This is one:

But probably this one is what dislocated me:
"The Limitation of Digital Certificates

The unmarried biggest limitation of a digital certificate, and ane that many people find surprising, is that
--> yous tin can simply trust a certificate on the computer on which information technology was created. This means that if you send a file to someone else with your digital certificate attached they won't be able to trust it.<--

This sounds very limited, but it is the way that Microsoft intended for this system to piece of work. A digital certificate that you lot create yourself is intended for personal use only. It allows you to create your own code, or expect at someone else'south, and when you're satisfied that it'southward rubber yous can bespeak that by attaching your self-signed certificate."

I mis-interpreted this whole section, thinking if it can't exist trusted it won't run.

Combined with the previous link of "you need to buy a document, good for a year".

I idea information technology was a licence key required to release compiled code so it would work on machines other than the one you wrote it on.

My fault.

Terminal edited: May 11, 2020

• #17

The laptop which I used did not have a conventional serial port with a D9 connector, I used a USB to serial interface converter.

Win10 ?
I dont know, merely download PLX-DAQ and endeavor it.

JimB

Hola JimB

Excel 2016 hither. The latest versions of PLX DAQ were rewritten specifically for Arduino. Would they be of any utilize to me working with PICs? Difficult to find concrete data in the Web.

Sincerely I am at lost here. Thanks.

• #18

Hola JimB

Excel 2016 hither. The latest versions of PLX DAQ were rewritten specifically for Arduino. Would they be of whatever use to me working with PICs? Hard to discover concrete information in the Web.

Sincerely I am at lost here. Thanks.

RS232 is RS232, makes no departure what the processor might exist - I doubt it was rewritten 'for' Arduino, I suspect it was rewritten considering he wanted to employ an Arduino with a modern computer, and the old version wouldn't work under a newer version of Windows.

• #nineteen

RS232 is RS232, makes no departure what the processor might be - I doubt it was rewritten 'for' Arduino, I suspect it was rewritten because he wanted to apply an Arduino with a modern calculator, and the onetime version wouldn't work under a newer version of Windows.

The commands in the user guide, seem to be in native Arduino. I could be incorrect maybe.

• #20

A Google of Arduino to Excel will get you lot a few dozen hits on how to do information technology. Microsoft has an add together on for Excel called Microsoft Data Streamer which I use and similar. They want membership in Office 365 but I but ran the download (Windows ten) and it works fine. I also utilize the mentioned PLX-DAQ and it besides does fine.

Y'all can try and write your own, but there is existing stuff out there. My Excel is a 2010 version running on Windows ten. I apply both MS Data Streamer and Plex DAQ. No reason for me to write my own when what is available works.

Ron

Condition

Not open for farther replies.

Like threads

• Forums
• Electronics Forums
• Electronic Projects Pattern/Ideas/Reviews

• This site uses cookies to aid personalise content, tailor your feel and to keep you logged in if you lot register.
  By continuing to use this site, y'all are consenting to our utilise of cookies.

Source: https://www.electro-tech-online.com/threads/injecting-live-data-into-an-open-excel-spreadsheet.159103/

Posted by: ferrellclonew.blogspot.com

Share this post