Display worksheet data externally

[jimrward]

I have a large spreadsheet to run a sporting event with different categories which works fine. The participants nag me for prints every 15 mins which gets a bit tedious
I had this idea to display the relevant data from each category to an external monitor
Attached to the external monitor is a pc so the initial plan was to extract the data as xml or txt and using html and or php or xslt to render things nicely
I spent a while knocking up the code from various repositories only to find it wouldn’t display due to the moronic background blocking by edge of active X scripts and anything else that would be useful
I even tried edge in IE mode and still diddly
Short of retro machines running ie7 does anyone have any code that extracts a range from a worksheet to xml or txt and renders it to a webpage
I was hoping the php code would loop around looking for C1,c2,c3 etc for each category if found display, wait 20 secs, move on in the loop

 

[Jeffrey Mahoney]

I have displayed a live table onto another large TV / Monitor for a Pool league playoff. Select New Window from the View menu, navigate to the correct sheet, and drag it over to the other monitor. This allowed me to work on my laptop to do updates while the participants saw only the table I wanted them to see.

 

[jimrward]

I would need some long HDMI cables or some senders for that one
I have 100’s of barcodes to zap in and already split that off to another box and even that is blighted by Microsoft locking issues so having to break concentration to switch to another screen might break the flow of things
I was hoping the master pc could dump data out to a folder and have a slave unit read and render it