example.py

#!/usr/bin/env python3
"""
Example script for using the unoconvert library programmatically.

This script demonstrates how to convert Excel to PDF using the library.
"""

import os
import sys
import argparse
from unoconvert import convert


def main():
    """Main entry point for the example script."""
    parser = argparse.ArgumentParser(description='Convert Excel files to PDF')
    parser.add_argument('input', help='Input Excel file')
    parser.add_argument('-o', '--output', help='Output PDF file')
    args = parser.parse_args()
    
    # Check if input file exists
    if not os.path.exists(args.input):
        print(f"Error: Input file '{args.input}' does not exist", file=sys.stderr)
        return 1
    
    # Determine output filename if not specified
    output_file = args.output
    if not output_file:
        base, _ = os.path.splitext(args.input)
        output_file = f"{base}.pdf"
    
    try:
        # Convert Excel to PDF
        print(f"Converting '{args.input}' to '{output_file}'...")
        result = convert(
            args.input,
            output_file,
            format='pdf',
            # Additional options can be specified here
            doctype='spreadsheet',
            verbose=1,
            timeout=30,
            preserve=True
        )
        
        print(f"Conversion successful: '{result}'")
        return 0
    except Exception as e:
        print(f"Error during conversion: {str(e)}", file=sys.stderr)
        return 1


if __name__ == '__main__':
    sys.exit(main())