Pages: [1]   Go Down
Author Topic: Leonardo and Excel  (Read 1233 times)
0 Members and 1 Guest are viewing this topic.
Sweden
Offline Offline
Newbie
*
Karma: 0
Posts: 28
Arduino rocks
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Hi!

I just watched the video were Massimo presents the Leonardo Board and Im now in search for an example project that let you incorporate Arduino data directly into Excelsheets, as he states in the video. Any ideas? Examples?

In my project I would like LM 35 temperature data to be logged into Excel as a first test.I have tried CSV files and SD cards before but now I want to logg data and graph it live as data streams into Excel.

Suggestions?
Logged

Seattle, WA USA
Offline Offline
Brattain Member
*****
Karma: 614
Posts: 49372
Seattle, WA USA
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Quote
Suggestions?
Ask Massimo what he was thinking?

Use GoBetwino?
Logged

0
Offline Offline
Newbie
*
Karma: 0
Posts: 28
blink. blink. blink. blink. blink.
View Profile
WWW
 Bigger Bigger  Smaller Smaller  Reset Reset

I think he meant having the Leonardo "type" directly into fields in Excel.  Something like this (assumes you start with a fresh Excel sheet in cell A1):
Code:
void setup()  {
  delay(5000);
 
  Keyboard.print("A1 text");
  Keyboard.write(KEY_TAB); 
  Keyboard.print("B1 text");
  Keyboard.write(KEY_DOWN_ARROW);
  Keyboard.print("B2 text");
  Keyboard.write(KEY_RETURN);
}

void loop() {

}
Logged

Sweden
Offline Offline
Newbie
*
Karma: 0
Posts: 28
Arduino rocks
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Hmm...

I tried Gobetwino ages ago, didn't work then but haven't tried later. The example by zeveland might do the trick but I think I send the question to Massimo( "An lazy example code"- let the arduino type in its own datavalues)

Logged

Offline Offline
Newbie
*
Karma: 0
Posts: 10
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Have you tried PLX-DAQ? It worked pretty well for me.
Logged

Manchester (England England)
Offline Offline
Brattain Member
*****
Karma: 626
Posts: 34207
Solder is electric glue
View Profile
WWW
 Bigger Bigger  Smaller Smaller  Reset Reset

Quote
I think he meant having the Leonardo "type" directly into fields in Excel.
Yes he did.
Quote
The example by zeveland might do the trick
It will only you need to use real values based on the input of sensors.
Logged

Sweden
Offline Offline
Newbie
*
Karma: 0
Posts: 28
Arduino rocks
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

The answer from Massimo:

"I don't have code ready to share about it but if you create a loop that reads all the analog inputs, Print them using Keyboard.print and after each number use Keyboard.press to generate a TAB key. once you reach the last number you can "press" enter and the cursor will go to the next row back to the first cell..
I works with google spreadsheet.

m

"
I haven't tried it yet...
Logged

Pages: [1]   Go Up
Jump to: