Jython Script for SQL Record set export to Excel
edited Sep 8, 2020 5:07AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 15 commentsAnswered
Hello Gurus,
Due to obsolete VB API's, I am working on VB to Jython script conversion from FDM to FDMEE. I am stuck at a place where SQL Record set Data to be exported to Excel.
In FDM VB, we do have similar API "DataWindow.Utilities.mRecordsetToExcel CStr(strRecordsetDesc), rsExport" which converts record set to Excel. where as My below scripts succeeded but no Excel File generated at OutboxDir.
Request you to have your inputs and appreciate your help in advance.
=======================================
# Used to specify the file encoding
import codecs
import java
import os
import sys
#Purpose: Export any FDM table to Excel, just specify the name in strTableName variable
1