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.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
@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.