billc Posted November 5, 2008 Share Posted November 5, 2008 Is there a way to export the channel property grid to an excel file? I want to add additional info for each channel for better organization.Bill Link to comment Share on other sites More sharing options...
iresq Posted November 5, 2008 Share Posted November 5, 2008 From a prior post by Reg Wertz:The LOR channel configuration file is an XML document (LOR II only). Newer versions of [highlight= rgb(255, 255, 136);]Excel[/highlight] can open this format. You just need to save a copy of your channel configuration, change the file extension from ".lcc" to “.xml”, and open it with [highlight= rgb(255, 255, 136);]Excel[/highlight].When I did this, the channel info was in columns K – P (you may need to scroll down near the last row to find the values).Don’t risk messing up an existing LOR file. Copy or save a separate file to do this. Link to comment Share on other sites More sharing options...
billc Posted November 5, 2008 Author Share Posted November 5, 2008 Thanks. I gave that a try but I still get a delimited file and I can't separate the data properly. I must not have the version of excel I need. Link to comment Share on other sites More sharing options...
iresq Posted November 5, 2008 Share Posted November 5, 2008 If you send it to me, I'll convert it for you.My email address is iresq at comcast dot net Link to comment Share on other sites More sharing options...
kevin Posted November 6, 2008 Share Posted November 6, 2008 I was able to get the info into Excel and do my changes, but when when I went to save it as an xml file. It told me that the XML maps in the workbook aren not exportable.I'm using LOR II and Excel 2007.Any clue as to what I'm doing wrong?thanks Link to comment Share on other sites More sharing options...
iresq Posted November 6, 2008 Share Posted November 6, 2008 Kevin, what are you trying to do? I don't think you can use excel as an xml editor. Link to comment Share on other sites More sharing options...
kevin Posted November 6, 2008 Share Posted November 6, 2008 I have alot of changes to my channel configuration and want to move some channels from one bord to another, and re arange the order of the controllers so it will be eaiser to do my sequencing.I am able to make changes in excel and save it but I'm not able to put it back into an XML format. I have been searching for an XML table editor but haven't found one yet that is easy like Excel is. Link to comment Share on other sites More sharing options...
bob Posted November 6, 2008 Share Posted November 6, 2008 I don't think it's a good idea to use Excel to edit sequence files.Yes, the sequence files are XML, and yes, Excel understands XML, but all this really means is that Excel understands the sequence files well enough to display their contents to you. It does not mean that Excel understands what the sequence files mean.If you directly edit the XML, using Excel or anything else, it is very easy to make a change which will render the file incomprehensible to Light-O-Rama. And even if LOR still comprehends it, it may "comprehend" it in a way that wasn't what you intended.Please be very, very careful if you do something like this. Make absolutely sure that you have an unmodified backup copy, and test everything about your sequence, not just the part that you meant to change. Link to comment Share on other sites More sharing options...
Recommended Posts