View previous topic :: View next topic
|
Author |
Message |
vicharapusrinu Warnings : 1 New User
Joined: 04 Dec 2006 Posts: 63 Location: Hyderabad
|
|
|
|
Hi,
Can some one help me out?
I am using XMITIP, to email CSV file as an attachment, to xxx.yyy@zzz.com
Everything is working fine, is but header is not coming properly, i.e header should be bit bold and in red colour
What changes I need to made for my below control card?
Code: |
%XMITIP xxx.yyy@zzz.com
NOMSG FILE 'AAA.BBB.CCC'
FROM xxx.yyy@zzz.com
SUBJECT 'CSV TEST FILE' FORMAT CSV
FILENAME REPORT.CSV
FORMAT CSV/W-BLUE//4///Y |
In XMITIP manual the below line has been mentioned
Quote: |
FORMAT type/option
FORMAT HTML/color/suffix/font-size/banner/table/header/wrap/semicolon |
|
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Is this header within the csv file?
I am not aware of a way to specify colors within a simple csv file. . .
Possibly i misunderstand, |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
if instead of inventing Your own parameter/keyword combination
You had followed the manual advice You might have gotbetter results
for what effing reason, since You noticed it, instead of using FORMAT CSV/W-BLUE//4///Y
You did not follow the manual' s advice to use something along the lines of
Quote: |
FORMAT HTML/color/suffix/font-size/banner/table/header/wrap/semicolon
|
if You will take some more time to meditate agian on XMITIP manual
You will easily find the explanation of the parameters needed to convert a CSV file into an HTML table
Quote: |
Table may be Yes or No (or null) and indicates that the input file is a CSV file that should be converted to an HTML table. |
at www.lbdsoftware.com/XMITIP-Guide.pdf
but refusing as You have done until now to try to understand the manual
You will just keep on wasting people time |
|
Back to top |
|
|
vicharapusrinu Warnings : 1 New User
Joined: 04 Dec 2006 Posts: 63 Location: Hyderabad
|
|
|
|
Hi Dick scherrer,
Sorry for late reply,
YES, header also is in CSV format,
it is OK, if color will not come in excel,
I am happy, at least, if font in excel in “Courier New” font.
Please accept my apologies, if I am troubling you. |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8697 Location: Dubuque, Iowa, USA
|
|
|
|
From Microsoft, you can find Excel formatting and features that are not transferred to other file formats
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.
Note If your workbook contains special font characters such as a copyright symbol (©), and you will be using the converted text file on a computer with a different operating system, save the workbook in the text file format that is appropriate for that system. For example, if you are using Windows and want to use the text file on a Macintosh computer, save the file in the CSV (Macintosh) format. If you are using a Macintosh computer and want to use the text file on a system running Windows or Windows NT, save the file in the CSV (Windows) format. |
Since .CSV saves text and values, and ONLY text and values, you cannot specify a font. |
|
Back to top |
|
|
|