LabVIEW
How do I read from a text file that is longer than 65536 lines and write the data to an Excel spreadsheet and have the data write to a new column once the 65536 cells are filled in a column?
Solved!
If the above scenario is correct, this is one solution.
You could initialize a 2D array outside of while loop A.
Put while loop B inside while loop A.
In loop B, add values to an array until the array gets 1600 values long (or whatever number you want).
Then exit B, and append that array to a 2D array, this will make a new column.
You will need some more logic to get the data, because in my example, the data comes from a numeric control.
If your data right now is in a really long 1D array (in LabVIEW) it should be easy enough. Just read in a subset of data,
then in the next iteration, read the next subset of data, beginning where the last one left off.
No need to use nested For loops. No need for any loop anyway. You just have to use a reshape array function. The picture below shows how to proceed.
However, there may be an issue if your element number is not a multiple of the number of columns : zero value elements will be added at the end of the last column in the generated 2D array. Now the issue depends on the way you intend store the data in the Excel spreadsheet : you could convert the data as strings, replace the last zero values with empty strings, and write the whole 2D array to a file (with the .xls extension ;)) using the write to spreadsheet function. Only one (minimal) problem : define the number of decimal digits to be used;
or you could write the numeric array directly to a true Excel spreadsheet, using either the NI report generation tools or ActiveX commands, then replace the last elements with empty strings.
We need more input from you to decide how to solve these last questions.
Here is a possible solution to the (potential) problem. Convert to a string array and erase the added data before writing to the file
