I'm not sure why placing the spreadsheet wouldn't be the way to go, but I don't really know how that is formatted. Does IT look like the listings you want?
If this is a once-off you might as well do all by hand.
If this is going to be a regular job (say, a weekly tv guide with a fixed layout), I'd personally export the data to XML and then use XSLT to properly pre-format everything.
Hi, No sadly the excel spread sheet is no where near the format we need. I'll try and attach what we are trying to do. There are two channels (that is the different color backgrounds. We have four channels in total (that is one more tab in the Excel spreadsheet). This is a monthly publication, so we will be doing this every month.
the sample posted by the OP looks to me to be an indesign table just formatted nicely. it appears to be formatted manually (appears to be table and cell styles in use, as well as many merged cells for progs that are longer than half an hour).
it's a tough question because it is unclear what the excel file looks like, how the data was originally prepared prior to excel (e.g. the scheduling dept), how much lead time there is to format raw data into this table type format.
I'm with peter on this. i'd bring the excel file into indesign and format the tables based on table styles. if the table won't import from excel, try saving the excel file as an earlier version of excel (e.g. excel 97).