Python Forum
Help in opening and editing an excel workbook from a web-browser
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Help in opening and editing an excel workbook from a web-browser
#1
Hi!
I am not sure if this can be done with flask.

I have an excel template and a web-page. What i want is to be able to open a copy of the template with a button click from the browser, be able to edit this copy and save it.

It would be great if I could open, view and edit this copy within the browser, but even if it happens outside of the browser, I should be able to work with it.

Could anyone please tell me where I should look to get info on such a thing? Cursory googling was not helpful.

Thanks!
Reply
#2
I never had the need to manipulate Excel in a browser, but PHP has an Excel module to do that.

Look here.

It is probably easier to set up a database table with the format of your Excel. Can always be exported.

Then you can use pymsql to do things to columns and or rows.

If I open an Excel file in Libre Office, the menu File has a menu item, "Preview in web browser", but I don't think you can edit it.

I'm not really much help, am I.
Reply
#3
Maybe I'm missing the point, but is that not what Google Sheets is for (editing an Excel file, from within a Web Browser)?
Sig:
>>> import this

The UNIX philosophy: "Do one thing, and do it well."

"The danger of computers becoming like humans is not as great as the danger of humans becoming like computers." :~ Konrad Zuse

"Everything should be made as simple as possible, but not simpler." :~ Albert Einstein
Reply
#4
(Aug-09-2022, 09:22 AM)rob101 Wrote: Maybe I'm missing the point, but is that not what Google Sheets is for (editing an Excel file, from within a Web Browser)?

Actually, I am making an interface for patient management where this comes in handy. It is being designed to work offline...
Reply
#5
(Aug-09-2022, 08:26 AM)Pedroski55 Wrote: I'm not really much help, am I.

Heyy!
Thank you for the response! Your response helped my indirectly Smile
I am not great at programming and looks like I'd have to get comfortable with a bunch of things before I can use your fix.
My use case is that I need an excel template to be copied and opened each time a new record is being entered. The excel template contains formulae and should allow data entry so that the formulae can be used (this is very easy to do in excel, so I wanted to stick with this).

What i ended up doing, is opening the local file with a button click using:
Error:
start wps <path>
, which gets the job done.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  How to copy work sheet data one workbook to other? sayyedkamran 2 645 Nov-03-2023, 09:10 AM
Last Post: Larz60+
  xlwings error when reading a workbook Mishal0488 1 1,037 Aug-01-2023, 02:05 AM
Last Post: deanhystad
Question Opening small size browser with python selenium not work, need help greenpine 0 1,587 Feb-07-2022, 11:36 AM
Last Post: greenpine
  Add a new column when I extract each sheet in an Excel workbook as a new csv file shantanu97 0 2,191 Mar-24-2021, 04:56 AM
Last Post: shantanu97
  [split] openpyxl workbook module not callable yosoyebj 1 2,739 Sep-14-2020, 10:18 AM
Last Post: buran
  Facing issue while saving workbook Abhisht 3 5,507 Aug-19-2020, 11:44 AM
Last Post: Larz60+
  Saving Excel workbook file with dataframe names Biplab1985 0 1,993 Jun-07-2020, 12:25 PM
Last Post: Biplab1985
  Need to identify sheet color in excel workbook chewy1418 2 2,447 Feb-14-2020, 03:26 PM
Last Post: chewy1418
  Need to copy column of cell values from one workbook to another with openpyxl curranjohn46 3 11,083 Oct-12-2019, 10:57 PM
Last Post: curranjohn46
  Manipulating an Excel Workbook Stanimal 4 2,949 Jan-18-2019, 11:03 PM
Last Post: Stanimal

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020