ikramlc135:
how I want to read the value from the specific cell in excel?
I was plan to scan the barcode and send the bar ID into specific excel cell inside the SD card. For example...the ID show in cell F5. Then at cell F6 will show the S/N for that ID (using excel formula). I want the arduino to read the S/N inside cell (F6) and print out at LCD..
*i ve the list all barcode ID in comlumn A and S/N at column B
I ve try to search every where in internet and still not found the solution my problem.
Yes, this can be done in realtime which is what I believe you want. Excel is a rather complex program but the solution lies in VBA, the programming language of Excel. F6 is a formula that has a visual representation that is shown on the monitor via a buffer. So, VBA can be used to map F6 to another cell that can be used to actually have the digits. This can then be exported as a range to a disk file OR can be sent oner serial to the Arduino or even directly to a serial display.
The concepts are advanced and the implementation is Expert.
Ray