Hello, we want to transfer data from PostgreSQL to Excel; however, we are unable to perform summation in Excel because there is a period in "decimal" values. When we manually change the periods to commas in the columns, the summation works; however, PostgreSQL does not transfer values with commas. Can you assist us with this issue? Ultimately, we are unable to sum the columns with numerical values in the Excel file we exported as "Big Spreadsheet Exporting."

Resolved

We used the map function to manipulate Excel columns. We replaced decimal values with commas. 23.200 => 23,200

")->pipe(new Map([
    "{value}" => function($row) {
        $row["column1"] = (float) number_format((float) $row["column1"], 2, '.', '');
        if($row["column1"]  == "0") {
            $row["column1"] = "0,00";
        }
        $row["column2"] = (float) $row["column2"];
        return $row;
    }
]))