Greeting folks!

Are any of y'all of anyway to include Excel formatting characters in a CSV file?

THX in advance for your helpful replies!

~Doc

------------------------------
Doc Ruckel
Part time programmer
Rocket Forum Shared Account
------------------------------

Hi,

I don't think you can add Excel Formatting Characters to a CSV File. Since it's basically comma separated strings.  We have created Excel File using Excel XML which does allow for styling and many other Excel functions.

Regards, Sam

------------------------------
Sam Powell
President/Developer
Advanced Transportation Systems Inc
Colorado Springs CO US
------------------------------

---

Hi,

I don't think you can add Excel Formatting Characters to a CSV File. Since it's basically comma separated strings.  We have created Excel File using Excel XML which does allow for styling and many other Excel functions.

Regards, Sam

------------------------------
Sam Powell
President/Developer
Advanced Transportation Systems Inc
Colorado Springs CO US
------------------------------

Thanks much, Sam!

---

Thanks much, Sam!

I assume you want the CSV to have the formatted display value.

You can use the Excel TEXT function in another column to create a formatted string that would go in the CSV as displayed. Keep in mind that if you import that back into a spreadsheet, Excel will likely translate it back to the original value unless you use the Import Wizard and tell it the column is text.

________________________________________________
Sam Beard
Systems Engineer
8215 S. Elm Place, Broken Arrow, OK 74011
sambeard@micahtek.com
www.micahtek.com
Phone: 918.449.3300 x3035
Fax: 918.449.3301

[Description: facebook] [Description: m-icon]

[Description: cid:image004.png@01D488B1.580182F0]
"SOLUTIONS you need for the GROWTH you desire!"
This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any wrongful transmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. MicahTek reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions.

---

Greeting folks!

Are any of y'all of anyway to include Excel formatting characters in a CSV file?

THX in advance for your helpful replies!

~Doc

------------------------------
Doc Ruckel
Part time programmer
Rocket Forum Shared Account
------------------------------

If you're open to the experience, you could use python's Excel library to add anything you want to your spreadsheet, and even save it with a .xlsx extension so it opens right up without the user having to figure anything out.

------------------------------
Marcus Rhodes
marcus1@thinqware.com
------------------------------

---

Greeting folks!

Are any of y'all of anyway to include Excel formatting characters in a CSV file?

THX in advance for your helpful replies!

~Doc

------------------------------
Doc Ruckel
Part time programmer
Rocket Forum Shared Account
------------------------------

Not in a CSV file but there is an alternative.  For our reports I create them as tab-delimited.  If I want any formatting use .html.  I then run the file through a subroutine that converts the tab-delimited file into an .html table.   After that I change the suffix to ".xls" and it opens right up in Excel (with one complaint from Excel) and all of the formatting is there.

I attached the program I use below.  It also handles all of the column sizing.

------------------------------
Mark Vander Veen
Project Leader, System Administrator
University of Chicago
Chicago IL US
------------------------------

---

Not in a CSV file but there is an alternative.  For our reports I create them as tab-delimited.  If I want any formatting use .html.  I then run the file through a subroutine that converts the tab-delimited file into an .html table.   After that I change the suffix to ".xls" and it opens right up in Excel (with one complaint from Excel) and all of the formatting is there.

I attached the program I use below.  It also handles all of the column sizing.

------------------------------
Mark Vander Veen
Project Leader, System Administrator
University of Chicago
Chicago IL US
------------------------------

Hi,

Regarding the Python comment, we have been able to use the Excel XML feature to create the files in Universe with Styles and Rows, Cells and then run the file through a Python routine that converts it into a 'xlxs' Excel file that can then easily be opened in the users PC without any modifications or complaining from Excel.   
Only issue we have had is that when clients use wIntegrate to connect via ssh we can't convert it because wIntegrate's does not allow us to write a file to the PC that has binary characters.  However, we can do when they connect via the browser and/or use Accuterm.

Regards, Sam

------------------------------
Sam Powell
President/Developer
Advanced Transportation Systems Inc
Colorado Springs CO US
------------------------------

---