Hi,
I'm doing a Database in matlab where I put alot of information regarding specific Components that a Company uses in various units. I'm listing different stuff such as the material of the Component, the Surface treatment (if any) and how well the Component is resistant to different fluids & fungus.
I've been doing the Database as a function that we can call ''list''. Within this function there are if-loops where each if-loop represents each Component and is searched through its article number. So lets say that an if loop is of Component ''XXXX'' and contains information regarding this Component. To search for the Component in the database, you enter list('XXXX') into the command window and it spits out all the information from the if-loop.
This can be done for various Components at once by entering list('XXXX','XXX1','XXX2','XXX3') as an example and so on..
So finally to my question. If I have an excel file with various Components represented through their article numbers in a column, is there a way to convert it into matlab?
For example: The column in excel consists of Components XXXX, YYYY and ZZZZ. Is there a way to convert it into matlab in such way that I can search for them as list('XXXX','YYYY','ZZZZ') in the command window?
Would be very helpful especially because some excel-files consists hundreds of Components. Not ideal if I have to manually write them.
Any help is appriciated! :)
