Origin Version (Select Help-->About Origin): 7,5 Operating System: XP
Hey everyone..
I am having trouble with naming and labelling a worksheet column format.. I am typing all the information by hand which takes to long time.. Can you copy the wks column format to several worksheets..?
I am wondering is there an easier way?? (sure there is I just cant find it.. :-))
I am using a script on all the data in the individual worksheets but then I have to rename all the columns to the value I have speciefied in the script...
You may first want to look at how to create and use worksheet templates. You can set all properties of the columns in one of your typical worksheets, such as the col name, label, column format etc and then save all the setting by saving the worksheet as a template. Later you can create a new instance of the saved template either from the GUI or using LabTalk or Origin C and fill in new data etc.
You can also programmatically get the name, format etc of a column in one worksheet and then apply those properties to a column in another worksheet. Take a look at the Column class in Origin C and methods such as GetName, SetName, GetFormat, SetFormat etc for example.