PHP Classes

What is the best PHP export excel class?: Trying to export query to an Excel file

Recommend this page to a friend!
  All requests RSS feed  >  What is the best PHP export excel class?  >  Request new recommendation  >  A request is featured when there is no good recommended package on the site when it is posted. Featured requests  >  No recommendations No recommendations  

What is the best PHP export excel class?

Edit

Picture of Kevin Rank by Kevin Rank - 8 years ago (2017-01-06)

Trying to export query to an Excel file

This request is clear and relevant.
This request is not clear or is not relevant.

+4

I am looking to export to Excel where I can set a column as text since it has leading zeros and excel drops them.

  • 1 Clarification request

  • 1. Picture of Oleg Zorin by Oleg Zorin - 8 years ago (2017-01-10) Reply

    Also you can check for phpExcel library - very powerful tool for creating Excel files. Library contains both Writer and Reader.

    Ask clarification

    2 Recommendations

    Niger: Query MySQL to generate data exports

    This class can query MySQL to generate data exports.

    It can connect to MySQL using MySQLi and execute arbitrary queries.

    It can create CSV files with data from database query results and have the files split when they exceed a given number of lines.
    This recommendation solves the problem.
    This recommendation does not solve the problem.

    +1

    Picture of Hassane Moussa by Hassane Moussa package author package author Reputation 495 - 7 years ago (2017-05-01) Comment

    Bonjour,

    Vous pouvez regarder le Package de la classe Niger (Query MySQL to generate data exports). Je suis disponible tout éclaircissement !!!

    PHP HTML Excel: Convert HTML to Excel spreadsheets

    This class can convert HTML to Excel spreadsheets.

    It can take the HTML of a table rows and headers, as well optional CSS, and generates a file that can be opened as a spreadsheet in Microsoft Excel.

    The class can serve the Excel file for download using the appropriate headers for making it open in Excel or equivalent server in the user machine.

    This class is able to create Excel spreadsheets directly from HTML tables. It is possible to use CSS for styling.
    This recommendation solves the problem.
    This recommendation does not solve the problem.

    +1

    Picture of Manuel Lemos by Manuel Lemos Reputation 26695 - 8 years ago (2017-01-09) Comment

    One less known information about Excel is that it can open HTML files with tables as spreadsheets. This class allows you to do so.

    Recommend package
    : 
    :