Reading whole excel file

[Basavaraj093]

Hi all I want read whole excel file 

please guide me.

[Basavaraj093]

Hey, Can I get the same but want to read it. no write

only read.

[GerdW]

Hi Basvaraj,

---

@Basavaraj093 wrote:

Can I get the same but want to read it. no write

---

The same as what exactly?

---

@Basavaraj093 wrote:

only read.

---

You want to read a text file using an Excel import routine? Why???

What do you really want to solve?

[Basavaraj093]

Basically

I want to read the whole excel file as it is.

so, I can perform some operation like searching particular number\name and get the whole data related to it like date time, pass or fail

this vi (screen shot) is write at particular cell. 

[ooth]

You need to change the input from a string to a 2D array, and you can remove the starting cell range to read the whole file.

[Basavaraj093]

Thank you for your reply

IT WOULD BE NICE IF YOU SAVE IT FOR 2018 VERSION

[ooth · Accepted solution]

Here you go.

[Basavaraj093]

Thank for your reply.

I am now reading a whole excel file.

Do you know how can i search particular word in that.

like if I search serial number, it should give me whole row related to that serial number 

like date time status

[ooth]

I would read in the whole Excel file and then do the search in LabVIEW to get the row you want. It's probably faster that way. But if you really want to search look at this VI.

[Basavaraj093]

Thank you for your reply

i will check