Data conversion from a DAQ-binary file to an EXCEL-Spreadsheet file

[gueng]

I am sampling 8 channels per 1ms and store the datas in a binary file. After data collection I want to convert the binary file into an EXCEL file. Please can somebody how I convert a binary file into an Excel file. Thank you very much.

[Gorka Larrea]

Instead of storing data in a binary file, you could store directly in Excel format, using spreadsheet file or activeX.
Hope this helps

[gueng]

Thank you for the comment!
This is correct, but one can not sample every 1ms 8 channals and write directly into an Excel

[Gorka Larrea]

What about getting results in an array and writing it to excel when you exit? Works for me.

[gueng]

This may work, but you have to consider, I am collecting date for about 15to25minuts.
I still think it is best first to collect every 1ms the hardware syncronised data (external trigger) and store them in an Binary-File. In second phase I will postprocess the Datas bei ECEL. For this I need a converter from Binary to EXCEL.

[Gorka Larrea]

If the problem is to post proccess a binary file, use read binary file to get the info you wrote, and pass this array to Excel using activeX. At least in LV 5.0.1 under windows works fine, the read binary file vi should be in the same place write to binary file is.
After you have your data array, you can easyly open excel, create a workbook, write data and format it to achieve what you want.
Hope this time i helped