'Hebrew send to google spreadsheet from PowerShell Hebrew correctly

enter image description herePlease help. In console look hebrew correct but in spreadsheet is not correctenter image description here

    $import = New-Object System.Collections.ArrayList($null)  
$import.Add( @("route_id"))
$import.Add( @( 'אבא אבן 1 הרצליה' ))  | Out-NULL
               
 
try {
    
   $Response = Set-GSheetData -accessToken $accessToken -rangeA1 "A1:X$($import.Count)" -sheetName "23-07-21" -spreadSheetID $SpreadsheetID -values $import -Verbose 
   $Response | ConvertTo-Json
   
} catch {
    $err = $_.Exception
    $err | Select-Object -Property *
    "Response: "
    $err.Response
    }

enter image description here

powershellgoogle-sheetsencodinghebrew


Solution 1:[1]

Hebrew might not be supported in Sheets, you would need to install a font. You can try with this one

https://fonts.google.com/noto/specimen/Noto+Sans+Hebrew?query=hebrew

Update

After testing using the Rest API, it works, so the issue might be related on how the PowerShell process hebrew characters.

I've found some information on how to process hebrew characters in the Windows Powershell

[Console]::OutputEncoding = [Text.Encoding]::GetEncoding(1255)

Make sure the console is outputting the right characters and the POST a request to Google Sheets

Solution 2:[2]

It's bug in the psmodule. Author must specify encoding UTF8. https://github.com/umn-microsoft-automation/UMN-Google/pull/50

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1
Solution 2 Alexey Gusarov

Related Questions