My PS script is taking a .csv file and creating a excel .xlsx spreadsheet. I want to sort a particular column so the number come out in descending order.. I tried several changes to the sort code and still getting the error. Unable to get the Sort property of the Range class At H:\GoogleAnalytics\…

Please can you edit your post and use the </> button to format your code. This will make it much more readable and enable us to copy and paste for testing. [image] Welcome to the new PowerShell Forums Website & Forum Feedback How to format code in PowerShell.org forums. …

This will open the .csv file from above and write it out as an Excel Spreadsheet Write-Host “Begin converting the .csv report file to an Excel .XLSX Spreadsheet” $csv = “H:/GoogleAnalytics/reports/”+$reportname+“webstats”+$datetime+".csv" #Location of the source file $xlsx = “H:/GoogleAnalytics/repo…

That’s not much better, now you’ve got code mixed with your comments. Everyone here gives up their free time to help answer queries. Please help us by taking a few minutes to format your posts properly. What, exactly, are you trying to sort? In your code you’re calling the Sort method on $ObjRan…

Thanks for your help. After replacing your 2 statements the column in the original order. I want the column to be in descending order. Write-Host "Begin converting the .csv report file to an Excel .XLSX Spreadsheet" $reportname = "baseball" $csv = "H:/GoogleAnalytics/baseball.csv" $xlsx = "H:/…

Sorry, missed that. You just need to specify a value for the sort order: [image] XlSortOrder enumeration (Excel) Office VBA reference topic $myRange.Sort($myRange,2)

Thanks Matt. I added the XISortOrder number 2 for descending… The column still comes out in the order of the .csv file. I created this simple 2 column .csv file. Column A has a team name, column B has a 3 digit number. There are only 7 rows… Do you have any idea why the sort is not working?

Are you adding the data to the sheet after you apply the sort? It appears that way from your script. You should populate the data, then define the range where the data occurs, then sort. Edit: Incidently, the code I gave only sorts 1 column. If the value in column B is associated with the value…

Trying to sort a excel column

PowerShell Help

matt-bloomfield March 30, 2022, 2:51pm 2

Please can you edit your post and use the </> button to format your code. This will make it much more readable and enable us to copy and paste for testing.

Topic		Replies	Views
Reading from Excel and Exporting to CSV? PowerShell Help	0	419	December 31, 2011
Sort-Object problems with Excel Value2 PowerShell Help	0	266	December 31, 2011
Help needed for working with csv file in powershell PowerShell Help	4	181	August 25, 2018
Sorting Table, Results Not As Expected PowerShell Help	0	258	December 31, 2011
Import csv file and resort last column than export to different filename.csv PowerShell Help	7	502	September 16, 2021

Trying to sort a excel column

Related topics