CODEWITHSUNDEEP
pythonhtmldjangoexcelxlsxwriter
Connor Meeks
Connor Meeks

Reputation: 501

Excel Workbook to html Django/Python

Is there any way to take an excel workbook, and display it on a webpage with the same formatting as the workbook? Im wondering if there is a way to take an excel workbook and paste the contents on a webpage. Basically im looking for something to screenshot the excel document and paste in in my webpage... Is there any way to do this??? (Maybe something similar to Zoho Viewer: https://sheet.zoho.com/sheet/excelviewer)

Current Wepbage: enter image description here

After Adding the Excel Workbook enter image description here

NOTE: I am using xlsxwriter to populate the excel sheet.

Upvotes: 2

Views: 809

Answers (2)

Sainath S.R
Sainath S.R

Reputation: 3306

should the xl file reside in your local machine? or are you open to storing it in the cloud ? Since you mentioned zoho viewer you might want to check out zoho office APIs here using which you can use the API to upload a file and get back a link with the file rendered in a xl viewer which you can paste into an iFrame etc to display it on your page.

Upvotes: 1

Jason Owens
Jason Owens

Reputation: 543

There's many ways to get around doing what you're referring to. Would you be open to using Google Sheets or do it have to be MS Excel? If so, I'd say use google drive and Google Sync. This way, you can make your excel on your local machine, save it. Create a python script that copies the file from the saved location, to the google drive on your machine. Then google drive will update/sync it. Then it's just a matter of logging into google and copying the file link, then you can use that link so long as you don't change any names of the file. I used this as a solution at one of my previous jobs because google is free and available 24/7. I hoped that helps...

Upvotes: 0

Related Questions