/solution-facturation

Primary LanguagePHP

Invoice Data Extraction and Geocoding Tool

This PHP script extracts client information from two Excel files and uses the Google Maps Geocoding API to retrieve geographical coordinates based on client addresses. The script leverages the PhpSpreadsheet library for reading Excel files and the Box/Spout library for efficient Excel file handling.

Features

  • Extracts client information from two Excel files (factures.xlsx and coords.xlsx).
  • Retrieves geographical coordinates (latitude and longitude) for client addresses using the Google Maps Geocoding API.
  • Filters and displays client information based on extracted data.

Prerequisites

  • PHP 7.2 or higher
  • Composer (for dependency management)
  • Google Maps Geocoding API key

Contributing

Contributions are welcome! 🎉 Please open an issue or submit a pull request for any changes.