我們的品牌

Impact-Company-Logo-English Black-01-177x54

歡迎造訪施耐德電機全球網站

歡迎訪問我們的網站
		
我们今天能为您提供什么帮助?
Video: How is logged data exported from ION Setup to Microsoft Excel?

Product Line
ION Setup

Environment
Data Logs

Cause
ION Setup was designed as a viewing program without any facility for data storage or export.

Resolution
If historic data that was downloaded from a meter in ION Setup needs to be exported to another format the following procedure will need to be follow:

Connect to the meter and enter data viewing mode (see ION Setup User's Guide for details).

  1. Open the data recorder of your preference. And highlight the section you'd like to copy.
  2. Select the Edit menu and choose copy.
  3. Open Microsoft Excel and open a 'New' document.
  4. Select the Edit menu and choose paste. You will need to create the column headings yourself as they won't be copied over.
  5. Highlight the Timestamp column and right click on one of the highlighted cells and select Format Cells
  6. When the Format Cells popup appears, change the Category to date, and select an appropriate date type.
  7. If the date shows up with an @ symbol between the Time & Date section, then you will have to find/replace the @ with a (space).
  8. Click on the A column heading to select the A column again.
  9. Select Edit and choose replace.
  10. In the find field place your @ symbol, then in the replace field you can type the space, then click Replace all.
    Find and Replace

To Graph Data:
  1. To Graph your data, you can select the Timestamp column & the desired columns by holding down the CTRL button and clicking on the Column letter.
  2. Click on the graph button, and follow the wizard to create the line/x-y scatter graph you need.



If you want to export the data as a .CSV file, follow Video: How to export datalogs from ION Setup in CSV and HHF formats | Schneider Electric USA

施耐德電機Taiwan

探索更多
系列:
探索更多
系列:
  • 產品文檔
  • 軟體下載
  • 產品選型工具
  • 產品替代和替換
  • 幫助和聯絡中心
  • 尋找我們的辦公室
  • 取得報價
  • 施耐德電機社群
  • 人才招募
  • 公司簡介
  • 舉報不當行為
  • 無障礙
  • 新聞中心
  • 投資者
  • 專業洞察
  • 台灣施耐德電機學院
  • 綠色影響力落差調查
  • Schneider Go Green 2025
  • 隱私政策
  • Cookie通告
  • 使用條款
  • Change your cookie settings