All Questions
56
questions
1
vote
2
answers
99
views
Error deploying app services on Azure with Python 3.9 and Flask to process Excel files
I have the following environment deployed from VS Code
enter image description here
It was deployed in App Services on Azure using Python 3.9 and Flask to create an application on a B1 plan (Total ACU:...
2
votes
0
answers
77
views
AttributeError: 'Typed' object has no attribute 'to_tree'
While saving an excel file got via file upload in a html file through flask,
Code:
from flask import *
import xlsxwriter as xw
import xlwings as xwi
app = Flask(__name__)
@app.route('/')
def index():...
0
votes
0
answers
62
views
Solution to an excel/python flask web server with xlwings
I have a complicated excel file that is a custom calculator with many formulas and macros. We input width, length, and a few other choices and get the feasibility checks, springs and tubes for the ...
0
votes
1
answer
904
views
How to display an Excel file on a website in html using flask?
I am creating a website in html and flask to which you can upload an xlsx file. I need to do this so that I can view the sheets of this file. I have already created a file addition and output the ...
0
votes
0
answers
79
views
How to send csv file and xlsx file in chunks using flask?
I have a pandas dataframe from a query in my database, based on API parameters I want to send a file from this dataframe. The file can be csv or xlsx format. Memory is a limited resource on this case ...
0
votes
0
answers
111
views
How to import/ embed / modify an Excel file into a MS Word file using python
I need to make an Invoice that has an embedded Excel file into it. This file either should be imported from a different Excel file, or complete the values for a pre-existing embedded excel object in ...
0
votes
0
answers
39
views
How to download a file from my flask website hosted on Google Cloud Platform?
My flask website uses few excel files for indexing and searching details.
I've uploaded the excel files and python(flask) code on Google Cloud Platform.
The website works seamlessly, as intended and I ...
0
votes
1
answer
163
views
Backend - Queue for Excel Macro
I have a really big problem about finding the right architecture and for the following;
I have a VBA Macro which retrieves the parameters from one sheet, calculates an algorithm (it takes time) and ...
0
votes
1
answer
411
views
statsmodels.tools.sm_exceptions.Infeasible Test Error: The x values include a column with constant values and so the test statistic cannot be computed
This code is taking an excel file as input which has several columns with same value in a column which is causing the error ang giving wrong output. This code works right in jupyter notebook but fails ...
0
votes
1
answer
395
views
Read Value of Columns in Excel
I want to insert values from Python into an Excel sheet. I can't figure out the way to go about this. I would like to make a for-loop to determine the last entry in column[0] (vertically) in my Excel ...
-1
votes
2
answers
833
views
How to allow users to download an excel file using python/Flask?
I have a method that takes in an excel file, read the excel file, extracts data from it and save. The issue I am having now is how to write a method that returns the excel file and allow users to ...
1
vote
1
answer
1k
views
How can i download excel file with using Flask and React?
I am trying to download xlsx file. I post an id and using it to get data from database. Then i can create an excel file but i couldn't download it.
My backend codes:
from flask import Flask
from flask ...
-1
votes
1
answer
39
views
On editing Excel file using python, the changes are not reflecting until we open it
Before opening the excel file
After opening the excel file and after the values appear in excel.
I need this because I need to use the output of this excel in some other calculations. How do I make it ...
1
vote
1
answer
871
views
Download HTML table to Excel by using Javascript
In my Flask application, I created a button to extract the content of an HTML table into an Excel file. I used Javascript to extract from my interface the content of my HTML table in Excel format.
...
0
votes
1
answer
400
views
Build excel as in-memory object to be dowloaded
In python I have a flask server with and endpoint at which users can request for data to be download when they press a button in the template. Until now I returned the data as a csv file:
df_results = ...