Darfi Posted January 20, 2015 Share Posted January 20, 2015 (edited) Hello, I need to create short script for: - Import persons data( name, score) from XLS then I need sort this data to 2 fields related to score and name but ,.... in every from 2 fields must be in the final result approx same score in total count + name. Thank you for any idea Im totaly lost with this. Thank you(noob in AUTOIT) Edited January 20, 2015 by Darfi Link to comment Share on other sites More sharing options...
Jfish Posted January 20, 2015 Share Posted January 20, 2015 Check out _Excel_RangeRead in the help file. You can read the data into an array and sort it from there (_ArraySort). Then you can write it back to Excel or do whatever you want with it. Build your own poker game with AutoIt: pokerlogic.au3 | Learn To Program Using FREE Tools with AutoIt Link to comment Share on other sites More sharing options...
water Posted January 20, 2015 Share Posted January 20, 2015 Can't you get a sorted list from the source system? Which system creates the Excel workbook? My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now