How to write in my excel file by taking data from an HTML form under the previous data in next rows?

Question

This is my basic flask route

@app.route('/home/form', methods=('GET','POST'))            
def form():
    if request.method == 'POST':
        machine = request.form['machine']
        df = pd.DataFrame([[machine]], columns=["Machine"])
        with pd.ExcelWriter('P:\\Rohaan\\LATEST WEBSITE\\sample.xlsx') as writer:
            df.to_excel(writer)

        if not machine:
            flash('Title is required!')
        else:
            return redirect(url_for('home'))
    return render_template('form.html')

if __name__ == "__main__":
    app.run(debug=True)

My form.html that I retrieve data frame

HTML Code

<form method="post">
  <label for="Machine">Machine</label>
  <br>
  <input type="text" name="machine"
        placeholder="Message machine"
        value=''></input>
  <br>

  <label for="content">Message Content</label>
  <br>
  <textarea name="content"
            placeholder="Message content"
            rows="15"
            cols="60"
            ></textarea>
  <br>
  <button type="submit">Submit</button>
</form>

Currently getting this result using this code

My question is:

Why the incoming data override my previous data?

currently it is clearing the whole data in excel file and making a new entry — Rohaan Sheikh, Apr 21 '22 at 09:57
I got the code limit, by the way I have answered my HTML code — Rohaan Sheikh, Apr 21 '22 at 10:15

score 0 · Answer 1 · answered Apr 21 '22 at 10:02

Currently getting this result using this code

@app.route('/home/form', methods=('GET','POST'))
def form():

if request.method == 'POST':
    machine = request.form['machine']
    df = pd.DataFrame([[machine]], columns=["Machine"])
    with pd.ExcelWriter('P:\\Rohaan\\LATEST WEBSITE\\sample.xlsx') as writer:
        df.to_excel(writer)

    if not machine:
        flash('Title is required!')
    else:
        return redirect(url_for('home'))
return render_template('form.html')
if name == "main": app.run(debug=True)

you should put it in the question – Yedidya Rashi Apr 21 '22 at 10:09 — Yedidya Rashi, Apr 21 '22 at 10:09

score 0 · Answer 2 · answered Apr 21 '22 at 10:11

0

According to documentation you should specify mode = "a" if you want to append and not override (default is mode = "w") inside ExcelWriter, but if it is actually supported is probably dependent on the chosen excel engine.

answered Apr 21 '22 at 10:11

Grekkq

679
6
14

ValueError: Append mode is not supported with xlsxwriter! – Rohaan Sheikh Apr 21 '22 at 10:21
Exactly as i said it is dependent on used engine, you can refer to [this](https://stackoverflow.com/questions/54863238/pandas-excelwriter-valueerror-append-mode-is-not-supported-with-xlsxwriter) – Grekkq Apr 21 '22 at 10:34

score 0 · Answer 3 · answered Apr 21 '22 at 10:14

0

HTML Code

<form method="post">
  <label for="Machine">Machine</label>
  <br>
  <input type="text" name="machine"
        placeholder="Message machine"
        value=''></input>
  <br>

  <label for="content">Message Content</label>
  <br>
  <textarea name="content"
            placeholder="Message content"
            rows="15"
            cols="60"
            ></textarea>
  <br>
  <button type="submit">Submit</button>
</form>

answered Apr 21 '22 at 10:14

Rohaan Sheikh

51
2

You should put it in the question – Yedidya Rashi Apr 21 '22 at 10:41

How to write in my excel file by taking data from an HTML form under the previous data in next rows?

3 Answers3