Hi bbb208,
Based on the information you provide - "(e.g. 1, 5, 10...)", the columns you want to delete do not follow a regular interval, so you can get what you want by modifying the following simple LabTalk script.
The script loops through every single worksheet in your whole project and deletes the columns specified by their index in the "delete col(#);" LabTalk commands.
1) Make a copy of your project file for backup.
2) Open the Script Window.
3) From the Script Window Edit menu, set the execution to "None".
4) Copy and paste the below script into the window.
5) Add/remove/modify as many "delete col(#)" commands as you need. (Heed comments in script!!!)
6) From the Edit menu, set the execution to "LabTalk".
7) Select/highlight all the script and press the Enter key on your keyboard. The script will run.
// Loop through all worksheets in entire project
doc -e LB {
// Delete columns by column index (indices start at 1 from left to right)
// BUT, you MUST delete from highest index to lowest (delete from right to left)
delete col(10);
delete col(5);
delete col(1);
}
For more information abotu looping through obejcts in your project, see:
http://www.originlab.com/doc/LabTalk/guide/Looping-Over-objs#Looping_over_Workbooks_and_Worksheets
http://www.originlab.com/doc/LabTalk/ref/Document-cmd#-e_object_.7Bscript.7D.3B_Execute_the_given_script_for_all_objects
Delete columns in a project
Posted - 12/19/2014 : 6:22:19 PM
