Pages: [1] 2 3   Go Down
Author Topic: Excel sheet With arduino UNO  (Read 4978 times)
0 Members and 2 Guests are viewing this topic.
Offline Offline
Jr. Member
**
Karma: 0
Posts: 88
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Can i save data from arduino board as Excel sheet or used  SD card to save data then put this SD card into computer to read data as Excel sheet
Logged

Scotland
Offline Offline
Edison Member
*
Karma: 26
Posts: 1325
Have you had your Arduino fix today?
View Profile
WWW
 Bigger Bigger  Smaller Smaller  Reset Reset

yes & yes
Logged

Drew.
http://www.uk-pcb.co.uk - My UK Based PCB Fab & Assembly Company
Design work undertaken
SMD & Thru-Hole assembly

Offline Offline
Edison Member
*
Karma: 48
Posts: 1636
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

You can write the data to a file on the SD as a Comma-Separated Values file. A CSV file can be read directly by Excel.

Pete
Logged

Offline Offline
Jr. Member
**
Karma: 0
Posts: 88
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

You can write the data to a file on the SD as a Comma-Separated Values file. A CSV file can be read directly by Excel.

Pete
can yo help me with some details because i don't dealing with this before  smiley
Logged

UK
Offline Offline
Shannon Member
****
Karma: 223
Posts: 12630
-
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

can yo help me with some details because i don't dealing with this before  smiley

Which part are you having trouble with?

Do you have an SD card?
Can you write a text file to it?
Can you google "comma separated variable"?
Logged

I only provide help via the forum - please do not contact me for private consultancy.

Offline Offline
Jr. Member
**
Karma: 0
Posts: 88
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Which part are you having trouble with?

Do you have an SD card?
Can you write a text file to it?
Can you google "comma separated variable"?

write text file to  SD card
Logged

Offline Offline
Edison Member
*
Karma: 48
Posts: 1636
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

I haven't been able to test this code but it does at least compile. It should create the file test.csv on an SD card, write three lines of data to the file and then close it. If it works, you can then just put the SD card in a PC and double-click on the file which should open the file in Excel.

Pete

Code:
#include <SD.h>
File myFile;
void setup()
{
  Serial.begin(9600);
  myFile = SD.open("test.csv", O_APPEND | O_WRITE);
  if(myFile) {
    myFile.println("1,2,3");
    myFile.println("101,322,8293");
    myFile.println("7012,3964,281");
    myFile.close();
  } else {
    Serial.println("Can't open test.csv on the SD card");
  }
}

void loop(void){}
Logged

Offline Offline
Jr. Member
**
Karma: 0
Posts: 88
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

I haven't been able to test this code but it does at least compile. It should create the file test.csv on an SD card, write three lines of data to the file and then close it. If it works, you can then just put the SD card in a PC and double-click on the file which should open the file in Excel.

Pete
i will try it  smiley-wink
Logged

Offline Offline
Jr. Member
**
Karma: 0
Posts: 88
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

can i use Breakout Board for microSD Transflash (https://www.sparkfun.com/products/544) to read and write on micro SD , i don't know if i need to add some component to be suitable to use it with SD Library in arduino-UNO and which pin i will connect to use it as SD card Shield
Logged

Offline Offline
Jr. Member
**
Karma: 0
Posts: 88
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

how i connect Breakout Board for microSD Transflash  (https://www.sparkfun.com/products/544)
with arduino uno
Logged

Offline Offline
Edison Member
*
Karma: 48
Posts: 1636
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

That one is not directly compatible with UNO because the UNO uses 5V and micro-SD cards use 3.3V. You would have to do a level conversion to make them compatible.
I use the Adafruit board which is a bit more expensive but handles the conversion.
https://www.adafruit.com/products/254

They are easy to wire up. They will use pins 10,11,12 and 13 on the UNO. And note that the SPI hardware requires Pin 13 which means it can't be used for the LED indicator.

Pete
Logged

Offline Offline
Jr. Member
**
Karma: 0
Posts: 88
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

That one is not directly compatible with UNO because the UNO uses 5V and micro-SD cards use 3.3V. You would have to do a level conversion to make them compatible.
I use the Adafruit board which is a bit more expensive but handles the conversion.
https://www.adafruit.com/products/254

They are easy to wire up. They will use pins 10,11,12 and 13 on the UNO. And note that the SPI hardware requires Pin 13 which means it can't be used for the LED indicator.

Pete

i try to find it in electronic stores in my country  but i can't get it  and it will take long time for shipping so can i add component or any thing to  Breakout Board for microSD Transflash to make it compatible with UNO board
Thanks for answer  smiley
Logged

Offline Offline
Jr. Member
**
Karma: 0
Posts: 50
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

These:
https://www.sparkfun.com/products/8745

will probably be what you need to use the board you have.

You seriously are better off using https://www.sparkfun.com/products/9802 though.

I use it extensively to log to a multiple csv files.
Logged

Offline Offline
Jr. Member
**
Karma: 0
Posts: 88
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

finally i used Breakout Board for microSD Transflash i connect
pin 13 to SCK
pin 12 to Do
pin 11 to DI
pin 4 to CS
CD is not connected
and it work good but i want to know is it safe method ?
Logged

Left Coast, CA (USA)
Offline Offline
Brattain Member
*****
Karma: 361
Posts: 17294
Measurement changes behavior
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

These:
https://www.sparkfun.com/products/8745

will probably be what you need to use the board you have.

You seriously are better off using https://www.sparkfun.com/products/9802 though.

I use it extensively to log to a multiple csv files.

And for just $5 more a microSC + real time clock shield which is almost always a need anyway for data logging.

http://www.adafruit.com/products/1141

Lefty
Logged

Pages: [1] 2 3   Go Up
Jump to: