Fetch data from excel into list box

Question

1.00/5 (1 vote)

See more:

C#

NUnit

selenium

Hi everyone, I need to fetch data from excel, like 5 items into list box, how can I do with single item able to pass.?

JEERA
PISTA
BADAM
Sugar
etc....

What I have tried:

C#

Recipe.SelectIngredienttype(ExcelUtils.ReadData(1, "Item"));

i have tried to pass like this but i got only one value, need to pass 5

Posted 18-Jun-20 19:26pm

Smita Ast

Updated 16-Jul-20 22:20pm

Maciej Los

v3

Add a Solution

Comments

Maciej Los 19-Jun-20 2:06am

ExcelUtils is non-standard class. How would we know what parameter you have to pass into ReadData method to get more than one item?

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Code Artist · Answer 1 · 2020-07-16T22:20:00

Solution 2

If these data must be from Excel, try ClosedXML to read content from excel.
Otherwise, consider to have it in text file where you can just read it as follow:

string [] data = File.ReadAllLines(<fileName>);

Posted 16-Jul-20 22:20pm

Code Artist

Fetch data from excel into list box

1 solution

Solution 2

Add your solution here

Preview 0

Fetch data from excel into list box

1 solution

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us