layer.comments$

def wcm(a)->list:
    return a.splitlines()

py.wcm(layer.comments$)

run -pyf "WksComments.py"

py.wcm(layer.comments$)

quote:

---

Mismatch double quote: py.wcm(layer.comments$)
Failed to create operation for Book1_A@7 due to error in Set Column Value scripts

---

dlgfile multi:=1 group:=*.txt;
impasc fname$
Options.FirstMode:=0	//Import first dataset in workbook: replace existing worksheet
Options.Mode:=4 	//Import 2nd to nth workbook to new sheets       
Options.Sparklines:=2 	//Sparklines if there are over 50 data cells	
Options.Headers.CountHeaderLines:=1	//Confirm there are headers in the source data sets
Options.Headers.MainHeaderLines:=0	//Specify number of headers
Options.Headers.SubHeaderLines:=1	//Specify number of subheaders
Options.Headers.LongName:=1	//Set 1st subheader as long name
Options.Names.AutoNames:=0	//Do not rename workbooks automatically
Options.Names.FNameToColComm:=1	//Use file names in column comments  
Options.Names.FNameToSht:=1	//Use file names to rename worksheets
Options.Names.FNameToBk:=0 //Do not fill comments with file names 
Options.Names.FPathToComm:=0	//Do not fill comments with file path
Options.FileStruct.NumSep:=1	//Decimals are after a dot (90.25). For 90,25 write 1 instead
Options.FileStruct.Delimiter:=3;
	
doc -ef LW { //For all worksheets in folder

	wks.col=1; //Activate Column 1
	wks.insert(Smp); //Insert new column before Column 1
	col(A)[L]$ = "Sample"; //New column Long Name
	csetvalue col:=col(A) formula:="FnameFromCol$" s:="string FnameFromCol$ = Col(B)[C]$" r:=none; //Set adjacent column's comments as new column's cell values
	wks.deleteRows(2,300); //Delete all cell values except first one //Is there any way to specify rows 2 to end? Could not find any. wks.nrows does not allow to set less than 15.

	for (int nn = 2; nn <= wks.ncols; nn++) //For second column onwards
	{ 

		wcol(nn)[C]$=""; //Delete comments (undo impasc Options.Names.FNameToColComm:=1)

	}

}