Solved

Font styling in a csv file

Posted on 2011-09-20
11
290 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 51

Expert Comment

by:HainKurt
ID: 36570972
NO :)
0
 
LVL 51

Expert Comment

by:HainKurt
ID: 36570985
0
 
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
This article discusses four methods for overlaying images in a container on a web page
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

743 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now