What is Glue42?

Glue42 is a service that offers a comprehensive set of tools for building, managing, and integrating web applications. It facilitates communication between apps by providing service windows that operate in the background, invisible to the user, which can be useful for apps that need to communicate with a single endpoint or for consolidating data from multiple providers. These service windows can start automatically with Glue42 Enterprise or upon an app's request.

Glue42 Enterprise, a key component of Glue42, is a service that handles a variety of tasks such as streaming and consuming system logs, managing cookies, displaying dialogs, and managing window zoom levels. It is designed to enable quick access to Glue42 Windows from URLs and allows users to customize components like the Feedback and About apps through configuration settings.

With support for various programming languages including JavaScript/TypeScript, .NET, Java, and COM/VBA, Glue42 extends its functionality to a wide developer audience. It is particularly useful for web applications that may lack access to system resources or the ability to register global shortcuts. Additionally, Glue42's APIs allow for the management of windows, manipulation of request headers, and access to environment variables and OS information, enhancing the capabilities of web apps within the Glue42 environment.

Glue42 Plugins for Excel

Excel Connector Features

The Glue42 Excel Connector enhances the capabilities of applications by utilizing Excel as a powerful local data editor. It streamlines the workflow by uploading tabular data directly into Excel, allowing users to view and modify the information with ease. Moreover, any alterations to the data can be efficiently communicated back to the originating application, enabling processes such as validation, processing, auditing, and long-term storage.

Benefits of Glue42 Excel Integration

Integrating Glue42 with Excel brings a multitude of benefits, notably the seamless communication between windows of different applications, which significantly increases productivity by cutting down the time and effort for daily tasks. This integration provides a unified user interface, synchronizes applications, consolidates notifications and search functions, and extends application features. Furthermore, it eases legacy migration, offers user experience monitoring, and simplifies remote configuration and permissions management. The componentized development and delivery, along with code reusability, support rapid release cycles and allow developers to monitor application performance effectively.

Use Cases for Glue42 Excel Plugins

The Glue42 Excel Connector's versatility is showcased in its various use cases. It empowers applications to harness Excel for local data editing tasks. Users benefit from the ability to upload, review, and modify tabular data within the familiar environment of Excel. This integration also provides a robust platform for data validation, processing, auditing, and safe long-term storage, effectively leveraging Excel's comprehensive toolkit for enhanced data management.

Common Use Cases

• G

  
  Use case 1: Real-time data editing where changes made in Excel by a user are immediately reflected back in the original application
• G

  
  Use case 2: Dynamic financial modeling where users can open new sheets and alter column configurations to run different scenarios
• G

  
  Use case 3: Batch data processing where large datasets are updated in Excel and validated chunk-by-chunk to ensure accuracy
• G

  
  Use case 4: Data entry with validation where users input various data types and receive immediate feedback on invalid entries
• G

  
  Use case 5: Customized data presentation where applications dynamically change the display of data in Excel based on user interactions or predefined conditions

Frequently Asked Questions

What is io.Connect Desktop and how does it relate to Glue42?

io.Connect Desktop is the new name for Glue42 Enterprise. It includes a plugin that integrates with Excel to allow users to launch and work with MS Office apps from a browser.

Can I edit data in Excel and synchronize changes with my web app in real time?

Yes, editing data in Excel can synchronize changes back to the web app in real time, thanks to the continuous synchronization provided by the plugin.

How can I ensure that data edited in Excel is validated?

Data validation is performed by the web app with instant flagging of issues in Excel, ensuring that data meets the required standards.

Are Excel's advanced functions like macros and pivot tables supported by the plugin?

Yes, the plugin enables the use of Excel's functions, like macros and pivot tables, while ensuring data edits are saved back to the web app.

What should I do if the Glue42 Connectors for MS Office are not enabled automatically?

Manual activation of Glue42 Connectors might be necessary due to an MS Office app's internal settings or policies.