In my shop, we have a process which runs few "JCL's" on mainframe environment and prepares some data in the report format (basically just a text).
Then we send that file as attachment to users. the attachment goes as CSV file.
My rquirement is ----
I want to format this report. Like changing color of Title / adding subtotals etc.
Currently when users receive csv file, they open it in excel they can see the plain data and have to format it manually.
Is there any way i can preset this format. So whenever user will open this CSV file, he will automatically see the formated data ...
Then we send that file as attachment to users. the attachment goes as CSV file.
My rquirement is ----
I want to format this report. Like changing color of Title / adding subtotals etc.
Currently when users receive csv file, they open it in excel they can see the plain data and have to format it manually.
Is there any way i can preset this format. So whenever user will open this CSV file, he will automatically see the formated data ...