Incorrect Data Length After Save TDMS File as ExcelTDM File

Updated Jan 20, 2021

Issue Details

I have generated a TDMS file by using FlexLogger. After saving the TDMS file as ExcelTDM, although both TDMS and Excel files show the similar data length of 10,511,360, the total number of the data row is just 1,048,576.

Kindly refer to the image below to understand my situation better.



Solution

This is an expected behavior because the maximum number of rows supported by Microsoft Excel is 1,048,576. Therefore, although 10,511,360 data are provided, the number of data is capped at the maximum number of rows supported by Microsoft Excel. To be able to retrieve all 10,511,360 data, kindly refer to the article provided in the Related Links section of this article.