How to connect "Array constant" &&"Spreadsheet string to Array"

[Cherry_c]

How to connect "Array constant" &"Spreadsheet string to Array"?

When I try to connect these two,the circuit broken.It showed "you have connected 2 terminals of different types ,the source type is 2-Darray of void,the type of the sink is 2-D array of double".

How can I transform the type?

Thanks so much.

[Dennis_Knutson]

Don't you think it would be impotant to at least post an image of the block diagram if not the actual VI? Did you actually place a data constant (i.e string or numeric) into the array constant?

[Yamaeda]

---

@cherry c wrote:

How to connect "Array constant" &"Spreadsheet string to Array"?

When I try to connect these two,the circuit broken.It showed "you have connected 2 terminals of different types ,the source type is 2-Darray of void,the type of the sink is 2-D array of double".

How can I transform the type?

Thanks so much.

---

Why would you connect them?

1. An array constant is an array, not a string, thus Spredsheet string to array wont work.

2. If you connect Spreadsheet string to array to a constant ... you cant change constants.

If 1, you need to rethink your solution and tell us what you want to do.

If 2, You must change the constant to an indicator.

/Y

[altenbach]

If you have an array, it might be more logical to connect it to "array to spreadsheet string" instead. 😄

[kekin]

Better first mention your purpose of doing it. Are you trying to write to spreadsheet for just test of for the first time?

How long you have been using labview?

[Norbert_B]

---

@cherry c wrote:

[...],the source type is 2-Darray of void,the type of the sink is 2-D array of double".

How can I transform the type?

Thanks so much.

---

There is only one way to have a "void" datatype in LV: You have not typified the array. Therefore, your array constant is empty, has a black border and will break execution by itself (so not only the wire in invalid).

You have to drag and drop a constant of the desired datatype into the empty array shell and then it should work.

hope this helps,

Norbert

[EDIT]: This is the more elaborate answer which is already implied by the second question from Dennis 😉

[Yamaeda]

Then the solution is as follows:

Create double constant.

Create Array constant.

Drag double into array to type def. it.

Drop an Array to Spreadsheet string.

Wire them together.

Violá!

/Y

[Cherry_c]

In fact,I found finally that I can make it just by creating a constant beside the array type of Speadsheet String to Array. Thanks so much for all your help^_^ PS:Someone want to know that,so I can tell you,I am just a beginner with Labview~~And I'm learning the way to learn.Thanks.