LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Help with Report Generation Tool kit

Currently having an issue with the Data being shown on the Excel Worksheet. Previously I had a sample rate of 10,000 Hz and a finite sample amount of 2000. Which would work with my program and display the data every time sampling collection interval. The new finite sample amount is 125000 to equate to 12.5 seconds of capture time which would relate to the gears output I am trying to acquire. Unfortunately looking at the probe all the data is being collected I'm just not seeing the output of data collected in Excel. Below I'm attaching a snippet of code which shows all the data collection information.

0 Kudos
Message 1 of 4
(2,706 Views)

After researching Excels column limit I believe that is the issue, but i'm not sure of a good work around just yet if anyone has suggestions? Excel column limit is 16,384. 

0 Kudos
Message 2 of 4
(2,694 Views)

How many rows do you have? Can you transpose your data?

0 Kudos
Message 3 of 4
(2,674 Views)

Were you able to get Excel to "keep up" when you sent 10KHz data 2000 points at a time?  If you want to send 12.5 seconds of data, but need to keep each "chunk" under 16K rows, why not send 5000 points at a time?  When you've done this 50 times, you'll have 12.5 seconds of data, and will have "worked around" Excel's Column limit.

 

Bob Schor

Message 4 of 4
(2,652 Views)