Solved

Font styling in a csv file

Posted on 2011-09-20
11
294 Views
Last Modified: 2012-05-12
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
Comment
Question by:Richard Korts
  • 4
  • 3
  • 2
  • +2
11 Comments
 
LVL 7

Accepted Solution

by:
TelnetServices earned 500 total points
ID: 36570967
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
 
LVL 52

Expert Comment

by:Huseyin KAHRAMAN
ID: 36570972
NO :)
0
 
LVL 52

Expert Comment

by:Huseyin KAHRAMAN
ID: 36570985
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
LVL 13

Expert Comment

by:dsmile
ID: 36571711
NO WAY!

CSV is just text file, it CANNOT contain format
0
 
LVL 9

Expert Comment

by:ghodder
ID: 36572350
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
 

Author Comment

by:Richard Korts
ID: 36574481
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
 

Author Closing Comment

by:Richard Korts
ID: 36581405
Works VERY easily!
0
 
LVL 7

Expert Comment

by:TelnetServices
ID: 36584349
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
 

Author Comment

by:Richard Korts
ID: 36584375
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
 
LVL 7

Expert Comment

by:TelnetServices
ID: 36584392
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
 

Author Comment

by:Richard Korts
ID: 36590297
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question