How to the file paths using config file

[lakshmi.mp]

Hi all,

In workflow read the excel file path directly, need to store the file paths in excel config. How to do this.
Please guide me on this.

[sasi_poosarla (sasi p)]

@lakshmi.mp
Can you elaborate more!!
Need to file paths from one excel and need to store in another???

Cheers!!

[Kartheek_Battu]

Hello @lakshmi.mp

1. Read Range:

   • Input: Excel Config File Path, Sheet Name, Range (e.g., “A1:B100”)
   • Output: ConfigDataTable

2. Assign:

   • To: FilePath
   • Value: ConfigDataTable.Rows(0)(“FilePath”).ToString

Thanks & Cheers!!!

[lakshmi.mp]

@sasi_poosarla

Check this above screenshot, here the Excel file name, Sheet name are directly given. But want to store these details in config file…

[Shiva_Nikhil]

@lakshmi.mp

just store it in config as in mentioned in the below format

Filepath,Gmail_Sender.xlsx
SheetName,Filtered_IDS

you can call them as like below

config(“Filepath”).tostring

config(“SheetName”).tostring

[lakshmi.mp]

@Shiva_Nikhil ,
Here not using re framework
how to read the config file.
Can u send the screenshot of it.

[Shiva_Nikhil]

@lakshmi.mp

just you read range at the starting of the workflow

Sequence.xaml (11.6 KB)

in the Sheetname arguments change with your sheetname

[Vinit_Kawle]

Hi @lakshmi.mp,

You can use workflow from the EFramework “Init All Settings” to read config file and utilize it in your workflow .

InitAllSettings.xaml (20.4 KB)
you have to pass the file path of Config wherever you have created and use it in your process.

Hope this works for you.
Happy Automation,
@Vinit_Kawle

[vrdabberu (Varunraj Dabberu)]

Hi @lakshmi.mp

Are you using RE Frame work or else sequence process?

Regards

[lakshmi.mp]

@vrdabberu ,
Here using sequence process

[lrtetala (Lakshman Reddy)]

Hi @lakshmi.mp

You can copy the Init all settings xaml from RE-Framework and use it in Sequence and also copy the Data folder from Re-Framework to your Sequence flow

[lakshmi.mp]

@Shiva_Nikhil , which file need to be read config file or input excel file.
In else part name and value stored is this correct?

[Shiva_Nikhil]

@lakshmi.mp

no need to use anything in else block

just pass the file in the assign activity

[lakshmi.mp]

@Shiva_Nikhil ,

Invoked config file workflow, how the values reflected in excel application scope excel file.

[Shiva_Nikhil]

@lakshmi.mp

Refer the above screenshots

[lakshmi.mp]

@Shiva_Nikhil , this error getting.

Please look into the screenshot.
What changes need to do.

[Shiva_Nikhil]

@lakshmi.mp

you need to pass your sheet names , you need to modify it in the arguments sections

[lakshmi.mp]

@Shiva_Nikhil , Added sheetnames but same error getting

[Shiva_Nikhil]

@lakshmi.mp

can you share the screenshot of your excel sheets

in you excel can you see whether there are Settings,Constants

[lakshmi.mp]

@Shiva_Nikhil
=> config file
=> excel input file
Read range (Settings and Constants sheets): The sheet does not exist. this error getting

Please check these screenshots…