Go Down

Topic: Retrieve value from spesific cell in excel..?? (Read 12172 times) previous topic - next topic

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.

PaulS

Quote
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.


robtillaart

Open office can read and write Excel files and is open source.

- http://sc.openoffice.org/excelfileformat.pdf

Microsoft has made the file format open
- http://download.microsoft.com/download/0/B/E/0BE8BDD7-E5E8-422A-ABFD-4342ED7AD886/Excel97-2007BinaryFileFormat(xls)Specification.xps -
You need an XPS reader for the latter

To have an Arduino extract one value will be quite a project.
Rob Tillaart

Nederlandse sectie - http://arduino.cc/forum/index.php/board,77.0.html -
(Please do not PM for private consultancy)

raschemmel

@OP,
This is PIE in the SKY crazy talk. Get real.
Come back down to earth. You must be high.

PaulWet

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.

Nick_Pyner


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.

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. 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.

Nick_Pyner

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.

raschemmel

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.

Nick_Pyner


I submit I am older that you are


If you are, you probably started with Fortran

raschemmel

#10
Apr 22, 2014, 05:57 am Last Edit: Apr 22, 2014, 06:05 am by raschemmel Reason: 1
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 ?

Nick_Pyner


I think it was a magnetic core or drum memory or  something , right ?


20 Mb Washing machine

raschemmel

Yeah ! Hey , wus up? How's it going ? Your still older than I am. (and you still know more than I do.... XD)

robtillaart


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...
Rob Tillaart

Nederlandse sectie - http://arduino.cc/forum/index.php/board,77.0.html -
(Please do not PM for private consultancy)

raschemmel

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?

Go Up