Devart Excel Add-in for Adobe Commerce について

Microsoft ExcelでAdobe Commerceのデータを処理

Devart Excel Add-in for Adobe Commerce (formerly known as Devart Excel Add-in for Magento) allows you to connect Microsoft Excel to Adobe Commerce data. You can quickly and easily load from Adobe Commerce to Excel, instantly refresh data from the database, edit the data, and save it back. It enables you to work with Adobe Commerce 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.