Excel Column values to array

[falafes]

Hi , I need to store the values of an excel column in a string array, how can I do this?

[GerdW]

Hi falafes,

read the Excel worksheet (using RGT functions) and get column C as a string array…

[falafes]

I don't seem to have that function

[GerdW]

Hi falafes,

---

@falafes wrote:

I don't seem to have that function

---

So what do you have available?

Which LabVIEW version, which bitness, which toolkits?

Did you install the RGT (Report Generation Toolkit)?

You might even use "simple" ActiveX nodes to communicate/remotely control Excel!

[falafes]

I'm on 32 bit LV2017, I don't have RTG I just checked but it says that's for google sheets, will it still work on excel?

[RavensFan]

I have never heard of it associated with Google.  (Maybe it can handle that too.)

But it RGT = Report Generation Toolkit is definitely for Excel

[falafes]

Okay I installed RGT but I still don't know which VI to use?

[GerdW]

Hi falafes,

when you installed the RGToolkit then you have its example VIs available in the example finder.

Did you explore them to learn how to use the RGT functions?

[falafes]

Okay this is what i have so far, but how do i put this in an array??

[GerdW]

Hi falafes,

---

@falafes wrote:

Okay this is what i have so far, but how do i put this in an array??

---

Whatever that is it is not from RGT as supplied by NI.

Where do you got this VI from?