How to get data from csv or xls data with specific row and column code

Other Hardware Storage
1

Dear All,
Greetings,
I am a newbie to arduino
currently looking to retrieve data from xls file saved on sd card, into arduino for specific row and colum.
Can anyone guide me how to do it.
Thanks for help in advance.
16 columns, 17 rows
below is the sample table

Code1 Code2 Code3 Code4 Code5 Code6 Code7 Code8 Code9 Code10 Code11 Code12 Code13 Code14 Code15 Code16
Code A 21.0 19.0 12.5 7.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0
Code B 21.0 19.0 12.5 7.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0
Code C 21.0 19.0 12.5 7.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0
Code D 21.0 19.0 12.5 7.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0
Code E 21.0 18.0 12.5 7.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0
Code F 19.4 16.7 12.5 7.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0
Code G 17.8 15.6 11.8 7.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0
Code H 16.3 14.6 11.1 7.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0
Code I 15.1 13.8 10.5 7.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0
Code J 13.7 13.0 10.0 7.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0
Code K 13.7 10.9 9.0 7.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0
Code L 13.7 8.7 8.2 6.3 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0
Code M 13.7 7.1 7.3 5.8 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0
Code N 13.7 5.9 6.4 5.3 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0
Code O 13.7 5.0 5.5 4.9 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0
Code P 13.7 4.2 4.8 4.5 2.8 2.8 2.8 2.8 2.8 2.8 2.8 2.8 2.8 2.8 2.8 2.8
Code Q 13.7 3.6 4.1 4.2 2.8 2.8 2.8 2.8 2.8 2.8 2.8 2.8 2.8 2.8 2.8 2.8
2

Forget about reading an XLS file from an Arduino. CSV is easy, read x number of lines, then count commas in the indexed line.

What have you tried so far? Are you able to read files from the SD card?

3

Haven't tried anything... Was thinking to save data in eeprom but, rewriting eeprom is tedious than rewriting sdcard.
Moreover, I was unable to get any relevant code for reading from XLS.
Nothing much is available on CSV too

4

Seriously? Come on. Comma Separated Variables. There isn't much more to it than that. Export one and look at it.

Haven't tried anything

Then how do you know that you need help?

Moreover, I was unable to get any relevant code for reading from XLS.

Like I said...

5

Coz I asked primarily for XLS, CSV was secondary. But as you suggested CSV can be a good option. Pls share any link as I am a newbie. And unable to gets the ends.
Thanks :pray: or any specific keywords

6

What does that mean?

7

Unable to understand the codes, how it works, and how to count commas, so start and end.

8

Then you have skipped over valuable lessons in programming that you need to learn first.

But really you are looking too far ahead, if you have not even read files from an SD.

It's easy to find the end of a line, it's a special character, "line ending", "\n" in C.

9

Readings text line by line from text file is what I have done.
Now when it comes to converting them, and sperating via comma is something I am not able to understand.
If you could help would be great.

10

Then show us what you have done. Post the code, in code tags.

11

This is what I tried
Already mentioned that m not pro... So, would request you to pls not not to pinch if you can't guide. :pray:

12

I'm perfectly patient with newcomers who respect the forum guidelines and provide information up front so it doesn't have to be pried out of them like a patient in a dentists chair.

When people complain like you just did, I put them on my ignore list. So that's where you go, sorry nothing personal, I just don't like wasting my time.

Please read:

1 Like
13

Very true. Thnk you for your time.

14

If you want someone to write code for you, post on the Jobs and Paid Collaborations forum section.

Otherwise, spend some time with the guidelines linked above, and plan your next post carefully.

15

Willing to write my code...
Just looking for syntaxes. If someone can just guide. What are those syntaxes... Or any ref syntax

16

The "syntax" of a CSV file is ASCII data, text and/or numbers separated by commas.

There are countless examples on line showing you how to read ASCII data from a file on an SD card. Have you looked at any of them?

17

I tried looking them in forum too but I might have missed the keywords for searching.

18

Keep trying. You are bound to learn something.

19

Is this the same link which can help
This is all I wanted... Nothing much...
I can now do it.
I don't understand what went wrong in my dialect... Things in this post went worst

20

Forget that until you have actually examined the files in detail, using something like "notepad" or similar program that will not try to do formatting for you.
If you dare to look at a file directly from xcell, you will not see anything that looks like the data you see on a spreadsheet display. Always go with an exported CSV file.

1 Like