read from spreadsheet to array of strings

[Mayur_VIenthusiast]

Hi

I need help to build a 1D(string) array from a MS Excel file. I've tried using read from spreaaadsheet/ read from Meaurement file. I'm unable to do this. The excel file contains alpha-numeric data. please suggest with some example vis.

input would be the excel file path

output would be a 1D array of strings

Thank you 

[P@Anand · Accepted solution]

Is it necessary to be an Excel file or you are using Excel to open the file?. If it has to be Excel then you may have to use the Active X (Example you can find in this board), otherwise just save it as csv file and use the Read from spreadsheet vi with "," as delimiter.

[Mayur_VIenthusiast]

hi i've updated the program. i'm getting an output but, the output array comes out as comma delimited elements. how do i seperate them??

[muks]

For reading excel

[Mayur_VIenthusiast]

muks, this program doesnt work for strings

[P@Anand]

---

@mayurvnktsh wrote:

muks, this program doesnt work for strings

---

How do you say it doesn't work?

[P@Anand]

---

@mayurvnktsh wrote:

hi i've updated the program. i'm getting an output but, the output array comes out as comma delimited elements. how do i seperate them??

---

You must give the delimiter as "," (comma) while using the Read from spreadsheet vi to read the file.

[Mayur_VIenthusiast]

Thank you

I'm posting the completed VI for others reference