Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

Font styling in a csv file

Is there any way to create a csv file & somehow identify cell formatting (font sizes, colors, etc.)?

I'm writing the csv file in php on a web server, to be downloaded to Excel.

I will not be surprised if the answer is no.

Thanks
0
Richard Korts
Asked:
Richard Korts
  • 4
  • 3
  • 2
  • +2
1 Solution
 
TelnetServicesCommented:
Hi There

By definition, a CSV file is a "plain text" file http://en.wikipedia.org/wiki/Comma-separated_values

That said - excel can actually open HTML directly (some "XLS" files downloaded from report generators are really HTML files in disguise!)

It's easy and just requires you setting a content type - you can then create a formatted HTML table

See http://mattiasgeniar.be/2008/06/04/creating-excel-files-through-php/ for a guide
0
 
HainKurtSr. System AnalystCommented:
NO :)
0
 
HainKurtSr. System AnalystCommented:
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
dsmileCommented:
NO WAY!

CSV is just text file, it CANNOT contain format
0
 
ghodderCommented:
If you want to create a file in PHP to view in Excel I would recommnd PHPExcel. It can output to XLSX (Office 2007/2010) and is quite good for the purpose.
0
 
Richard KortsAuthor Commented:
To TelnetServices:

Should the output file being created in php have an .xls extension or htm (or html)?

I presume I just build html tables in the body to represent the Excel equivalent?

Can I use embedded CSS (not a separate css file, but in the html)?

This sounds like an EXCELLENT solution.

Thanks!
0
 
Richard KortsAuthor Commented:
Works VERY easily!
0
 
TelnetServicesCommented:
Sorry - missed your comment - but yes basically all the formatting (more or less) will come through as you expect it to.

Glad it works for you - thx for the points :)

Steve
0
 
Richard KortsAuthor Commented:
TelnetServices:

The only thing it does that's sort of odd is that one column is (on some rows) moderately lengthy text, it wraps the cell so a FEW of the rows are "double deep" (in Excel).

I'm thinking of trying to overcome this by determining the maximum width I will need (based on font & number of characters in text) & set a html width parameter for that column based on that value.  

Think that would work?

Thanks
0
 
TelnetServicesCommented:
I think so - the issue is with excel, it tries it's best to maintain the look of the document (rather than maintain structure as such)

Give it a go.
0
 
Richard KortsAuthor Commented:
To TelnetServices:

I'm trying to add other formatting. Specifically, row background color. I tried using the traditional <tr bgcolor="hex value">. It puts the background color at dark gray, no matter what.

I also used css style, same result.

Any thoughts?

Maybe I have to do it at the <td> level?

Thanks
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 3
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now