Dave,
?
To answer your question, I have an Excel spreadsheet listing about 600 cars with various information about them like type, road, number, etc. I'm using a barcode reader to identify a car ID as it rolls over a hump and send it to a Jython program. The program gets some car related information out of the spreadsheet such as car length and destination. Then it looks up the train and classification track assigned for that destination and throws turnouts to send the car to the right track.
?
Right now, using openpyxl, the program works outside of jmri to get the track I need, but it can't throw turnouts without being inside jmri.
?
It doesn't sound like openpyxl is compatible with jmri and Apache POI is way over my head.
?
I'm looking at using csv files, but manipulating a 600 record csv file sounds daunting. Or, I could instantiate a class of 600 cars in the Jython program which I was trying to avoid. I'm also rethinking my strategy as well.
?
Thanks to all,
Nick
?
