Trim values in ".xlsx" dataplugin.

[Kevin_McG]

Hello,

I have a few dataplugins I have created for .xlsx file types, and I cannot find a way to trim the data like I can with a text file.

In my .csv or .txt dataplugins I use File.Delimiters.TrimCharacters = " ", so I guess I'm looking for something that performs the same.

Thanks.

[Brad_Turpin · Accepted solution]

Hi Kevin,

As of DIAdem 2015 this formatting option is not available for the Spreadsheet Reader.  Your only option is to parse the cell values one at a time with VBScript (the Replace command would be useful here) and then assign those parsed and sub-datatyped values directly to the Channel.Values(i) array.

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[Kevin_McG]

That is what I was hoping to avoid, but it'll have to do if that's the only way.

Thanks Brad.