DSC Log Insert Names To Spreadsheet Header

[Fibo]

Hello,

I'm using DSC to log, and use a "Write Traces to Spreadsheet File.vi" to export to a spreadsheet.  My question is, is there a way I can include only the trace name in the header of the spreadsheet?  Right now when I include names in the header it's the entire path where the trace is on my computer (i.e. C://mydocuments/user/labview/folder/folder/folder/Trace1) which is huge, I just need Trace1... just the name.

If there's no autamated way to do it with the "Write Traces to Spreadsheet File.vi" I can create my own header on the side and insert it, or write every name individually, it's just nice that it can automatically pull the whole path, so it would be great if it could pull just the names,

much thanks!

[Kareem_W.]

Hi Fibo,

This will take a little research. Let me look into it.

Thanks

[Fibo]

Thanks I appreciate it

[Kareem_W.]

Fibo,

I did a bit of research and found that the headers that you currently see are the default format in LabVIEW. If you would like to change the format (i.e. show only the trace name rather than the path) you will have to do so after the fact. Thus, you would have to create the spreadsheet file with the full path as the header, then use a "read spreadsheet file VI" to programmatically make changes. As for using your own header, yes you can do that as well. But again, you would have to do so after the fact. I have included link to an example of creating a simple header for you to use as a starting point.

Go to: www.ni.com/community

Search for: Add a Simple Header to a Spreadsheet