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,427 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,413 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,385 Views)

anyone!? 😞

0 Kudos
Message 4 of 11
(3,355 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,348 Views)

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

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

Try the attached vi.

-----

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

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

0 Kudos
Message 8 of 11
(3,304 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,299 Views)

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

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