Excel Add-in for Oracle

From Oracle FAQ
Jump to: navigation, search
Excel Add-in for Oracle

Description[edit]

Devart Excel Add-in for Oracle allows you to connect Microsoft Excel to Oracle, quickly and easily load data from Oracle to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to Oracle. It enables you to work with Oracle data like with usual Excel worksheets, easily perform data cleansing and de-duplication, and apply all the Excel's powerful data processing and analysis capabilities to these data.

Key Features:

• Powerful Data Import. With Devart Excel Add-in for Oracle you can precisely configure what data to load into the document. Select objects and columns and set complex data filters. If this is not enough, all the power of SQL is to your service.

• Quick Data Refresh. The main Devart Excel Add-in for Oracle benefit is an ability to periodically get the actual data from different data sources to Excel with a single click without repeating the whole import operation each time. Refresh data in your workbook easily whenever you want.

• Easy Data Modification. You can edit data in Excel just like you usually do it, add or delete rows, modify cell values, etc. Use full power of Excel to perform mass data update, insert, and delete operations against your data source. After you finished editing, just click Commit and the changes will be posted back to Oracle database

Availability[edit]

All Devart Excel Add-ins are included in a single installation package. Downloaded Devart Excel Add-ins provide 30-day trial period since the first installation. After the trial period is over, you should purchase the license and register the add-ins you want to continue using. Trial version is available at the download page