Good day guys. I want to create a an excel file on my SD card. Then I want to search for some things I'll saved inside the excel file in my SD card and display on LCD. Please how do I do that? Thanks

 

First, you learn how to program an Arduino.

Then you research and choose a shield that can take an SD card.

Next, you experiment with the sample programs that come with the shield's library

Then, you realize how much easier it is to save your file in CSV format with Excel.

If you get this far, let us know.

 

Here is a video that shows how to make a .txt file

AIDayley
also the examples in the library's are very useful

 

Good day guys. I want to create a an excel file on my SD card. Then I want to search for some things I'll saved inside the excel file in my SD card and display on LCD. Please how do I do that? Thanks

You should first start with reading a simple text file. That is going to be complicated enough.

You will find libraries for reading files from an SD card here using a micro-controller.

 

There is an arduino library for SD cards here: https://www.arduino.cc/en/Reference/SD

 

strtok is your friend or enemy.

Remember the first call to include the string pointer, other calls the string pointer is NULL. If of course Arduino implements a stdstr library, never really got into Arduino.

What does this do other than just confuse the TS?

 

I hope one is not projecting.

Tho he may want to read char by char and process the data that way, or he may want to delve into the current Excel format.

I have had enough of your nonsense. On my ignore list. Which is extremely rare for me to do around here.

 

an easier approach might be to port Windows and Office to the Arduino so you can run excel natively there.

 

Does it have to be a exel file? and what things are you searching for? how much experience do you have programing arduino.
AIDayley

 

an easier approach might be to port Windows and Office to the Arduino so you can run excel natively there.

If it is so easy, let us see you port Windows over to an 8-bit, 16MHZ CPU with 32kb.

 

View attachment 117260

You should be able to take bits and pieces from those 6 file plus a little be of searching on the internet for things that are not in there and be able to patch together a sketch that will work.
Best of luck AIDayley

 

an easier approach might be to port Windows and Office to the Arduino so you can run excel natively there.

I fear the implied sarcasm went over some heads.

Creating an excel file to hold some data on a micro is severe overkill. Try some simpler format that works with text files and the task will be solved.

 

This example sketch is a great base

/*
  SD card read/write

This example shows how to read and write data to and from an SD card file
The circuit:
* SD card attached to SPI bus as follows:
** MOSI - pin 11
** MISO - pin 12
** CLK - pin 13
** CS - pin 4

created   Nov 2010
by David A. Mellis
modified 9 Apr 2012
by Tom Igoe

This example code is in the public domain.

*/

#include <SPI.h>
#include <SD.h>

File myFile;

void setup() {
  // Open serial communications and wait for port to open:
  Serial.begin(9600);
  while (!Serial) {
    ; // wait for serial port to connect. Needed for native USB port only
  }


  Serial.print("Initializing SD card...");

  if (!SD.begin(4)) {
    Serial.println("initialization failed!");
    return;
  }
  Serial.println("initialization done.");

  // open the file. note that only one file can be open at a time,
  // so you have to close this one before opening another.
  myFile = SD.open("test.txt", FILE_WRITE);

  // if the file opened okay, write to it:
  if (myFile) {
    Serial.print("Writing to test.txt...");
    myFile.println("testing 1, 2, 3.");
    // close the file:
    myFile.close();
    Serial.println("done.");
  } else {
    // if the file didn't open, print an error:
    Serial.println("error opening test.txt");
  }

  // re-open the file for reading:
  myFile = SD.open("test.txt");
  if (myFile) {
    Serial.println("test.txt:");

    // read from the file until there's nothing else in it:
    while (myFile.available()) {
      Serial.write(myFile.read());
    }
    // close the file:
    myFile.close();
  } else {
    // if the file didn't open, print an error:
    Serial.println("error opening test.txt");
  }
}

void loop() {
  // nothing happens after setup
}

 

I would wait till the TS posts back before putting too much time into this. Low thread count means there is at least a chance TS won't be back.