I am wanting to import some information into WL after I have worked on it in Excel. Is there an easy way to read (find multiple values) in .xls or .csv files using WL5?
Size:
Color:
The easiest way to read values in a .CSV file is, probably, creating an ASCII DataSet. I'm assuming it contains a Date field; otherwise it's not.
What kind of information is stored in the file; in other words, how is it formatted?
Size:
Color:
The information is multiple numeric fields that vary occasionally. So for a few days the data is the same, then it changes for a few more days.
Size:
Color:
So, there must be a "Date" field somewhere.
Try this method from Community.Components, it's specifically built for your kind of task:
FillSeriesFromFile
Size:
Color:
Thank you Eugene, that was a great pointer and the code does the job I need it to.
Size:
Color: