Script Column Width not Adjusting

[R1chard]

I recorded a script, to adjust column widths. But When I run the macro, the column widths are not adjusted correctly. What is wrong with my script?

function main(workbook: ExcelScript.Workbook) {
let selectedSheet = workbook.getActiveWorksheet();
// Insert at range 1:1 on selectedSheet, move existing cells down
selectedSheet.getRange("1:1").insert(ExcelScript.InsertShiftDirection.down);
// Insert at range 1:1 on selectedSheet, move existing cells down
selectedSheet.getRange("1:1").insert(ExcelScript.InsertShiftDirection.down);
// Insert at range 1:1 on selectedSheet, move existing cells down
selectedSheet.getRange("1:1").insert(ExcelScript.InsertShiftDirection.down);
// Insert at range 1:1 on selectedSheet, move existing cells down
selectedSheet.getRange("1:1").insert(ExcelScript.InsertShiftDirection.down);
// Insert at range 1:1 on selectedSheet, move existing cells down
selectedSheet.getRange("1:1").insert(ExcelScript.InsertShiftDirection.down);
// Insert at range 1:1 on selectedSheet, move existing cells down
selectedSheet.getRange("1:1").insert(ExcelScript.InsertShiftDirection.down);
// Clear ExcelScript.ClearApplyTo.contents from range 1:7 on selectedSheet
selectedSheet.getRange("1:7").clear(ExcelScript.ClearApplyTo.contents);
// Set height of row(s) at range 1:7 on selectedSheet to 30
selectedSheet.getRange("1:7").getFormat().setRowHeight(30);
// Set width of column(s) at range A:B on selectedSheet to 12
selectedSheet.getRange("A:B").getFormat().setColumnWidth(12);
// Set width of column(s) at range C:C on selectedSheet to 65
selectedSheet.getRange("C:C").getFormat().setColumnWidth(65);
// Auto fit the columns of range E:E on selectedSheet
selectedSheet.getRange("E:E").getFormat().autofitColumns();
// Set width of column(s) at range I:J on selectedSheet to 18
selectedSheet.getRange("I:J").getFormat().setColumnWidth(18);
// Delete range K:U on selectedSheet
selectedSheet.getRange("K:U").delete(ExcelScript.DeleteShiftDirection.left);
// Delete range D:D on selectedSheet
selectedSheet.getRange("D:D").delete(ExcelScript.DeleteShiftDirection.left);
// Delete range E:G on selectedSheet
selectedSheet.getRange("E:G").delete(ExcelScript.DeleteShiftDirection.left);
// Set range D9:F9 on selectedSheet
selectedSheet.getRange("D9:F9").setValues([["VPPS","SDC","FSU"]]);
}

 

[ExcelToDAX]

which column(s) specifically aren't being adjusted? I tried this code and it works on my end.

 

[R1chard]

which column(s) specifically aren't being adjusted? I tried this code and it works on my end.

Example:

Starting Column A Width: 8.09 (96 Pixels)
Run Script
Finish Column A Width: 1.55 (24 Pixels)

Everything in the script works fine, except for the column width adjustments. Its makes all column widths really small, and not what it says in the script

Before

After

 

[ExcelToDAX]

This is because in your code you are setting columns A and B to 12 pixels

selectedSheet.getRange("A:B").getFormat().setColumnWidth(12);

If you want this to be 12 units (what Excel normally uses), you can change your code to this:

selectedSheet.getRange("A:B").getFormat().setColumnWidth(66.75);

 

[R1chard]

This is because in your code you are setting columns A and B to 12 pixels

selectedSheet.getRange("A:B").getFormat().setColumnWidth(12);

If you want this to be 12 units (what Excel normally uses), you can change your code to this:

selectedSheet.getRange("A:B").getFormat().setColumnWidth(66.75);

When I changed the number to your value, it worked fine. Thanks

I didn't write this macro, I just recorded my actions, and adjusted my column width, and it entered the values on the script automatically. Is there a setting I should change? Because I don't know what value to change all my other widths to

 

[ExcelToDAX]

I recorded the macro to give you the updated number. I manually right-clicked the columns and changed it to 12 units and the macro gave me that 66.75. How did you change it when you were recording the macro?