User Defined Functions: Difference between revisions

From AutoIt Wiki
Jump to navigation Jump to search
(Added LibreOffice Writer)
(Add the xlsxNative UDF)
Line 156: Line 156:
* [https://www.autoitscript.com/forum/index.php?showtopic=197909 CSV (by seangriffin)] - Manipulate CSV files using SQLite.
* [https://www.autoitscript.com/forum/index.php?showtopic=197909 CSV (by seangriffin)] - Manipulate CSV files using SQLite.
* [https://www.autoitscript.com/forum/index.php?showtopic=155748 CSVSplit (by czardas)] - Convert to and from CSV format.
* [https://www.autoitscript.com/forum/index.php?showtopic=155748 CSVSplit (by czardas)] - Convert to and from CSV format.
* [https://www.autoitscript.com/forum/index.php?showtopic=119238 Excel file generation UDF (by jerome)] - Excel file generation (multi-sheet workbook) without the need to have Excel installed.
* [https://www.autoitscript.com/forum/index.php?showtopic=119238 Excel file generation (by jerome)] - Excel file generation (multi-sheet workbook) without the need to have Excel installed.
* [https://www.autoitscript.com/forum/index.php?showtopic=143866 Excel XML UDF (by FireFox)] - Work with SpreadsheetML (Open XML file formats).
* [https://www.autoitscript.com/forum/index.php?showtopic=143866 Excel XML (by FireFox)] - Work with SpreadsheetML (Open XML file formats).
* [https://www.autoitscript.com/forum/index.php?showtopic=155905 EXml (by jdelaney)] - Create Excel file (SpreadsheetML) through "Microsoft.XMLDOM".
* [https://www.autoitscript.com/forum/index.php?showtopic=155905 EXml (by jdelaney)] - Create Excel file (SpreadsheetML) through "Microsoft.XMLDOM".
* [https://www.autoitscript.com/forum/index.php?showtopic=116072 EzMySql (by Yoriz)] - Use MySQL Databases with AutoIt.
* [https://www.autoitscript.com/forum/index.php?showtopic=116072 EzMySql (by Yoriz)] - Use MySQL Databases with AutoIt.
* [https://www.autoitscript.com/forum/index.php?showtopic=148232 _FileGetProperty (by BrewManNH)] - Retrieve properties of a file.
* [https://www.autoitscript.com/forum/index.php?showtopic=148232 _FileGetProperty (by BrewManNH)] - Retrieve properties of a file.
* [https://www.autoitscript.com/forum/index.php?showtopic=94920 FireBird (by eltorro)] - FireBird, Interbase DLL UDF.
* [https://www.autoitscript.com/forum/index.php?showtopic=94920 FireBird (by eltorro)] - FireBird, Interbase DLL.
* [https://www.autoitscript.com/forum/index.php?showtopic=197421 jq (by TheXman)] - Brings the power and flexibility of jq (an open-source command-line based JSON processor) to AutoIt.
* [https://www.autoitscript.com/forum/index.php?showtopic=197421 jq (by TheXman)] - Brings the power and flexibility of jq (an open-source command-line based JSON processor) to AutoIt.
* [https://www.autoitscript.com/forum/index.php?showtopic=209502 JSON (by AspirinJunkie)] - Interacting with JSON data in AutoIt.
* [https://www.autoitscript.com/forum/index.php?showtopic=209502 JSON (by AspirinJunkie)] - Interacting with JSON data in AutoIt.
Line 167: Line 167:
* [https://www.autoitscript.com/forum/index.php?showtopic=148114 JSON (by Ward)] - JSMN - A Non-Strict JSON UDF.
* [https://www.autoitscript.com/forum/index.php?showtopic=148114 JSON (by Ward)] - JSMN - A Non-Strict JSON UDF.
* [https://www.autoitscript.com/forum/index.php?showtopic=156794 JSON (by ozmike)] - Bridge to Native Windows JSON plus OO extension for AutoIt.
* [https://www.autoitscript.com/forum/index.php?showtopic=156794 JSON (by ozmike)] - Bridge to Native Windows JSON plus OO extension for AutoIt.
* [https://www.autoitscript.com/forum/index.php?showtopic=173797 JSONgen: JSON generator (by Jefrey)] - UDF to generate JSON.
* [https://www.autoitscript.com/forum/index.php?showtopic=173797 JSONgen: JSON generator (by Jefrey)] - Generate JSON.
* [https://www.autoitscript.com/forum/index.php?showtopic=127101 MS SQL (by TheLuBu)] - MSSQL.
* [https://www.autoitscript.com/forum/index.php?showtopic=127101 MS SQL (by TheLuBu)] - MSSQL.
* [https://www.autoitscript.com/forum/index.php?showtopic=51952 MS SQL (by ChrisL)] - _SQL. ADODB Connection.
* [https://www.autoitscript.com/forum/index.php?showtopic=51952 MS SQL (by ChrisL)] - _SQL. ADODB Connection.
* [https://www.autoitscript.com/forum/index.php?showtopic=20814 MySQL (by cdkid)] - MySQL relational database management system UDF.
* [https://www.autoitscript.com/forum/index.php?showtopic=20814 MySQL (by cdkid)] - MySQL relational database management system.
* [https://www.autoitscript.com/forum/index.php?showtopic=85617 MySQL (by ProgAndy)] - MySQL UDFs (without ODBC - working with libmysql.dll).
* [https://www.autoitscript.com/forum/index.php?showtopic=85617 MySQL (by ProgAndy)] - MySQL UDFs (without ODBC - working with libmysql.dll).
* [https://www.autoitscript.com/forum/index.php?showtopic=122360 MySQL (by James)] - MySQL ODBC Connector.
* [https://www.autoitscript.com/forum/index.php?showtopic=122360 MySQL (by James)] - MySQL ODBC Connector.
* [https://www.autoitscript.com/forum/index.php?showtopic=187223 romaSQL (rynow)] - This autoIt UDF is built on the concept of Laravel Query & doctrine. Connection string is based on ADODB / ODBC.
* [https://www.autoitscript.com/forum/index.php?showtopic=187223 romaSQL (rynow)] - Built on the concept of Laravel Query & doctrine. Connection string is based on ADODB / ODBC.
* [https://www.autoitscript.com/forum/index.php?showtopic=143331 Sharepoint 2007/2010 UDF (by schoppet)] - UDF to access the SOAP-Webservices of Sharepoint 2007/2010.
* [https://www.autoitscript.com/forum/index.php?showtopic=143331 Sharepoint 2007/2010 (by schoppet)] - Access the SOAP-Webservices of Sharepoint 2007/2010.
* [https://www.autoitscript.com/forum/index.php?showtopic=17099 SQLite (by ptrex)] - SQLite is a library that implements a self-contained, embeddable, zero-configuration SQL database engine.
* [https://www.autoitscript.com/forum/index.php?showtopic=17099 SQLite (by ptrex)] - SQLite is a library that implements a self-contained, embeddable, zero-configuration SQL database engine.
* [https://www.autoitscript.com/forum/index.php?showtopic=142977 SQLite Array Functions (by SmOke_N)] - SQLite Array Functions - a faster method for unique arrays and sorting methods.
* [https://www.autoitscript.com/forum/index.php?showtopic=142977 SQLite Array Functions (by SmOke_N)] - SQLite Array Functions - a faster method for unique arrays and sorting methods.
* [https://www.autoitscript.com/forum/index.php?showtopic=140521 SQLite - Database UDF (by PhoenixXL)] - UDF for SQLite so that beginners will also be able to do the stuff.
* [https://www.autoitscript.com/forum/index.php?showtopic=140521 SQLite - Database (by PhoenixXL)] - UDF for SQLite so that beginners will also be able to do the stuff.
* [https://www.autoitscript.com/forum/index.php?showtopic=157853 SQLiteEx UDF (by 57ar7up)] - SQLiteEx UDF v0.5.1 - Simplest work with SQLite.
* [https://www.autoitscript.com/forum/index.php?showtopic=157853 SQLiteEx (by 57ar7up)] - SQLiteEx UDF v0.5.1 - Simplest work with SQLite.
* [https://www.autoitscript.com/forum/index.php?showtopic=163633 Xbase I/O UDF (by RTFC)] - Transfer data between Xbase Data file (*.dbf) and AutoIt array written in pure AutoIt (no SQL, no ADO, no dlls, no external dependencies).
* [https://www.autoitscript.com/forum/index.php?showtopic=163633 Xbase I/O (by RTFC)] - Transfer data between Xbase Data file (*.dbf) and AutoIt array written in pure AutoIt (no SQL, no ADO, no dlls, no external dependencies).
* [https://www.autoitscript.com/forum/imndex.php?showtopic=209526 xlsxNative (by AspirinJunkie)] - Read and write xlsx files without excel.
* [https://www.autoitscript.com/forum/index.php?showtopic=19848 XML DOM Wrapper (by eltorro)] - Supports CRUD operations on XML. Including XSL and XPath.
* [https://www.autoitscript.com/forum/index.php?showtopic=19848 XML DOM Wrapper (by eltorro)] - Supports CRUD operations on XML. Including XSL and XPath.
* [https://www.autoitscript.com/forum/index.php?showtopic=176895 XML (by mLipok)] - New version of XML DOM Wrapper, with many new features.
* [https://www.autoitscript.com/forum/index.php?showtopic=176895 XML (by mLipok)] - New version of XML DOM Wrapper, with many new features.

Revision as of 15:14, 27 July 2023

This page is a listing of libraries of user defined functions (UDF). These libraries have been written to allow easy integration into your own scripts and are a very valuable resource for any programmer.
This list is probably not complete (377 UDFs on 2023-07-27), but constantly supplemented. If you do not find a solution here, ask a new question on the forum.

Note:
The listed UDFs might have been written for older versions of AutoIt. So there is no guarantee that every UDF works smoothly with newer versions.
None of the UDFs has been tested by the maintainers of this list so you as a user need to make sure that they deliver the expected results.

When will an UDF be added to this list?
It should meet all/most of the general requirements for UDFs as described here.
In addition the following requirements should be met:

  • Documentation: So users can tell what the UDF is intended to do (mandatory)
  • Examples: So users can get an idea how to use the UDF. The more the better (mandatory)
  • Operating systems: Should support the latest Microsoft OS (mandatory) plus as many predecessors as possible (optional)
  • AutoIt: Should support the latest version of AutoIt (mandatory) plus as many predecessors as possible (optional)
  • Author: The author should still be active on the forum so he can reply to questions (optional)


What to do when one of your UDFs is missing?
Please send a PM to user water. Add a short description of the UDF and a link to your post in the Example Scripts forum.

Added in the past two years

Date Section Creator Description
2023-07-27 OpenOffice/LibreOffice donnyh13 LibreOffice Writer - A huge list of functions for LibreOffice Writer.
2023-02-03 Graphics and image Starg S3D - Draw simple 3D graphics with GDI+.
2023-01-21 Files, Databases and web connections AspirinJunkie JSON - Interacting with JSON data in AutoIt.
2023-01-21 Script Coding/Analyzing/Debugging AspirinJunkie Set - Provides a set data type and brings the corresponding mathematical functions.
2023-01-21 Maths AspirinJunkie Stat - Statistics for Autoit.
2023-01-21 Script Coding/Analyzing/Debugging AspirinJunkie ArrayPlus - Functions for flexible Array handling (creating, extracting, rebuilding, sorting, filtering, finding, printing).
2023-01-21 Script Coding/Analyzing/Debugging AspirinJunkie ArrayCombinations - Different ways of composing elements of a set.
2023-01-04 Sound MattyD MIDI UDF - Wrap of the Windows MIDI functions.
2022-06-19 Internet protocol suite Beege cURLX64 - cURL UDF with x64 support.
2022-05-24 Controls kurtykurtyboy GuiFlatButton - Change colors of regular buttons.
2022-04-25 Social Media and other Website API Ascer oAuth - Open standard for access delegation, commonly used to grant websites or applications access to other websites.
2022-02-22 Files, Databases and web connections czardas CSVSplit - Convert to and from CSV format.
2022-02-11 Inter Process Communications Nine Overlapped Named Pipe IPC - Very fast interprocess communication that could be used between VBS or AutoIt.
2022-01-11 Media MrKm OCRSpace - Convert Images to text with the OCRSpace API.
2022-01-11 Media Danyfirex UWPOCR - Universal Windows Platform Optical Character Recognition API.
2021-08-18 Graphics and image smbape OpenCV v4+ - OpenCV UDF with support for OpenCV v4+.
2021-08-04 Windows DonChunior BITS - Background Intelligent Transfer Service to download/upload files from/to HTTP web servers and SMB file shares.
2021-02-27 Inter Process Communications SEuBo AutoItSharedData - Create a shared data storage, a simple AutoItObject-Object, using AutoItObject_Internal.
2021-02-20 Information gathering Ascend4nt NetworkStatistics - Network Interface Info, Statistics, and Traffic.
2021-02-16 Files, Databases and web connections BrewManNH _FileGetProperty - Retrieve properties of a file.
2021-02-09 Script Coding/Analyzing/Debugging ProgAndy and others AutoItObject - Brings the Object Orientation programming paradigm to AutoIt.
2021-02-05 Misc Nine BlockInputEx - Block all input coming from mouse and/or keyboard, without having an UAC warning displayed.


Automation

Browsers

Microsoft Office

Some features of Microsoft's Office products are proprietary and cannot readily be manipulated. Sometimes workarounds are required.
This page is dedicated to identifying those issues, provide explanations and list solutions or workarounds.

OpenOffice/LibreOffice

Other Applications

Script Coding/Analyzing/Debugging

Inter Process Communications

Files, Databases and web connections

Data compression

Encryption and hash

GUI Additions

Controls

Hardware

Information gathering

Internet protocol suite

Maths

Media

Graphics and image

Players

Sound

PDF

Security

Social Media and other Website API

Windows

Misc