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 bask talking virtually and edifice electronic circuits, projects and gadgets. To participate you need to annals. Registration is gratis. Click here to register at present.

• Welcome to our site! Electro Tech is an online community (with over 170,000 members) who enjoy talking nigh and edifice electronic circuits, projects and gadgets. To participate y'all need to annals. Registration is free. Click here to register now.

• Electronics Forums
• Electronic Projects Pattern/Ideas/Reviews

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

Injecting Live-data into an open excel spreadsheet?

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

Status

Non open for farther replies.

• #1

I take seen this done and want to know if I can go help with this.
I want to apply C++ to
- read an ARDUINO
- transport information to an open excel spread sheet such that as data changes in my ARDUINO I can send it to the excel sheet and the values on screen continue to update.
It would not be new information gets a new line, but a field of values updates so I can have a alive graph update for example equally thing change.

This thread is about sending information from c++ to an agile and open spreadsheet.

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

Is this advanced or easy ???

Suggestions and (+) comments welcome.

• #ii

Use the serial port and VBA ?

• #iii

I have washed something like this a few years ago.

I had a PIC running a small program written in assembler, the program read the ADC and wrote the digitised value to the UART every second or so.
The UART sent the data every bit 9600bps asynchronous data to an RS 232 serial interface.

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

For PLX-DAQ, look here:

JimB

• #iv

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

What if there is no more serial port, just Win 10 and USB? Apparently a much more than avant-garde Excel; 2016 IIRC.

Wanted to do something like that for years.

• #v

What if there is no more than series port, just Win 10 and USB?

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

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

JimB

• #6

As Pickbits said.... I take also used VBA to do this... Merely!! It only seems to work with EXEL and non of the alternatives... Also the "Scripting" has to exist unlocked..

• #7

I take washed something like this a few years ago.

I had a Picture running a small program written in assembler, the program read the ADC and wrote the digitised value to the UART every 2d or so.
The UART sent the data as 9600bps asynchronous data to an RS 232 serial interface.

In a laptop PC I had MS Excel (2003 !) which had an "add-in" called PLX-DAQ.
The PLX DAQ intercepted the data 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

Arrangement Requirements

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

I tin work within that
Merely going to proceed looking besides.

• #8

Can yous piece of work with VBA????

• #9

Tin yous piece of work with VBA????

I bet I could. I am going to beginning looking into it right at present, literally.
This page will still be open up...
So I will answer yes.

"If you can use the keyboard shortcut Alt + F11 to bring up the Visual Bones Editor within an Function Awarding, then it has VBA capabilities."

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

Final edited: May 10, 2020

• #10

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

I used information technology dorsum in the 1990s to do exactly what you are trying to do and I am certain it is yet part of excel. It uses some core MSwindows apppication-to-application information sharing in Windows. I think the new, less chancy version is now OLE but non nearly as like shooting fish in a barrel to use.

Updating data in a saved excel file is much easier because these are merely zipped sql files. The need to have a alive display of unsaved data in a spreadsheet and the subsequent chart is much more than hard because yous need to apply a Windows information exchange protocol.

• #eleven

Win7:
start EXCEL: ALT + F11 (opens VBA)
VIEW: F7 (lawmaking)
Paste :
(Re: Information from the serial port directly in Excel tabular array by Peter (guest)2007-03-thirteen 06:35)... gaggle volition translate from German language...

It accepts and colorizes the code, and then information technology'southward happy then far.
"cmnd $ = "Hullo world" " ... delete space from stringvariablename and $ ---> cmnd$ = "Hello globe" now it will compile
comment-out all com references and while/wend
then add: answer = "word" subsequently close#1, compile and single stride [F8], and it works.
"word" appears in excel cell 1,1

I did it

Last edited: May 10, 2020

• #12

So I read a picayune well-nigh certificates.

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

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

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

• #13

What source lawmaking are you referring to? Excel macro sheets can accept the code password protected and the user has to identify it as a "trusted" document.

Mike.

• #14

Not exactly what you are doing , still I fiddled around with an Esp32, and excel tin read information via the network into a chart using json, merely I never managed to get it to work automatically, information technology might be possible to exercise.

• #15

So I read a fiddling about certificates.

Looks like any code I write tin can only be released as source because my compiled code volition not work on whatsoever auto just mine.
So every laptop of mine I want to use my code on has to compile the lawmaking separately ?
Or practice I accept "all certificates" from this computer to utilize on each of my other computers?

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

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

No, you seem to exist speaking nonsense, you lot're making no sense at all.

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

• #16

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

This is i:

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

The single biggest limitation of a digital certificate, and 1 that many people find surprising, is that
--> you can only trust a document on the computer on which it 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 information technology.<--

This sounds very limited, merely it is the style that Microsoft intended for this organization to work. A digital certificate that you create yourself is intended for personal use merely. It allows y'all to create your own lawmaking, or await at someone else's, and when you lot're satisfied that it'south safety yous can point that by attaching your self-signed document."

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

Combined with the previous link of "you lot need to purchase a certificate, expert for a year".

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

My mistake.

Last edited: May 11, 2020

• #17

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, just download PLX-DAQ and try it.

JimB

Hola JimB

Excel 2016 here. The latest versions of PLX DAQ were rewritten specifically for Arduino. Would they be of whatever use to me working with PICs? Difficult to notice physical information in the Web.

Sincerely I am at lost hither. Thanks.

• #xviii

Hola JimB

Excel 2016 here. The latest versions of PLX DAQ were rewritten specifically for Arduino. Would they be of whatsoever use to me working with PICs? Difficult to notice physical information in the Web.

Sincerely I am at lost here. Thanks.

RS232 is RS232, makes no difference what the processor might be - I doubt information technology was rewritten 'for' Arduino, I suspect it was rewritten considering he wanted to use an Arduino with a modernistic computer, and the old version wouldn't work under a newer version of Windows.

• #19

RS232 is RS232, makes no difference what the processor might be - I doubt it was rewritten 'for' Arduino, I suspect it was rewritten because he wanted to use an Arduino with a modern estimator, and the old 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 mayhap.

• #20

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

Yous can endeavor and write your ain, just there is existing stuff out there. My Excel is a 2010 version running on Windows 10. I use both MS Information Streamer and Plex DAQ. No reason for me to write my own when what is bachelor works.

Ron

Status

Non open for further replies.

Like threads

• Electronics Forums
• Electronic Projects Design/Ideas/Reviews

• This site uses cookies to help personalise content, tailor your experience and to proceed you logged in if y'all annals.
  By continuing to use this site, you lot are consenting to our use of cookies.

How To Read Serial Port Data In Excel 2016,

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

Posted by: yokumobseer.blogspot.com

Share this post