I am struggling with a code that is supposed to scan through the "hello" sheet and remove any columns where the top cell contains the letter B:
function main(workbook: ExcelScript.Workbook) {
let ws = workbook.getWorksheet("hello");
let usedrange = ws.getUsedRange(true);
let qtycol = usedrange.getColumnCount() - 1;
let values = usedrange.getValues();
for (let j = qtycol; j >= 0; j--) {
let command = values[1][j];
if (command == "B") {
usedrange.getColumn(j).delete(ExcelScript.DeleteShiftDirection.left);
}
}
}
Initially, this code worked fine on smaller files. However, as I started processing larger files, an error occurred:
Line 64: Range getColumn: Timeout
The problematic line seems to be related to the usedrange... instruction in line 64.
If anyone has suggestions for a more efficient approach or alternative solutions, I would greatly appreciate your feedback.
Thank you!