Read Excel File

[ds1638]

Hi fellow coders, I need some help on the subject of Excel Files.

Process

Read Excel File (5 work sheets)  >> Output is 5 2D Array's >> Covert 2D Array to Single Array (Colum) >> Convert Data (String's)to Relevant Datatype (I/O, Numeric etc) >> Build Cluster Array with 2D Array Data.

I need some help with interpreting the Covert 2D Array to Single Array (Colum) >> Convert String to Relevant Datatype >> Build Cluster Array with 2D Array Data.

Happy Coding

Dave

[smercurio_fc]

---

ds1638 wrote:

Covert 2D Array to Single Array (Colum)

---

Reshape Array

---

ds1638 wrote: 

Convert String to Relevant Datatype

---

Too vague. What strings? What datatypes?

---

ds1638 wrote:

Build Cluster Array with 2D Array Data.

---

Array to Cluster or Build Cluster Array, depending on exactly how you've got the data collated.

[ds1638]

I have 5 2D Array's to which I need to split into 1D Array Clusters, the data types are strings within the 5 2D Array's and I wish to split them up per row and connvert them into a 1D Array Clusters containing the following datatypes

I/O

Boolean

Numeric

[smercurio_fc · Accepted solution]

You could do something like this:

[ds1638]

How do you convert a string to a file I/O data type ???

[smercurio_fc]

---

ds1638 wrote:
How do you convert a string to a file I/O data type ???

---

I'll tell you as soon as you tell me what a file I/O data type is.

[ds1638]

DAQmx Phyiscal Channel I/O

[smercurio_fc]

You don't need to convert it to anything. The DAQmx VIs will accept a string for the physical channels inputs.