Adding Column Names & Metadata to Exports

Mike Schwartz mschw at athenet.net
Mon Oct 3 07:42:22 PDT 2016


> How do I add the column name & number as the first row of data in an
> export so the exported file will contain meta data about itself and be
self
> explanatory.  I'm using filepro for unix 5.0.14.
> 
> In particular, I'd like to create row 1 with the matching field name &
number,
> row 2 will contain meta data such as table name, row count, run time and
> date, and finally starting at row 3 is the exported data.  The values in
row 1
> needs to align with the values in the exported data.
> 
> Stanley

     Setup a subroutine at the bottom of your processing table that only
gets called once, but that writes the header row to the spreadsheet.  

     You will need to use the "write" command to write the header line to
the spreadsheet, then use "write" again to write the first data line, then
"write" again for each subsequent data line.  

      If you look back in the archives on this list for the work "export",
you should be able to find some sample code.  Otherwise I can dig up some
code with a header line this afternoon and send it to you.

Mike Schwartz






More information about the Filepro-list mailing list