Read excel/csv to a Datatable

[Dhruvi_Arumugam]

Hi Community,

I want to read an excel/Csv file into a datatable using either C# or Vb.net.

Can anyone help me on this. I visited the below link but not getting much knowledge

Best /Fastest way to read an Excel Sheet into a DataTable?

Any help would be appreciated.

Thanks

@Yoichi @ptrobot @ppr @supermanPunch can you guys also have a look on the problem.

[Rahul_Unnikrishnan]

Hello @Dhruvi_Arumugam ,

Do you want it specifically with the code or using Uipath activities?

[ppr (Peter)]

just let us know how close this topic is to see with the other one:

Require Editing in the code with exceptional handling

Hi Community, I require help on the below code var delimiter = ","; var allCsv = Directory.EnumerateFiles(@"C:\Users\Documents\UiPath\Files1", "Ansible"+"*.csv", SearchOption.AllDirectories); string[] header = { "FileName" + delimiter + File.ReadLines(allCsv.First()).First(l => !string.IsNullOrWhiteSpace(l)) }; FileCount =allCsv.Count(); // Get CSV Data var mergedData = allCsv.SelectMany(csv => File.ReadLines(csv).SkipWhile(l => string.IsNullOrWhiteSpace(l)).Skip(1).Select(ll => (csv.C…

It looks like you are still working on the same task

In general we would recommend:

• reducing black boxes caused by invoke code usages
• shifting to buffered readers / writers when mass volumes are to handle and core staptements like ReadAllLines, … are no longer reliable working

[Dhruvi_Arumugam]

Yes the topic is kind of relatable, If I talk about in reference with the above topic as once all the CSV files are merged a consolidated file is prepared of the merged data then I want to read it. Reading that it is taking me a lot of time which can break the SLA.

Thus, post merging the files the merged data file which came up i want to read that, so I thought of any help i can get on that.

Thanks!

[Dhruvi_Arumugam]

Hi @Rahul_Unnikrishnan,

The activities are not giving me result in stipulated time thus I need some code workaround.

Thanks

[postwick (Paul)]

The activities just have code inside them. Using activities isn’t slower than code. Show us what you’re doing, what the source data is, and your activities.