How to read file based on the environment,

[ManjunathReddy (P Manjunatha)]

“C:\Users*W890123*\Documents\UiPath\DataBase_Connection\NASDAQ.xlsx”

so I need read file based on the environment

Thanks in advance

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @ManjunathReddy ,
I don’t really understand, reading files based on extension of file, file type or what?
Can you tell more to clear it
regards,

[ManjunathReddy (P Manjunatha)]

Based on environment not extension

[Yoichi]

HI,

How about the following expression?

System.IO.Path.Combine(System.Environment.GetEnvironmentVariable("USERPROFILE"),"Documents\UiPath\DataBase_Connection\NASDAQ.xlsx")

Regards,

[ManjunathReddy (P Manjunatha)]

What is user profile here? is it System id?

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

You can try
Path.Combine(Environment.CurrentDirectory, folderPath.ToString)
regards,

[Yoichi]

HI,

System.Environment.GetEnvironmentVariable("USERPROFILE") returns user folder of current user such as c:\User\username

Regards,

[ManjunathReddy (P Manjunatha)]

Before documents i am having like below image

[Yoichi]

Hi,

How about either of the following?

System.IO.Path.Combine(System.Environment.GetFolderPath(Environment.SpecialFolder.Personal),"UiPath\DataBase_Connection\NASDAQ.xlsx")

OR

System.IO.Path.Combine("c:\Users",System.Environment.GetEnvironmentVariable("UserName"),"Documents\UiPath\DataBase_Connection\NASDAQ.xlsx")

Regards,