converts CSV mileage report from TripLog to Excel for our office manager

Convert-Mileage.ps1

param (
    [string]$inputFilename = $args[0]
)

Copy-Item -Path $inputFilename -Destination "$inputFilename.bak"

$lineNumber = ( Select-String "$inputFilename" -Pattern "Locations" | Select-Object -ExpandProperty LineNumber ) - 3
$fileContent = ( Get-Content $inputFilename )[0..$lineNumber]

$fileContent | Skip-Object -Index (0..20) > $inputFilename

$newCsv = Import-Csv $inputFilename -Delimiter ',' | 
	Select-Object 'Date',@{Name='Begin';Expression={$_.'Beginning Odometer'}},@{Name='End';Expression={$_.'Ending Odometer'}},`
	@{Name='Mileage';Expression={$_.'Mileage (mi)'}},@{Name='Customer';Expression={$_.'Tags'}}

$total = ($newCsv | Measure-Object 'Mileage' -Sum).Sum
$newRow = New-Object PSObject -Property @{Mileage="$total";End="Total"}
$newCsv | Export-Csv $inputFilename
Export-Csv $inputFilename -InputObject $newRow -Append -Force

$outputPath = "C:\Users\jeff\Downloads\"
$monthName = (Get-Date).AddMonths(-1).ToString("MMMM")
$outputFilename = "$monthName Mileage.xlsx"
$fullOutputPath = "$outputPath$outputFilename"

$newCsv = Import-Csv $inputFilename -Delimiter ','
$newCsv | Export-XLSX -Path $fullOutputPath -AutoFit -WorksheetName "$monthName Mileage"
$excel = New-Excel -Path $fullOutputPath
$totalCell = Search-CellValue -Excel $excel { $_ -eq "Total" }

$excel | Get-Worksheet | Format-Cell -Header -Bold $true
$excel | Get-Worksheet | Format-Cell -StartRow $totalCell.Row -StartColumn $totalCell.Column -EndRow $totalCell.Row -EndColumn ($totalCell.Column + 1) -Bold $true -Underline $true
#$excel | Get-Worksheet | Format-Cell -StartRow 2 -StartColumn 1 -NumberFormat "Datetime"
#$excel | Get-Worksheet | Format-Cell -StartRow 2 -StartColumn 2 -EndRow ($totalCell.Row - 1) -EndColumn ($totalCell.Column + 1) -NumberFormat "single"
#$excel | Get-Worksheet | Format-Cell -StartRow $totalCell.Row -StartColumn ($totalCell.Column + 1) -NumberFormat "decimal"
$excel | Close-Excel -Save