import sys
from pathlib import Path
try:
    from PyPDF2 import PdfReader
except Exception:
    PdfReader = None
try:
    import pandas as pd
except Exception:
    pd = None

def main(pdf_path):
    if PdfReader is None:
        print("PyPDF2 not installed.")
        return 1
    if pd is None:
        print("pandas not installed.")
        return 1
    p = Path(pdf_path)
    if not p.exists():
        print(f"PDF not found: {pdf_path}")
        return 1
    reader = PdfReader(str(p))
    texts = []
    for page in reader.pages:
        txt = page.extract_text() or ''
        for line in txt.splitlines():
            if line.strip():
                texts.append(line.strip())
    df = pd.DataFrame({"Text": texts})
    out_name = p.with_suffix('.xlsx').name
    out_path = p.parent / out_name
    df.to_excel(out_path, index=False)
    print(f"Wrote {out_path}")
    return 0

if __name__ == '__main__':
    sys.exit(main(sys.argv[1] if len(sys.argv) > 1 else 'tieng Myanmar - 1 to 5.pdf'))