ni.com is currently undergoing scheduled maintenance.

Some services may be unavailable at this time. Please contact us for help or try again later.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

multi spread sheet files, continuously.

I am figuring out how to read the multi spreadsheet files continuously, 
i tried bundled them and add them together but it dint came out as i expected.

the progrram i attched is fully working but only for 1 file.
anyidea how to make it to read many spreadsheet files and show as weekly, or monthly data analysis

0 Kudos
Message 1 of 11
(3,887 Views)

Hi mintonemin,

 

use a loop to read more than one file.

It would also help not to use a file constant for the filename...

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 2 of 11
(3,873 Views)

I have been out town, didnt really get how to do with while loop.
can show me example?

0 Kudos
Message 3 of 11
(3,845 Views)

anyone!? 😞

0 Kudos
Message 4 of 11
(3,815 Views)

Use "Read from Spreadsheet File" inside a loop. Concatenate the "all rows" output. When done you'll have all the rows from all the files concatenated into a 2D array. I'll leave you to figure how to feed the file names to the loop.

0 Kudos
Message 5 of 11
(3,808 Views)

I dun get the meaning of how to concentrate the file.
can show me the example? 

0 Kudos
Message 6 of 11
(3,777 Views)

Try the attached vi.

-----

The best solution is the one you find it by yourself
0 Kudos
Message 7 of 11
(3,772 Views)

We keep getting file is not a resource file. 
i attached 4 example file . 

0 Kudos
Message 8 of 11
(3,764 Views)

What is the file format you are using? If you are using .csv file format use *.csv in the pattern (Sorry I haven't included * in that) then you will get only the required files.

-----

The best solution is the one you find it by yourself
0 Kudos
Message 9 of 11
(3,759 Views)

we did that too. 
it still show the same error.

0 Kudos
Message 10 of 11
(3,756 Views)