The default output of a report in JDE is PDF file.The report can be designed to generate csv ( along with PDF) as well. But at times an excel file is required instead of csv.
Here is the way
1) Write the Data to a abc.txt file using one of the BSFN APIs.The fields/columns have to separated by TAB.
2) Now after writing all the data, rename the file to abc.xls
3) Here comes the catch, JDE tool set does not allow to type TAB character.So you can open notepad, press TAB key, copy it and paste in JDE. :)
Here is the way
1) Write the Data to a abc.txt file using one of the BSFN APIs.The fields/columns have to separated by TAB.
2) Now after writing all the data, rename the file to abc.xls
3) Here comes the catch, JDE tool set does not allow to type TAB character.So you can open notepad, press TAB key, copy it and paste in JDE. :)
No comments:
Post a Comment