Extract data from Microsoft Excel spreadsheet into Niagara Ax?
I have a potential customer who has an online software scheduling system that does the scheduling of office, rooms, gym, etc and is managed online. They want to conect this online scheduling system to the Jace so they don't need to double the entry of scheding rooms to control the HVAC. I contacted the vendor and they also host the database. With the permission of the customer the Jace can have access to the spreadsheet through an IP. Has anyone parsed a spreadsheet before? I can't find any documentation on the possible process. I'd like to extract time and occupancy status of a room.