dat file

[<0>]

If I have one .dat file on my PC, can I open it as an .xls file in VI program? (ex: click one button to show the .dat file in .xls format)

please give some advice. Thanks

[smercurio_fc]

What does this .dat file contain? Where did it come from? An .xls file is an Excel workbook. There is no .xls display format unless you're referring to the file format, which I highly doubt.

[<0>]

Hi smercurio…
I collect the data from oscilloscope and then save it in .dat format. Please refer to my attached .dat file for referrence. Is there any way I can view the data in VI front panel using list & table function? Regarding what you've said, did you mean that if I save the data in Excel workbook, I can open it as .xls format?

Thanks for your time.

[RavensFan]

Zero,

What you attached is not a .dat file like you were talking about, but an .xlsx file, the newest Excel file format.  You should have either posted your actual .dat file and stated how it was created, (was it a text file, csv, tab limited, or from some other program).  Or posted it as a real Excel .xls file.  The vast majority of people participating in these forums don't use the latest version of Excel and thus would not have a mean of opening an xlsx file.

[<0>]

Sorry that I was unable to attached the .dat file, the brower shows the error "The file does not have a valid extension for an attachment." Instead I used Microsoft Excel to open it and save to .xls format. That was the data I get from 4 channels of oscilloscope.

[Dennis_Knutson]

First, there is no such thing as a .dat file format. From your other post, you are just giving a text file a .dat extension. You originally asked if yuo could read the file with Excel and obviously you can since it is an Excel file you posted. Since you are using the Write to Spreadsheet File to create the file, you could obviously read it with the Read From Spreadsheet File function and display the data in a table.