0

I am trying to export excel file from the mysql as per the answer in

Exporting data to excel sheet in php. The export is successful. But I would like to know about the styles. Can I make one line bold, italic etc in the excel file? And can I insert a table using this excel export?

Thanks!

Community
  • 1
  • 1
NewPHP
  • 608
  • 2
  • 15
  • 28
  • 1
    https://www.google.com/search?q=php+excel+styling – Samuel Cook May 10 '13 at 02:08
  • Tab or comma separated value files don't contain style information, even when you give them an extension of .xls; you need a library that can write a real xls format file to do that – Mark Baker May 10 '13 at 06:45
  • 1
    In addition to my own PHPExcel library (http://phpexcel.codeplex.com) you'll find a pretty comprehensive list of other PHP libraries for writing Excel files here - http://stackoverflow.com/questions/3930975/alternative-for-php-excel – Mark Baker May 10 '13 at 07:52

1 Answers1

-1

https://www.google.com/search?q=php+excel+styling

yeilds:

PHPExcel: Coloring the cells?

PHPExcel specific cell formatting from style object

PHPExcel style problem

PHP Excel style formatting using col & row index

Style a range of cells with phpexcel

PHPexcel cannot reads styles from xls

SO is endless with information, and that's just the first page of results

Community
  • 1
  • 1
Samuel Cook
  • 16,620
  • 7
  • 50
  • 62
  • Thank you. I have searched in the google. But the style is for PHP Excel class, I am afraid. I haven't installed the PHP Excel class – NewPHP May 10 '13 at 02:15
  • 2
    working with Microsoft Excel is a nightmare. People have tried and tested different classes repeatedly. Find the best one that both fits your needs and has a high response rate, and try one. If you don't like it, don't use it. – Samuel Cook May 10 '13 at 02:17