> For the complete documentation index, see [llms.txt](https://docs.videc.de/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.videc.de/june5-3.7/en/weitere-june5-produkte/june5-add-in-for-excel/uebersicht.md). # Overview The JUNE5 Add-In for Excel provides a tab with various controls and display elements. This is divided into different areas in which related functions are grouped. Buttons that have no function due to connection status are disabled on the tab. ![](/files/vBaYh6GpyDMzVGJTUNnY) JUNE5 Add-In for Excel offers the standard mode in which data from JUNE5 can be queried and inserted into a worksheet in table format and also updated. Furthermore, the Add-In for Excel supports DABay mode, in which data from DABay XML files can be imported, updated with JUNE5 data, and also exported as XML. ### Standard Mode If an Excel worksheet is to be processed for the first time with JUNE5 Add-In for Excel, it must first be initialized via the **Initialize** button (on the far left of the tab). ![](/files/sfsmM24R410MMxw4phJK) After that, the workbook is initialized for standard mode and tables with JUNE5 measured variables can be inserted and updated. After initialization and connection to the server, all functions of JUNE5 Add-In for Excel are available to you. ![](/files/HVw41bJU6Z94iaUB0aWg) ### DABay Mode If an Excel workbook is to be initialized for DABay mode for the first time, it must first be initialized via the *XML Import* button. See chapter [Import of Data from a DABay-compliant XML File](/june5-3.7/en/weitere-june5-produkte/june5-add-in-for-excel/erweiterungen/dabay/import-von-daten-aus-einer-dabay-konformen-xml-datei.md). After that, the workbook is initialized for DABay mode and DABay XML files can be imported, tables with JUNE5 measured variables can be inserted and updated, and exported. After initialization and connection to the server, all DABay functions of JUNE5 Add-In for Excel are available to you. ![](/files/ipyt7p9OPmIgVoAO5r19) ## Function Groups * Under the group **Data** are the functions that directly request and process data from the June5 server. The **Create New Table** button opens the wizard that guides users in creating a new table. The **Insert Process Variable** button inserts a dropdown list with all process variables of the facilities in the active cell of the Excel workbook. The **Update** function deletes the stored data of the process variables and reloads it from the June5 server. To facilitate editing of existing formulas, there is a toggle button **"Updates: ON/OFF"**. When the button is set to **"Updates: OFF"** the June5 formulas in Excel are not calculated. Instead of the actual result, the formula displays the message "#no updates". This allows multiple parameters of the formula to be changed simultaneously without new data being fetched from the server after each change. Only after the button is set back to **"Updates: ON"** do the formulas run with their normal function. * Via the **Migrate** button in the **Migration** group, workbooks from the ACRON Excel Add-In can be migrated and used with JUNE5 Add-In for Excel. * In the **June5 Server** group on the left are the **Connect** and **Disconnect** buttons and on the right is the connection status display. Clicking the **Connect** button opens a dialog that guides users in establishing a new connection to a JUNE5 server. Clicking **Disconnect** disconnects the current connection. * On the far right in the **Extras** group are the functions for opening the **Settings** and **Info** windows, as well as the **Help**. Within the Settings window, the language of JUNE5 Add-In for Excel can be switched between German and English. Additionally, via the checkbox you can set whether the update function is executed per sheet or per workbook. Under the **Extensions** tab, the DaBay interface can be activated. --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.videc.de/june5-3.7/en/weitere-june5-produkte/june5-add-in-for-excel/uebersicht.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.