How to retrieve data from excel to html?

HTML & CSS
1

I have to prepare a draft for a page which includes many peoples biodata. In that process.

Lets say we have a data in excel format:

Name: XXXX

Sex: Male

Age: YY

Area of Interest: Linear algebra, Matrix Methods

I have the following questions:

  1. Is there any way to get the data from excel to html code like
<div class="all-data">
<div class="head"> XXXX </div>
<div class="data"> 
<table>
<tr>
<td> Age </td> 
<td> YY</td>
</tr>

.
.
.
</table>
</div>

<div class="research_area"> Linear algebra, Matrix methods </div> 


</div>

How to get the data from excel and make a html document where I may have to take care only the css part?

2

It’s not something you can do in HTML and CSS alone. You will need to do some scripting in a backend language such as PHP. There are PHP libraries such as PHP-ExcelReader to help with reading Excel files or you could convert the Excel file to CSV and use the functions that come with PHP to read the file.

1 Like
3

You’ll need to parse the Excel sheet and process the data using a programming language of some description.

Here’s a JS library that will do the job: https://github.com/faisalman/simple-excel-js

Demo: http://faisalman.github.io/simple-excel-js/test/test.html

2 Likes
4

I knew someone would come up with a frontend alternative :smiley:

5

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.