How to delete a large number of columns in excel powershell?

Question

PowerShell

I need to process incoming excel files. It is certainly known that they have 35 significant columns, no more (thousands of rows). But sometimes it is not clear how the generated files in which there are several hundred columns come. Accordingly, I want to delete all columns to the right of the 35th. Simple enumeration - works, but very, very long:

$wb = $Excel.Workbooks.Open($ExcelFile)
$ws = $wb.Worksheets.Item(1)
$used = $ws.usedRange
$lastrow = $used.SpecialCells(11).row
$lastcol = $used.SpecialCells(11).column
for ($i = $lastcol; $i -ge 35; $i--) {
  [void]$ws.Columns($i).Delete()
}

How can this be accelerated? I tried to make a Range and delete it already:

$allcol = $ws.Range($ws.Cells.Item(35, 1), $ws.Cells.Item($lastcol,$lastrow))
$allcol.Delete()

But the columns are not deleted for some reason. CHADNT? Maybe there is some other option? Thanks in advance

Answer 1

I got it like this:

$lastusedcolumn = $ws.Cells.item(1,($ws.columns.Count)).end(-4159).column
foreach ($item in ($lastusedcolumn..36)) {
    $item
    $ws.cells.item(1,$item).entirecolumn.delete()
    
}