Simplest way to save saved-DSC-data to EXCEL file?

[PantsOn]

I am using DSC, and DSC is saving data under data folder. I want to extract those data to Excel file.

I would like to know how to extract those data and save those data to Excel file with example.


Thanks in advance

[Khalid]

Assuming you're referring to historical data logged in the Citadel database, there are couple of ways of exporting this data to Excel:

1. There's the "Historical Trends to Spreadsheet.vi" in your Historical Data palette. You can use this VI to take the historical data and turn it into a delimited "spreadsheet" style string. Ready to open in Excel!

2. Use MSQuery in Excel and query the database saving the results in Excel. This is described in detail in the following Knowledge Base article:

How Can I Move Data from Citadel to Another Program?

Hope this helps. And hope you were referring to Historical data..

khali
d 🙂

[Roli]

And,

3. You could use Measurement and Automation Explorer's Historical Data Viewer to export a Trace View to a TAB delimited ASCII File (if you name the file e.g. exportdata.xls it will be ready to open in Excel). Or you export it into a DIADEM data file (thus you would be "Microsoft free").
This way is more of a "manual" solution.

Hope this helps
Roland