How to read data from Excel & insert into table using CI?

[eluser]sparky672[/eluser]
[quote author="mikemiller" date="1409680679"]You could try PHPExcel - very capable library that can be used to read excel files (including xlsx)

https://phpexcel.codeplex.com[/quote]

Thank-you, I was looking at that one too.

I just need a simple function that displays an uploaded Excel sheet to the screen. I don't need to create or write Excel files or save anything to the database, so many of these plugins seem like overkill with their features.

I found an obsolete library that had a "dump" function (for just displaying the Excel file on the screen), but like I said, it's obsolete, and the download link for the "updated" version on the corresponding CI wiki page is dead.

Do I just dynamically create the table every time a user views this data, or do I create a static HTML file whenever a new Excel file is uploaded, or do I save it to the database and dynamically create the view from that... is just one issue I'm contemplating and I suppose depends on the capabilities of the library. Can the library create the HTML tables accurately or do I need to write my own function to parse it... is another issue I'm investigating.

I need a library that can take an Excel file, which contains a single sheet with multiple tables, and accurately render it on the screen. It's a Excel file the website owner will be uploading so I can dictate some of the requirements and instruct them on the proper format if needed.

I'm looking at this one too...

http://faisalman.github.io/simple-excel-php/