I'm sure it is a case of "must" rather than "may want to" or at least it's the most sensible way. This is easy enough to do on a Commodore 64 and it can't be harder on an Arduino. All you need is the shape of the array and the location of the cell in question.
the Excel file in question could be converted to CSV prior to the using the arduino to extract the information. At least it doesn't sound as far fetched as the OP's question (that being extract the data from an Excel (non-CSV file).
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 BI ve try to search every where in internet and still not found the solution my problem.
The concepts are advanced and the implementation is Expert.
QuoteThe concepts are advanced and the implementation is Expert. That explains why I don't understand any of it... XD
... - or no purpose that can't be done with a CSV. I've heard it said that 99% of all the real work ever done in Excel can be done with a CSV file. I'm inclined to believe it.
That's fine but I think it's time review the original post which would imply that, not only would you need to know VBA, but also you need to teach Arduino VBA, so it can do the looking. And likely all for no purpose - or no purpose that can't be done with a CSV. I've heard it said that 99% of all the real work ever done in Excel can be done with a CSV file. I'm inclined to believe it.
CSV != CVS