Jyotiranjandas Posted August 10, 2016 Share Posted August 10, 2016 Hello , I am trying to check the validation with open office spreadsheets . But its not working . Do I need to add any library file for the same. Or is it limited to microsoft excel only. Please answer as soon as possible. Link to comment Share on other sites More sharing options...
water Posted August 10, 2016 Share Posted August 10, 2016 (edited) Welcome to AutoIt and the forum! You are talking about something like _Excel_RangeValidate? Edited August 10, 2016 by water 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...
Jyotiranjandas Posted August 10, 2016 Author Share Posted August 10, 2016 yes but iam getting this error: Error creating a new Excel application object. @error = 1 , @extended = -2147221164 Link to comment Share on other sites More sharing options...
TheDcoder Posted August 10, 2016 Share Posted August 10, 2016 45 minutes ago, Jyotiranjandas said: Or is it limited to microsoft excel only. The default library only supports Microsoft Excel because it interacts with the Excel object interface provided by Microsoft. EasyCodeIt - A cross-platform AutoIt implementation - Fund the development! (GitHub will double your donations for a limited time) DcodingTheWeb Forum - Follow for updates and Join for discussion Link to comment Share on other sites More sharing options...
water Posted August 10, 2016 Share Posted August 10, 2016 Please check the wiki for Open Office UDFs: https://www.autoitscript.com/wiki/User_Defined_Functions 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...
Jyotiranjandas Posted August 10, 2016 Author Share Posted August 10, 2016 Thanks for the suggestions and help 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