Move columns with excel office script

MarkPoechman 

Apparently there is a mistake in the code .

However, we can achieve the desired functionality by manipulating the table's columns array directly.

function main(workbook: ExcelScript.Workbook) {
  // Get the active worksheet
  let sheet = workbook.getActiveWorksheet();

  // Get the table
  let table = sheet.getTables()[0]; // Assuming there is only one table in the worksheet

  // Get the column indices for "Property Class" and "Property Description"
  let propertyClassIndex = table.getColumnByName("Property Class").getIndex();
  let propertyDescriptionIndex = table.getColumnByName("Property Description").getIndex();

  // Move "Property Class" column to position 0
  moveColumnToPosition(table, propertyClassIndex, 0);

  // Move "Property Description" column to position 1
  moveColumnToPosition(table, propertyDescriptionIndex, 1);
}

function moveColumnToPosition(table: ExcelScript.Table, columnIndex: number, newPosition: number) {
  // Remove the column from its current position
  let column = table.getColumns()[columnIndex];
  table.deleteColumn(column);

  // Insert the column at the new position
  let columns = table.getColumns();
  columns.splice(newPosition, 0, column);
}

This script defines a helper function moveColumnToPosition() to move a column to a specified position in the table. The main() function then uses this helper function to move the "Property Class" and "Property Description" columns to their desired positions.

Please try running this corrected script, and it should move the columns as intended.