Forum Discussion
Help with Excel Script
Hi, I'm using the below script to sort column F in my spreadsheet however, it doesn't extend to sort the rest of the cells. Therfore it's jumbled all the info. Can someone help please? function ...
That only sorts column A alphabetically and also moved my headers.
B_H33 Hmm, I wasn't expecting the current region to include columns to the left of F2.
What about this then:
function main(workbook: ExcelScript.Workbook) {
let selectedSheet = workbook.getActiveWorksheet();
// Sort the current region starting from cell A1 on selectedSheet
selectedSheet.getRange("A1").getSurroundingRegion().getSort().apply([{ key: 5, ascending: true }], undefined, true, ExcelScript.SortOrientation.rows);
}The "key: 5" bit in this code denotes the sixth column from the left (column F).
- I'm getting this error:
Line 4: RangeSort apply: You cannot perform the requested operation.
Doesn't appear to like A1B_H332200 I tested my script on a table like this and it works without error:
- Ok, I can see it works when the spreadsheet is unlocked.
I need to keep my spreadsheet locked - is there an addition to the code for this please?
Also, how can I run the automation on a timer?
Thanks,
Brooke
