01-14-2025 02:58 AM
@Martin1979 wrote:
Good morning everybody!
I think the Solution of @PinguX might work for the further processing and I'm close to it.
What I get are the numbers in the second row but not the text. And my array has the wrong "color" and shape. I guess that's a mater with the data format. Maybe that's a foolish question but where the h..l do I change that? 🤔
You have to wire a 2D array of string to the 'array type' input of the 'Spreadsheet String to Array' node. The output will change accordingly.
01-14-2025 08:41 AM - edited 01-14-2025 08:51 AM
@UliB wrote:
@Martin1979 wrote:
Good morning everybody!
I think the Solution of @PinguX might work for the further processing and I'm close to it.
What I get are the numbers in the second row but not the text. And my array has the wrong "color" and shape. I guess that's a mater with the data format. Maybe that's a foolish question but where the h..l do I change that? 🤔
You have to wire a 2D array of string to the 'array type' input of the 'Spreadsheet String to Array' node. The output will change accordingly.
Look at my post where I circled the needed datatype constant in green. 😉
EDIT: I see from your latest pic that you connected a 2D array, but it's an orange numeric. Just drag out the zero on the right and drag in an empty string constant from the string palette (or any string really) to change its datatype to string.
01-14-2025 08:59 AM
The first page of the LabVIEW Learning site covers all these topics and only takes 10-15 minutes to read through. Highly recommended!