Garry Posted November 12, 2009 Share Posted November 12, 2009 Is there anyway to take the Channel Property Grid and transfer/do a conversion it into a MS Excel? Link to comment Share on other sites More sharing options...
jimswinder Posted November 12, 2009 Share Posted November 12, 2009 I haven't tried it...but couldn't you "Copy" and then "Paste Special" using one of the "Texting" formats?Just highlight want you want to copy...hit "Ctrl C"...go into Excel "EDIT", down to "PASTE SPECIAL" and click on the "Paste As" "TEXT"...Might even be as simple as Copy and Paste... Link to comment Share on other sites More sharing options...
rwertz Posted November 12, 2009 Share Posted November 12, 2009 You can use Excel to extract a sortable copy of the channel configuration (This is how it works in Excel 2003) To avoid affecting any LOR files, export a new copy of your channel configuration. In Excel choose File / Open. Change Files of type to All Files. Open the configuration (.lcc) file. You may have to choose Open XML As an XML list. You may have to choose OK when told Excel will create a schema. Look for the columns labeled "unit" (or possibly /channels/channel/@unit) and "circuit" (or possibly "/channels/channel/@circuit"). Scroll down till you see info in theses columns. Copy the info to a fresh Excel workbook. Then you can sort, save, etc. Link to comment Share on other sites More sharing options...
ItsMeBobO Posted November 12, 2009 Share Posted November 12, 2009 Same topic in this thread.http://lightorama.mywowbb.com/view_topic.php?id=20327&forum_id=72&highlight=xml Link to comment Share on other sites More sharing options...
Garry Posted November 13, 2009 Author Share Posted November 13, 2009 Thanks you to all for the help and especially to http://www.t2lights.com/christmas/lorutility.html for their software, it was just what I needed. Garry Link to comment Share on other sites More sharing options...
Recommended Posts