如何使用 SQL 开发人员将数据后台打印到 Excel 工作簿中

Question

我正在尝试使用后台打印将 sql 开发人员的大数据导出到 excel 工作簿中，我的查询如下所示：

spool "D:\Data\Party.xlsx"
SELECT PARTY_NO, ACCOUNT_REF FROM HZ_PARTIES
spool off;

但是导出完成后，我无法打开 excel 工作表，我收到错误

Excel cannot open the file 'Party.xlsx' because the file format for the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

Answer 1

文件类型应为.xls而不是xlsx