Export your view directly to Excel

Here is a simple way to export a view directly to Excel (.xls) format and launching directly in Excel.

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

Dig Deeper

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchWindowsServer

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchEnterpriseLinux

SearchDataCenter

SearchExchange

SearchContentManagement

Close