One solution would be to use the PHP_EOL constant when creating the string that will be transferred to Google Sheets. This constant represents the correct end-of-line character for the platform being used. For example:
$data = "First line" . PHP_EOL . "Second line";
This will ensure that the new line character is correctly added at the end of each line, regardless of the platform being used.
Another solution would be to use a library or package that handles data transfers between Laravel and Google Sheets, such as the Google Sheets API or a third-party package like Laravel Excel. These tools often have built-in support for handling new lines correctly.
Asked: 2022-12-26 11:00:00 +0000
Seen: 11 times
Last updated: Dec 31 '21