Code Editor for app.py

import streamlit as st
import pandas as pd
import PyPDF2
import os

st.title('PDF to XLS Converter')

# File upload
uploaded_files = st.file_uploader('Upload PDF receipts', type=['pdf'], accept_multiple_files=True)

if uploaded_files:
    all_data = []
    for uploaded_file in uploaded_files:
        # Read PDF file
        pdf_reader = PyPDF2.PdfReader(uploaded_file)
        text = ''
        for page in pdf_reader.pages:
            text += page.extract_text() + '\n'

        # Process the extracted text
        lines = text.split('\n')
        receipt_data = []
        for line in lines:
            if line.strip():  # Skip empty lines
                receipt_data.append(line.strip())

        all_data.append(receipt_data)

    # Convert to DataFrame
    df = pd.DataFrame(all_data)

    # Save to Excel file
    output_file = 'receipts.xlsx'
    df.to_excel(output_file, index=False)

    st.success('Conversion successful! Download your file below:')
    st.download_button('Download XLS', output_file, file_name='receipts.xlsx')