Excel

Excel report enables a user to transfer data from Excel files from Microsoft Sharepoint into a user determined data warehouse.

Data Pipelines Details

Data Pipeline

Select Excel from the dropdown

sharepoint excel list
Folder Path

Enter the Folder Path…​eg:for root directory: "/"

File Name

Indicate the name of the CSV file. You may indicate the exact name or a part of the name.

Only .xlsx file format is supported.
Sheet Name

Indicate the name of the excel worksheet from where you want to fetch data.

Setting Parameters

Select the fields that are necessary as per the file or folder .

Parameter Description Values

Process All Matching Files

Optional

If Yes then all the files matching the name will be processed. If No then the files modified or created within the specified period will be processed.

Yes, No

Default Value: Yes

File Selection Criteria

Dependant

Required

(If you do not want to process all files)

Enter the criteria based on which the file will be selected

Date Created , Date Modified

Default Value: Date Created

File Created/Modified Time Dependant

Required

(If you do not want to process all files)

Choose File’s creation or modification time from dropdown

Latest Created/Modified , Last 2 hours, Last 4 hours, Last 6 hours, Last 8 hours, Last 12 hours, Last 24 hours, Last 1 week

Default Value: Latest Created/Modified

Header Column Present

Optional

Specify whether Headers are present in the file

Yes, No

Default Value: Yes

Header Row

Required

Specify the Row number on which headers are present.

Integer value

Default Value: 1

Data Row

Required

Specify the Row number on which data starts.

Integer value

Default Value: 2

Footer

Optional

Specify the row number containing the footer, if you want to delete rows from the bottom.

Integer value

Default Value: None

Insert Mode

Optional

Specifies the manner in which data will get updated in the data warehouse : Upsert will insert only new records or records with changes, Append will insert all fetched data at the end, Replace will drop the existing table and recreate a fresh one on each run.

Upsert, Append, Replace

Default Value: Replace

Key

Dependant

Required

(If Upsert is chosen as the Insert Mode Type)

Enter the column name based on which data is to be upserted.

String value

Attempt Schema Inference

Required

If Yes then while processing it will be attempted to convert text to numbers and dates; WARNING: WILL DROP EXISTING WAREHOUSE TABLE. If No then everything will be fetched as it is irrespective of its type.

Yes, No

Default Value: No

Compressed

Optional

Indicate whether folder or file is compressed

Yes, No

Default Value: No

Compression Type

Dependant

Required

(If folder/file is compressed)

Enter the Compression type

Zip , Gzip

Default Value: Zip

Post Processing Action

Optional

Indicate the actions or processes carried out after the initial processing

No Action, Move files, Move and Compress files

Default Value: No Action

Move File Destination

Dependant

Required

(If folder/file is to be moved after processing)

Enter the Destination folder path

String Value

Target Compression Type

Dependant

Required

(If folder/file is to be compressed after processing)

Enter target compression type

Zip , Gzip

File Encoding

Optional

Specify the file encoding used to represent characters when processing text.

String value

Default Value: utf-8

Include Source File Name

Required

Set this parameter to 'YES' if you want to include source file name in the data warehouse.

Yes, No

Default Value: No

sharepoint excel config 1
sharepoint excel config 2
sharepoint excel config 3

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.