Topic: Exporting to Excel

[jcright]

How do I go about exporting my data? I'd like to send a query, via e-mail, to myself in excel.

[kenbrody]

How do I go about exporting my data? I'd like to send a query, via e-mail, to myself in excel.

There is an EXPORT command in processing which you can use to build a CSV file, which can be loaded/imported into Excel.  I believe there is a sample file which you can download, showing exactly how to do this.  Contact fpsupport@fptech.com and ask them for it if you can't find it on the website.

In its most basic form, you create a processing-only output format with something like the following:
    export word out=/path/to/export/file
    out[1] = 1 ; out[2] = 2 ; out[3] = 3
    ' and so on, for each field that you want exported
Note that "export word" sets the default export parameters to those which Excel (as well as MS-Word) prefer.  You could explicitly set these with something like:
    export ascii out=/path/to/export/file f=, r=\n o=" c="

[kencole]

There are also a couple of 3rd party products available from members of this forum or at least members of the filePro mailing list that will then convert the CSV file to an actual Excel spreadsheet.

There are products from members that will also help with the emailing if you need help there as well.

[hjkelsheimer]

All of what Ken Brodie sz is correct. Depending on where you send the file and name it i.e. /tmp/test.txt I just use temp as the dir I like to send to. Then copy to your PC / rename the file *.csv and you should be good to go.

[Alan]

Dan Coutu at snowy owl computing has written a program that will take a csv file and create a excel file.  He can be reached at. 802 334 0251.