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.
I was plan to scan the barcode and send the bar ID into specific excel cell inside the SD card
Well, good luck with that. An Excel file is a binary file that only Excel can understand. Have you gone to Microsoft's site and downloaded the Excel for Arduino version. Let us know when you have.
Open office can read and write Excel files and is open source.
Microsoft has made the file format open
To have an Arduino extract one value will be quite a project.
@OP,
This is PIE in the SKY crazy talk. Get real.
Come back down to earth. You must be high.
What you ask is not possible.
However, you may want to look into saving your excel sheet into a comma delimited file, which makes it readable in Arduino as a text file. This make it possible to for example load it into an array and you could find & modify the correct cell & then write it back.
PaulWet:
What you ask is not possible.However, you may want to look into saving your excel sheet into a comma delimited file,
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.
Is the Commodore 64 a uC or is it a computer with an OS ? (I don't know so I' asking)
Does it have more memory than an arduino ? Can it run Excel (I haven't seen anyone do that with an arduino. So far I have not heard anyone mention csv files which are probably something an arduino could deal with and while it is not an "Excel" file perse
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.
If you don't know what a Commodore 64 is, you are too young to need to know.
A comma delimited file IS a csv file. CSV stands for comma separated values. Arduinos are routinely used to write CSV files so I'm sure they can be easily persuaded to read one, and I submit the OP's proposition is entirely reasonable.
I submit I am older that you are but never owned a commodore 64 and therefore know nothing about them because I did not own one. In 1982 when the Commodore 64 was at it's peak, I was trying to learn electronics at home , having been a restaurant cook for
12 years and trying to cross train into electronics. I spent all my time with Heathkit home study courses and had no time to play with computers. I did not even own a computer until 1984 and it was zenith pc.
Oh hey, I think we've had this conversation before ! You're the guy who still has a piece of an old computer in your garage. I think it was a magnetic core or drum memory or something , right ? Aren't you the guy who told me about Control-A to copy the compiler verbose output ?
raschemmel:
I think it was a magnetic core or drum memory or something , right ?
20 Mb Washing machine
Yeah ! Hey , wus up? How's it going ? Your still older than I am. (and you still know more than I do.... XD)
raschemmel:
Is the Commodore 64 a uC or is it a computer with an OS ? (I don't know so I' asking)
Does it have more memory than an arduino ? Can it run Excel (I haven't seen anyone do that with an arduino.
The commodore 64 is an home computer based around 6502 uProc (1 Mhz, 64KB RAM). It had dedicated (powerful) chips for sound and video and IO. Although popular in games there was a complete office suite (word-processing spreadsheet etc) Excel did not exist yet in those days but it had a ported version of visicalc (The mother of spreadsheets). Also other professional applications were written for the C64. It had also an expansion port with TTL level pins so you could extend it with your own electronics. Yes I have one in the loft collecting dust...
So it must have had an OS and the statement that if a Commodore could do it then an arduino should be able to is not valid, right?
If it did, it is barely relevant. Nobody talked about O/Ss much. You programmed it in 6502 machine code, or used the excellent Basic included, which is what you would typically do to manipulate serial files, and my statement is 101% valid. I no longer have my C64. I hardly played any games but they were such a good games machine I sold it for more than I thought I would in about 1992
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.
If you're referring to this statement then I think I was agreeing with you when I said this:
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).
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
The concepts are advanced and the implementation is Expert.
That explains why I don't understand any of it... XD
Nothing wrong with that. VBA beyond simple macros is a skill centric only to Microsoft Office fanboys (and fangirls.) But, when one is working with Office, VBA is pure magic.
Ray
