04-29-2015 01:47 AM
Or you go the whole way and use ODS tagsets.excelxp to create a .xml file containing the report, which can be opened by excel.
05-21-2015 06:01 AM
KurtBremser has provided the answer, ods tagsets.excelxp is the (well, one of the) the ods destinations to create Excel files. So in your script do:
ods tagsets.excelxp file="abc.xml";
ods tagsets.excelxp close;
05-21-2015 06:11 AM
Adding to what RW9 already stated, to help with further automation we would need to know specifics about your environment (single machine installation vs. client/server with Enterprise Guide, operating system of server, possible connections between server and client like Samba or Netware, and so on)