Devart Excel Add-in Database Pack
使用 Microsoft Excel 中的数据库数据。
由以下开发商制作:Devart
ComponentSource开始代理销售的日期:2005年
Devart Excel Add-in Database Pack 关于
使用 Microsoft Excel 中的数据库数据。
Devart Excel Add-in Database Pack allows you to connect Microsoft Excel to database data. You can quickly and easily load from databases to Excel, instantly refresh data from the database, edit the data, and save it back. It enables you to work with database data like you do with Excel worksheets. You can easily perform data cleansing and de-duplication and apply all Excel's powerful data processing and analysis capabilities to the data.
Features
- Powerful Data Import - The add-in allows you to precisely configure what data to load into the document. It allows you to select objects, columns and set complex data filters.
- Quick Data Refresh - The add-in allows you to get the data with a single click, without repeating the whole import operation each time. You can refresh data in your workbook easily whenever you want.
- Easy Data Modification - You can edit data in Microsoft Excel just like you usually do, add or delete rows, modify cell values, etc. Use the full power of Excel to perform mass data updates, insert, and delete operations against your data source. After you have finished editing, just click Commit and the changes will be posted back to the data source.
Supported Databases
- Oracle
- SQL Server
- MySQL
- PostgreSQL
- SQLite
- DB2
