03-17-2016 05:54 PM
Hello, first off thank all of you for you knowledge. this forum is a amazing resource.
My question I imagine is very simple. I want to be able to pick threw column and rows in multiple pre-existing excel (.csv) spreadsheets and just pull the data I want and place it into a new excel spreadsheet. is this doable?
It seems that I can do this with some of the report generation tools but so far I am stumped.
Any help to this boring question would be appreciated.
-David
03-17-2016 05:58 PM - edited 03-17-2016 05:59 PM
If you're working with CSV files only, you can do the whole thing using the Spreadsheet String functions and/or the Read/Write from Spreadsheet File VIs.
Is this the case? If you need to do it with excel file-types you will need to use the report gen toolkit.
There are many examples for doing both. If you want specific help, share the data and/or files and what you've tried so far.
Cheers
--------, Unofficial Forum Rules and Guidelines ,--------
'--- >The shortest distance between two nodes is a straight wire> ---'
03-25-2016 10:54 AM
I guess what im asking for is this:
I would like a vi that pulls data from any colum or row from more than one excel document.
Then I would like to put that pulled data into either another excel spreadsheet or a word document in a readable friendly manner.
Are there any already made vi's for this? I sounds simple but I have a feeling it is not.
As always I'm humbled by the knowledge on this forum and thank you for anyone who helps. You will get kudos!
03-25-2016 11:13 AM
hpowel01 a écrit :I guess what im asking for is this:
I would like a vi that pulls data from any colum or row from more than one excel document.
Then I would like to put that pulled data into either another excel spreadsheet or a word document in a readable friendly manner.
Are there any already made vi's for this? I sounds simple but I have a feeling it is not.
As always I'm humbled by the knowledge on this forum and thank you for anyone who helps. You will get kudos!
A csv file is NOT and Excel type file (xlsx). It can be interpreted by Excel but it is a text file. As James said use Read Spreadsheet File.vi ( or Read Delimited Spreadsheet.vi if you have LV2015) to convert your files to 2D arrays. Then use the array functions to manipulate the data before saving it back to csv.
Ben64
03-28-2016 10:45 AM
Ok, thank you.
It does appear that the file(s) I am pulling data from are .xls
Could I use the report generation toolkit to grab specific rows and colums from multiple .xls files and put that data into a new file/report?