Friday, February 14, 2025
PYTHON PDF TO EXCEL on WEB
import pdfplumber
import pandas as pd
import os
from flask import Flask, request, render_template, send_file
app = Flask(__name__)
# Function to extract text from PDF and save it as Excel
def pdf_to_excel(pdf_path, excel_path):
data = []
with pdfplumber.open(pdf_path) as pdf:
for page in pdf.pages:
table = page.extract_table()
if table:
data.extend(table) # Append extracted table data
if data:
df = pd.DataFrame(data)
df.to_excel(excel_path, index=False, header=False)
return True
return False
@app.route('/', methods=['GET', 'POST'])
def upload_file():
if request.method == 'POST':
if 'file' not in request.files:
return "No file part"
file = request.files['file']
if file.filename == '':
return "No selected file"
pdf_path = os.path.join("uploads", file.filename)
excel_path = pdf_path.replace(".pdf", ".xlsx")
file.save(pdf_path)
if pdf_to_excel(pdf_path, excel_path):
return send_file(excel_path, as_attachment=True)
else:
return "No table data found in the PDF."
return '''
Upload PDF
PYTHON PDF TO EXCEL
import pdfplumber
import pandas as pd
# Function to extract text from PDF and save it as Excel
def pdf_to_excel(pdf_path, excel_path):
data = []
with pdfplumber.open(pdf_path) as pdf:
for page in pdf.pages:
table = page.extract_table()
if table:
data.extend(table) # Append extracted table data
if data:
df = pd.DataFrame(data)
df.to_excel(excel_path, index=False, header=False)
print(f"PDF converted to Excel successfully: {excel_path}")
else:
print("No table data found in the PDF.")
# Example usage
pdf_path = "B192MaduraiSouth.pdf" # Provide the PDF file path
excel_path = "B192MaduraiSouth.xlsx" # Provide the output Excel file path
pdf_to_excel(pdf_path, excel_path)
Tuesday, February 11, 2025
Steps for run the streamlit in command prompt:
Steps for run the streamlit in command prompt:
Step 1: Open the Command Line
Open the Command Prompt (Windows) or PowerShell.
Make sure Python is installed. Type this to check:
python --version
If it shows a version number, Python is installed. If not, install Python first.
Step 2: Go to the Folder Containing Your Python Code
Use the cd command to go to the folder where your Python file (e.g., app.py) is saved.
cd path/to/your/folder
Example:
If your file is in C:\projects\streamlit_app, type:
cd C:\projects\streamlit_app
Step 3: Run the Python Code with Streamlit
Run the file using Streamlit with the following command:
streamlit run app.py
Replace app.py with the name of your file.
If everything is correct, you’ll see output like this:
You can now view your Streamlit app in your browser.
Local URL: http://localhost:8501
Network URL: http://192.168.x.x:8501
Click on the Local URL or copy it into your web browser. Your Streamlit app will open!
Step 4: Check for Errors
If there’s an error (like "streamlit is not recognized"), it means Streamlit isn’t installed.
Install Streamlit by typing:
pip install streamlit
Then try running the file again.
Step 5: Stop the Streamlit Server
To stop the app, go back to the command line.
Press Ctrl + C.
Friday, July 19, 2024
install flutter
flutter install
open android studio
install flutter plugin
install dart plugin for dart language
https://docs.flutter.dev/get-started/install/windows/mobile
Install the Flutter SDK
configure to your local folder
Subscribe to:
Posts (Atom)