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 email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
@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.