Import Excel file #9313

6 Answer(s)

• 

  0

  enisn created one month ago

  Support Team .NET Developer

  We're using MiniExcel library in ABP Suite to export data as excel whenever you generate a code by checking Enable Excel Export option.

  

  You can use the same library to import too

  public async Task ImportAsync(IRemoteStreamContent file)
  {
      using var stream = file.GetStream();
      var rows = stream.Query<BookExcelDto>().ToList();
  
      var bookList = rows.Select(row => new Book(row.Id, row.Title, row.AuthorName)).ToList();
  
      await _bookRepository.InsertManyAsync(bookList);
  }
  

  You can read this article if you want to learn usage of IRemoteStreamContent and upload a file from angular: https://abp.io/community/articles/how-to-upload-and-download-files-in-the-abp-framework-using-angular-que8cdr8

  Save Cancel

  1
• 

  0

  antoni.obrados created one month ago

  Thanks for all.

  Save Cancel
• 

  0

  antoni.obrados created one month ago

  Hi,

  When I run swagger it gives me this error:

  

  Thanks.

  Save Cancel
• 

  0

  berkansasmaz created 25 days ago

  Support Team .NET Developer

  Hello,

  Can you send us the logs of your application to pinpoint the root cause of the problem?

  You can find the log record in Logs/logs.txt in the Host project.

  Thanks.

  Save Cancel
• 

  0

  enisn created 24 days ago

  Support Team .NET Developer

  Hi,

  When I run swagger it gives me this error:

  

  Thanks.

  Do you use a gateway or directly calling the service?

  Also please check logs of the application it provide information about the problem. You can share with us the logs

  Save Cancel
• 

  0

  antoni.obrados created 24 days ago

  Everything's fine now. It was my mistake. Thanks.

  Save Cancel