- Community Home
- :
- Discussion Forums
- :
- Most Active Software Boards
- :
- LabVIEW
- :
- Re: XYZ coordinates to matrices?

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted
##

Re: XYZ coordinates to matrices?

12-29-2017 01:54 PM

Options

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report to a Moderator

Hello.

Pls, I want to plot contour maps from XYZ data that is already saved in Microsoft Excel as delimited spreadsheet VI.csv file. How do I apply the solution given below by Altenbach Knight of NI?

Re: XYZ coordinates to matrices?

01-02-2018 09:19 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report to a Moderator

Hey EngrSadiq, I would suggest making a new forum post and referencing this one with a link. This forum post is from 2013, so you're more likely to get responses if you create a new one!

Francine P.

Applications Engineering

National Instruments

Applications Engineering

National Instruments

Re: XYZ coordinates to matrices?

01-02-2018 10:34 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report to a Moderator

There is no solution below, but maybe there was one above earlier, before the post got moved to a new thread.

How is the data arranged in the csv file?

What's is the size of the xy area?

Re: XYZ coordinates to matrices?

01-06-2018 09:16 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report to a Moderator

Hello sir.

Sorry, I was supposed to write earlier solution not solution below.

The data is separeted by comma, for all X and Y values. I have 3 rows and 169 columns. X ranges from -6 to 6 and Y also have the same range of -6 to 6. Attached is the copy of the whole data in Microsoft Excel as delimited spreadsheet VI.csv file. Thank you for your attention.

Re: XYZ coordinates to matrices?

01-07-2018 12:31 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report to a Moderator

"Read from spreadsheet file" (or "read delimited spreadsheet" in newer LabVIEW version) will read your data into a 2D array. Use comma as delimiter.

Now you need to initialize a 2D array and replace elements with z data according to the xy indices.

2D arrays (or matrices) only have non-negative indices, so you need to offset the x and y to satisfy that constraint.

See how far you get. Let us know if you have more problems.