We can export views to Tabular text, structured text, or lotus 1-2-3. But not to any other file types like Excel which is what people often need. Here is a simple way to export a view directly to Excel (.xls) format and launching directly in Excel. But you still got to save this file in Excel though its extension is .xls.
@Command([OpenView];"test"); @Command([FileExport];"Lotus 1-2-3";"c:\dump.xls"); @Command([Execute];"C:\msoffice\office\excel.exe";"c:\dump.xls")
The code above opens 'test' view in the current database, exports it to a file called dump.xls (though its extension is xls, and in Windows Explorer, it displays as Microsoft Excel worksheet, it is still in lotus 1-2-3 format. The last line opens the file in Excel. Now you can save the file in Excel format.
This was first published in June 2002