How to change the language of Excel records in Blazor DataGrid?

[Nibras Shawy]

Hi,
My question:
- Please correct the translation for Dutch where Waar for True and Onwaar for False. I am using Syncfusion Blazor DataGrid v21.1.39 and I want to export the data to Excel with the Dutch language. However, when I download the file, I see that the Boolean values in the column have the wrong translation ‘Vals’ instead of ‘Waar’ for true and ‘Onwaar’ for false. Moreover, I prefer to have true or false values instead of text, so that I can use them in other Excel functions. How can I achieve this?

This is the code:
`

<SfGrid ID="projectHoursDataGrid" @ref="DefaultGrid" DataSource="@ProjectPartSummaries"

        AllowSorting=true AllowPaging="true" AllowFiltering="true" AllowGrouping=true AllowExcelExport="true" Toolbar="@(new List<string>() { "ExcelExport" })">

    <GridFilterSettings Type="Syncfusion.Blazor.Grids.FilterType.Menu"></GridFilterSettings>

    <GridPageSettings PageCount="5"></GridPageSettings>

    <GridEvents CommandClicked="OnCommandClicked" OnToolbarClick="ToolbarClickHandler" TValue="ProjectPartSummary"></GridEvents>

    <GridColumns>

        <GridColumn Visible=false Field="@(nameof(ProjectPartSummary.WorkerId))" HeaderText="WorkerId" TextAlign="TextAlign.Left" Width="150"></GridColumn>

        <GridColumn Field="@(nameof(ProjectPartSummary.ProjectCompleted))" DisplayAsCheckBox="true" HeaderText="@LocalizerProjectPart[ResourceProjectPart.Completed]" TextAlign="TextAlign.Left" Width="150"></GridColumn>

        <GridColumn Field="@(nameof(ProjectPartSummary.Period))" HeaderText="@LocalizerProjectPartWorkerHour[ResourceProjectPartWorkerHours.Period]" TextAlign="TextAlign.Left" Width="150"></GridColumn>

        <GridColumn Field="@(nameof(ProjectPartSummary.WeekString))" HeaderText="@LocalizerProjectPartWorkerHour[ResourceProjectPartWorkerHours.Week]" TextAlign="TextAlign.Left" Width="150"></GridColumn>

        <GridColumn Field="@(nameof(ProjectPartSummary.ProjectInfo))" HeaderText="@LocalizerProject[ResourceProject.Project]" TextAlign="TextAlign.Left" Width="250"></GridColumn>

        <GridColumn Field="@(nameof(ProjectPartSummary.ProjectPartInfo))" HeaderText="@LocalizerProjectPart[ResourceProjectPart.ProjectPart]" TextAlign="TextAlign.Left" Width="250"></GridColumn>

        <GridColumn Field="@(nameof(ProjectPartSummary.OutSourced))" DisplayAsCheckBox="true" HeaderText="@LocalizerProjectPart[ResourceProjectPart.Outsourced]" TextAlign="TextAlign.Left" Width="150"></GridColumn>

        <GridColumn Field="@(nameof(ProjectPartSummary.SumHours))" HeaderText="@LocalizerProjectPartWorkerHour[ResourceProjectPartWorkerHours.Hours]" TextAlign="TextAlign.Left" Width="150"></GridColumn>

        <GridColumn Field="@(nameof(ProjectPartSummary.SumAcceptedWork))" HeaderText="@LocalizerProjectPartWorkerHour[ResourceProjectPartWorkerHours.Acceptedwork]" TextAlign="TextAlign.Left" Width="150"></GridColumn>

        <GridColumn Field="@(nameof(ProjectPartSummary.SumCostPlus))" HeaderText="@LocalizerProjectPartWorkerHour[ResourceProjectPartWorkerHours.CostPlus]" TextAlign="TextAlign.Left" Width="150"></GridColumn>

        <GridColumn Field="@(nameof(ProjectPartSummary.SumCostPlusOutsourcing))" HeaderText="@LocalizerProjectPartWorkerHour[ResourceProjectPartWorkerHours.CostPlusOutsourcing]" TextAlign="TextAlign.Left" Width="150"></GridColumn>

        <GridColumn Field="@(nameof(ProjectPartSummary.SumOutsourced))" HeaderText="@LocalizerProjectPartWorkerHour[ResourceProjectPartWorkerHours.Outsourced]" TextAlign="TextAlign.Left" Width="150"></GridColumn>

        <GridColumn TextAlign="TextAlign.Center" Width="150">

            <GridCommandColumns>

                <GridCommandColumn ButtonOption="@(new CommandButtonOptions() { CssClass=SyncEIconLibrary.ViewDetails})" Title="@Localizer[ResourceMontage.View]"></GridCommandColumn>

            </GridCommandColumns>

        </GridColumn>

    </GridColumns>

</SfGrid>

`
This the result:

Thanks

[Sarveswaran Palani]

Hi Nibras,

Greetings from Syncfusion support.

From your query, we suspect that you’re facing issue in exporting Dutch characters in your project. Before proceeding into further, we would like to know more about your requirement to proceed further. So kindly share the following details to us.

1. How did you pass “vals” and “waar” value to the grid?
2. Share us the model class of your project.
3. Are you using any column template in your Grid column?
4. Share more detail about your exact requirement.

The above requested details will be helpful to validate further at our end and provide solution as earlier as possible.

Regards,

Sarvesh