After following the guide to display the excel table on this web page, You no longer need to install any plugins to create tables that suit your needs. You can even add formulas to each cell in the table.
You may have or want to insert tables in web pages for any purpose, if you create a table using the normal method (table block in WordPress or text editor in Joomla) You may find it difficult to set up the table view. You may have to use a plugin to create a table that suits your needs.
By using Google Spreadsheet You can insert excel tables in web pages. With this way, You can do anything in the table as you normally do in the Application Excel. An example is the table below, Several columns in this table use formulas, You can also move between sheets.
In this guide, Mahmudan will show you how to display an Excel table on any web page without using a plugin. Follow these steps
Steps to Display Excel Tables on Web Pages
Steps 1: Upload file Excel ke Google Drive
Create a table in Excel according to your needs, then upload to Google Drive web, You must have a Google account to do this. The example used here is the Salary-Employee.xlsx file
Steps 2: Open the Excel file with Google Sheets
On the Google Drive web page, Right click the Excel file then select Open with then select Google Spreadsheet. The Google Sheets page will open in a new tab.
Steps 3: Publish to the Web
Once the file opens in Google Sheets, click the File menu then select Share then select Publish to the web
Steps 4: Embed Files
In the dialog box Publish to the web, select tabs Pin it then click the button Publish. Warning message Confirmation will appear at the top of the browser tab, click OK to confirm.
Steps 5: Copy Embed Code
Once you confirm the warning message, The embed code will appear. Copy the embed code and then paste it on your web page.
Steps 6: Paste Excel File Embed Code on Web Page
If you use WordPress, in a page or article select a block Custom HTML, then paste the code. This step is the same as when you pin <iframe></iframe> in HTML in general. If you use Joomla, in the text editor, look for the buttonInsert CodeorEdit HTML Source then paste the code.
Tips: To set the frame display size, You can add properties width=”100%” height=”260″ inside an iframe like the example below
<iframe src="https://docs.google.com/spreadsheets/d/e/2PACX-1vSxBqqX30A2cNbsoDzzjDX9jp9lLIyxlEkBvjkmQ7MS4jOopodO35h5IRKnQG1mlw/pubhtml?widget=true&headers=false" width="100%" height="260"></iframe>Results
The results are as you can see at the top of this guide. The following is a screenshot of the results of displaying an Excel table on a web page
One thing to remember, to make changes to the table, You have to do it in Google Drive.
Hope it is useful.