• All Files

Excel.Net

Excel.Net Provider is designed by IConduct to extend the methods of data operation for the Excel files. It has been created for reading and creation of .xls files; and modification of .xlsx files. The provider is written on a pure .NET code.

 

To configure the Excel.Net connector, follow the instructions below:

 

  1. In the Admin Navigation tree, select Connections and click New.

Connections Section in the Admin Navigation Tree

  1. Scroll down to the Data Files section and select the Excel.Net item from the list.

Connector Selection Page

  1. In the Excel.Net Connection work area, fill in the following fields and click Save.

Connection Work Area

Fields Description

Connection*

The new connection name. Enter a connection alias here.

Is Active

Toggles connector’s activity at interface execution. Enable the checkbox to activate the connection for execution.

Cloud Agent

The LAN you are working with. Select "IConduct" for cloud systems and your corporate agent for internal systems.

Implementation Type*

Defines the implementation type. Select from the drop-down list:

  • Default. IConduct scheduler works on the cloud agent set in the Cloud Agent field.
  • Java. IConduct scheduler works by sending requests to a Java agent.

Is Source

This connection entity is available as a data source for Import (writing to Schema). Enable the checkbox to ensure data import.

Is Target

This connection entity is available as a data target that receives data from schema to current data container. Enable the checkbox to ensure data export.

Timeout

The length of time (in milliseconds) the IConduct platform waits for a response from the connection provider before returning a timeout error. Set the time value to stop the system from connection attempts.

SQL

The box is intended for entering a query.

DateTime Format

Not used in this connector.

Path*

Path to the excel file to operate the data (read, modify, etc.).

For the existing file, IConduct selects it at a destination stated in this field.

For a new file, IConduct creates it at a destination stated in this field.

Enter a valid file path here.

Example:

  1. C:\Documents\.xls
  2. C:\Documents\.xlsx

Workbook Password

Applies if the file given in the Path field is password protected.

Enter a valid Excel workbook password here.

Worksheet Name

The name of the Excel worksheet.

For the existing worksheet, IConduct selects it from the file stated in the Path field.

For a new worksheet, IConduct creates it in the existing file stated in the Path field.

For a new worksheet in a new Excel file, IConduct creates a new Excel file with this worksheet at a destination mentioned in the Path field.

Type the relevant worksheet name here.

For example:

Parse Culture.

For Instance:'hb-il'

Allows choosing the language to work with worksheet contents for non-default non-ASCII symbols, specific datetime format, number format etc. If the field is left blank, the default system culture will be used.

Enter the parse culture following the language setup on your Microsoft account.

Impersonation User

Allows defining the user to impersonate and act on their behalf performing operations with the connector. Enter the required username here.

Impersonation Password

Enter the password for the impersonated user.

Impersonation Domain

Allows defining a company domain to impersonate and act on their behalf performing operations with the connector. Enter the required company domain name here.

 

* = mandatory fields.

 

Once the connection is saved, you can test if it is successful. Click Test Connection in the toolbar. If the created connection works, you will receive a success message. 

Testing the Connection