To read specific row data from the excel file and writing it to table

[Sahan@123]

Hi,

Problem statement:I have an excel sheet,in the first column i have serial numbers 1,2,3,4.....and so on.In the input field-if i search with any of the serial number 1,2,3,4... i should get the respective row data as a output.Output as a table format.

Do anyone has any idea how to do it?please give me suggestions

[GerdW]

Hi Sahan,

---

Sahan@123 wrote:

Problem statement:I have an excel sheet,in the first column i have serial numbers 1,2,3,4.....and so on.In the input field-if i search with any of the serial number 1,2,3,4... i should get the respective row data as a output.Output as a table format.

Do anyone has any idea how to do it?please give me suggestions

---

Get the worksheet data as an array to LabVIEW.

Index the first column, search for your serial number.

The result of the Array1DSearch function is the row number: use it to IndexArray the corresponding row data from your array.

What have you tried?

What are the problems?

Where are you stuck?