4.9 sdds2spreadsheet

• description: sdds2spreadsheet converts an SDDS file to a file that can be read into most spreadsheet programs. You need to consult your particular spreadsheet program to see how it reads ASCII files. For Wingz, the conversion is automatic. Excel 5.0 will bring up its Text Import Wizard.

  Notes:

  1. Excel lines must be shorter than 255 characters. The Wingz delimiter can only be \t.
  2. The program sddsprintout with the -spreadSheet option is intended to replace the function of sdds2spreadsheet. It allows greater control of what data is output and how it is formatted.
• examples: Convert a snapshot to a Wingz spreadsheet.

  sdds2spreadsheet par.050695.snap par.050695.wkz

  Convert a snapshot to an Excel text file.

  sdds2spreadsheet par.050695.snap p050695.txt

• synopsis:

  sdds2spreadsheet [SDDSfilename] [outputname] [-pipe[=input][,output]] [-delimiter=string] [-all] [-verbose]

• switches:
  • pipe — The standard SDDS Toolkit pipe option.
  • delimiter — Delimiter string (Default is ”).
  • all — Write parameter, column, and array information. (Default is data and parameters only)
  • verbose — Write header information to the terminal like sddsquery.
• author: K. Evans, Jr., ANL/APS.