Localization inside GetListAsExcelFileAsync() method #6667

9 Answer(s)

• 

  0

  liangshiwei created 10 months ago

  Support Team Fullstack Developer

  Hi,

  ABP internally uses Miniexcel to export Excel file.

  You need to use dynamic column names to support localization https://github.com/mini-software/MiniExcel?tab=readme-ov-file#7-dynamiccolumnattribute

  for example:

  var config = new OpenXmlConfiguration
  {
      DynamicColumns = new DynamicExcelColumn[] { 
          new DynamicExcelColumn("id") {Name = L["Id"]},
          new DynamicExcelColumn("name") {Name = L["Name"]},
          new DynamicExcelColumn("createdate") {Name = L["Createdate"]},
          new DynamicExcelColumn("point") {Name = L["Point"]},
      }
  };
  

  Save Cancel
• 

  0

  icoretchi created 10 months ago

  I know that. You didn't understand the question. The problem is in L, as StringLocalizer. It's not working properly. Try the example that you suggested to localize the colums for different language beside english.

  Save Cancel
• 

  0

  liangshiwei created 10 months ago

  Support Team Fullstack Developer

  Hi,

  Could you share some code? I will check it.

  Save Cancel
• 

  0

  icoretchi created 10 months ago

  Once again. Just try the code you have suggested:

  var config = new OpenXmlConfiguration { DynamicColumns = new DynamicExcelColumn[] { new DynamicExcelColumn("id") {Name = L["Id"]}, new DynamicExcelColumn("name") {Name = L["Name"]}, new DynamicExcelColumn("createdate") {Name = L["Createdate"]}, new DynamicExcelColumn("point") {Name = L["Point"]}, } };

  I am doing absolutly the same.

  Save Cancel
• 

  0

  liangshiwei created 10 months ago

  Support Team Fullstack Developer

  Hi,

  This is a problem, You can open the AppService.Extended.cs class to update the LocalizationResource

  

  We will enhance the suite in the next version, your ticket was refunded.

  Save Cancel
• 

  0

  icoretchi created 10 months ago

  In my context the LocalizationResource is properly assigned for the Application Service and localization for exporting to excel it's not working. And I have to mention that for microservices template all the application services are inherited from the base class which properly assign the LocalizationResource. I think the problem is in this specific method GetListAsExcelFileAsync() how is called from UI (in my case from Blazor). I reiterate again the L, as StringLocalizer is working properly from any method of the ApplicationService, besides the GetListAsExcelFileAsync.

  Save Cancel
• 

  0

  liangshiwei created 10 months ago

  Support Team Fullstack Developer

  Hi,

  Sorry, I can confirm this issue. we will fix it.

  You can try to update the DownloadAsExcelAsync method. for example:

  private  async Task DownloadAsExcelAsync()
  {
      var token = (await BooksAppService.GetDownloadTokenAsync()).Token;
      var remoteService = await RemoteServiceConfigurationProvider.GetConfigurationOrDefaultOrNullAsync("Qa") ??
      await RemoteServiceConfigurationProvider.GetConfigurationOrDefaultOrNullAsync("Default");
      var currentCulture = CultureInfo.CurrentUICulture.Name ?? CultureInfo.CurrentCulture.Name;
      if(!currentCulture.IsNullOrEmpty())
      {
          currentCulture = "&culture=" + currentCulture;
      }
      NavigationManager.NavigateTo($"{remoteService?.BaseUrl.EnsureEndsWith('/') ?? string.Empty}api/app/books/as-excel-file?DownloadToken={token}&FilterText={Filter.FilterText}&Name={Filter.Name}&Title={Filter.Title}{currentCulture}", forceLoad: true);
  }
  

  Save Cancel
• 

  0

  icoretchi created 10 months ago

  It's still not working properly.

  Save Cancel
• 

  0

  liangshiwei created 10 months ago

  Support Team Fullstack Developer

  I could not reproduce the problem

  

  

  

  

  Save Cancel