Localization inside GetListAsExcelFileAsync() method #6667

9 Answer(s)

• 

  0

  liangshiwei created 2 years ago

  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"]},
      }
  };
  

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  icoretchi created 2 years 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.

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  liangshiwei created 2 years ago

  Fullstack Developer

  Hi,

  Could you share some code? I will check it.

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  icoretchi created 2 years 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.

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  liangshiwei created 2 years ago

  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.

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  icoretchi created 2 years 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.

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  liangshiwei created 2 years ago

  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);
  }
  

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  icoretchi created 2 years ago

  It's still not working properly.

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  liangshiwei created 2 years ago

  Fullstack Developer

  I could not reproduce the problem

  

  

  

  

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel