How to make the HTML page display the contents of an Excel file? It is imperative that this is not through saving the Excel file in HTML format “FILE> Save As> HTML Format” <<< NOT SO. Those. Excel file to be displayed in HTML in a normal format.

If it is impossible to do this, then another question: is there any program like Excel, which also had a table and the function "Conditional Formatting> Create Rule ...> Cells that contain ..." (this is for so that, for example, if I wrote the number 4 in the cell and it would turn green automatically).

I also need this file to be edited on the HTML page itself and save it.

If possible, please write the HTML code how to do it.

    2 answers 2

    Read the Excel file using PHP (for example) and output its contents through the appropriate tags - <table>,<tr>,<td> + to this, make out the content via CSS.

    And now the question is - why do you need it? Judging by the previous questions, you probably do not have enough knowledge to do it. And why do you need to be able to change the contents of an Excel file? In my opinion, you are going the wrong way.

    • I need to have a file in which there will be some data. Automatically changing the color of the text is needed in order to determine what is important, what is not (I will have red and green). I need this Excel file to be displayed in the center of the page, and I still need it so that it can be changed. But I do not quite understand how to read this file through PHP? - nick
    • it is better to store data in the database, if you have a tight situation with this - it is possible in the file - but certainly not Excel. Then look in the CSV format. But storing mutable data in a file is the last ... - Ale_x
    • DB - Do you mean Microsoft Office Access BD? Well, in principle, if there is a table, then it is fine. And then how to display the file format ACCBD in HTML? - nick
    • And yet, I forgot to say that it is necessary to be able to change it through the HTML page ... - nick
    • A database is a database (in addition to Access, there is MySQL, SQLite, MSSQL, ORACL, Transbase ...). Tell me honestly, what can you do in php? Otherwise, you are now throwing the entire forum with ridiculous questions that you can avoid by reading at least the Dummies Book. - Ale_x

    Alternatively, you can create an ActiveX component containing an Excel spreadsheet, for example, in Delphi, to insert it into a page.