We create csv file and then mail it as an attachment by using XMIT command.
I want to know that if there is a way to modify the csv file properties from mainframe code? For ex if I want to make content of one particular cell in csv file as bold, how can I do this?
Just for reference, We use following code to create the file
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
AFAIK, not without involving some third party tool/utilities. Because, you cannot send a message from the mainframe and have the body of the message in anything except plain text characters. This is one of the Internet standards not a choice (unless I missed some memo).
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
I'm confused.
What happens to these csv files after you email them? It would seem to me that the potential answer lies in what is done with them at that point. If I were to receive a csv file and open it up on my desktop with Notepad, I don't think I'd be able to see any special formatting.
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
If you go into Microsoft Excel and get help on CSV files, you will find:
Quote:
CSV (Comma delimited)
This file format (.csv) saves only the text and values as they are displayed in cells of the active worksheet. All rows and all characters in each cell are saved. Columns of data are separated by commas, and each row of data ends in a carriage return. If a cell contains a comma, the cell contents are enclosed in double quotation marks.
If cells display formulas instead of formula values, the formulas are converted as text. All formatting, graphics, objects, and other worksheet contents are lost. The euro symbol will be converted to a question mark.
Since EXCEL only saves the text and values (not the formatting), why are you wanting to create something that Excel won't handle? In other words, it generally is not possible (without writing your own processing program on the PC) to use bold or other attributes in a CSV file.