devi Posted August 18, 2011 Share Posted August 18, 2011 Hi, i have an excel file, how to import the excel file in my autoit script and result will be append at the end.can u help me script for this. Link to comment Share on other sites More sharing options...
hannes08 Posted August 18, 2011 Share Posted August 18, 2011 Hello devi, did you already take a look at the _Excel*() Functions in the helpfile? Especially you'll need _ExcelBookOpen(), _ExcelWriteCell(), _ExcelReadCell() or _ExcelReadSheetToArray() and _ExcelBookSave(). Regards,Hannes[spoiler]If you can't convince them, confuse them![/spoiler] Link to comment Share on other sites More sharing options...
devi Posted August 18, 2011 Author Share Posted August 18, 2011 in @Script dir we need to give where the .xls file is stored or we need to give other than that. iam unable to access that file i stored the file in "C:\folder\test.xls" how to import this excel file in autoit script. Link to comment Share on other sites More sharing options...
water Posted August 18, 2011 Share Posted August 18, 2011 As Hannes stated, have a look at the builtin _Excel* functions. Specify the path/filename of the excel file to open in _ExcelBookOpen. Details can be found in the AutoIt help file. 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