Data logging

[Mudit099]

how to extract a row in a excel by the help of an element of that row 

[GerdW]

Hi Mudit,

how is your topic "Data logging" related to your question about "handling Excel files"?

---

@Mudit099 wrote:

how to extract a row in a excel by the help of an element of that row 

---

Read the row, then examine that specific element…

[Mudit099]

Actually i need to extract data of a patient based on a patient ID and patient password of which i have created an Excel sheet and what you just suggested i tried but it is easier to say then done i am only witnessing garbage string values not the actual data that i wanted to extract can you suggest what could be the problem 

[Mudit099]

this is my excel sheet from which i have to extract data

[GerdW · Accepted solution]

Hi Mudit,

---

@Mudit099 wrote:

i am only witnessing garbage string values not the actual data that i wanted to extract can you suggest what could be the problem 

---

You didn't attach any VI(s), so we cannot tell you what is wrong with your VI!

I can only guess:

You try to read an Excel file using the "Read Delimited Spreadsheet File" function - which is the wrong function!

You need to use functions from RGT (Report Generation Toolkit) to read Excel files - study the example VIs in the example finder on how to use them…

[Worle · Accepted solution]

Alternatively save your spreadsheet as a csv file (which is a plain text file) which will allow you to use the LabVIEW file IO functions and spreadsheet string to array

[Mudit099]

you guessed it right i used the wrong function rest i will try what you suggested thanks for your guidance

[Mudit099]

ok