My entire project relies on copy from Serial Monitor to Excel. As many have noted, can't copy from Serial Monitor in IDE 1.8.19
What is work-around?
? alternate IDE?
? alternate way to copy paste? (I use Ctrl+C in Windows)
? Screen scrape?
? output to other than Ser Mon?
? install downgrade IDE?
? somehow start / end / stop autoscroll / time the copy?
? run in Mac OS?
? Some kind of browser-based IDE?
Entire project is dead in water without getting output into Excel
If I want data from the serial monitor I use PuTTY, which can dump data straight into a text file as it receives it. Search for PuTTY and download it (be sure to get a genuine version).
I also think it is possible to get Excel to take input from a serial port directly, never tried it, don't know how to do it but maybe if you search you will find out.
Looks like PuTTY will solve two problems: getting data and putting directly into file instead of parsing with Excel functions. Is download from https://www.putty.org/ genuine?
Another option is to use non-app resources. Try using script to start file, read port, monitor traffic for EOT, format traffic, write file, close file.
[EDIT]
MSDOS calls it "batch" or "batch file"
Linux calls it "shell" or "shell script"
Excel will open a csv file so you make sure the data is comma separated, dump it in a text file then open with Excel. I can't remember how you tell Excel to start a new row, maybe CR, maybe NL, maybe ,, check the documentation or just experiment (or wait for someone here to tell you).
I think that's the genuine site for PuTTY, waiting for my expert friend to confirm.
But, I have several pages of output in Serial monitor right now, and I just did a ctrl-A and pasted it into a new text document with ctrl-c.
So I'm not sure why my version of 1.8.19 IDE is different from yours, but apparently it is.
The problem is likely related to trying to do it "livetime" as opposed to post-run. My bad. I didn't realize that's what you're up to. Ctrl-A is very limited in usefulness.
If you have a modern version of Excel. use the datastreamer facility.
Using the serial monitor is only for those who don't know what they are doing. Actually, I thought you can copy from the serial monitor, but why would anybody want to do that?
Hmm... the real-world (not office world) expects the impossible, and no-one cares if you deliver, only if you do not deliver. For this, CLI is best. No App-inside-App-on-OS-on-OS... just a blinky cursor, a port and a file.