Categories

Tuesday, December 7, 2021
therichposts@gmail.com
Angular 10Bootstrap 4Bootstrap 4.5

How to read csv file in angular 10?

How to read csv file in angular 10?

Hello friends, welcome back to my blog. Today in this blog post, I am going to tell you, How to read csv file in angular 10?

Guy’s we can use same code in Angular 12 to read csv file.

Angular 10 read csv file data

Angular 12 came and if you are new then you must check below two links:

  1. Angular12 Basic Tutorials
  2. Angular 12 Free Templates

Friends now I proceed onwards and here is the working code snippet for How to read csv file in angular 10? and please use this carefully to avoid the mistakes:

1. Firstly friends we need fresh angular 10 setup and for this we need to run below commands but if you already have angular 10 setup then you can avoid below commands. Secondly we should also have latest node version installed on our system:

npm install -g @angular/cli 

ng new angularcsv //Create new Angular Project

cd angularcsv // Go inside the Angular Project Folder

ng serve --open // Run and Open the Angular Project

http://localhost:4200/ // Working Angular Project Url

2. Now friends, here we need to run below commands into our project terminal to install bootstrap modules(for good looks) into our angular application:

npm install --save bootstrap

ng serve --o

3. Now friends, here we need to add below  into our angular.json file:

"styles": [
            ...
        "node_modules/bootstrap/dist/css/bootstrap.min.css"
         ]

4. Now friends, we need to add below code into our src/app/app.component.ts file:

...


export class AppComponent {
  ...
   //array varibales to store csv data
  lines = []; //for headings
  linesR = []; // for rows

  //File upload function
  changeListener(files: FileList){
    console.log(files);
    if(files && files.length > 0) {
       let file : File = files.item(0); 
         console.log(file.name);
         console.log(file.size);
         console.log(file.type);

         //File reader method
         let reader: FileReader = new FileReader();
         reader.readAsText(file);
         reader.onload = (e) => {
          let csv: any = reader.result;
          let allTextLines = [];
          allTextLines = csv.split(/\r|\n|\r/);
         

         //Table Headings
          let headers = allTextLines[0].split(';');
          let data = headers;
          let tarr = [];
          for (let j = 0; j < headers.length; j++) {
            tarr.push(data[j]);
          }
          //Pusd headings to array variable
          this.lines.push(tarr);
          
         
          // Table Rows
          let tarrR = [];
          
          let arrl = allTextLines.length;
          let rows = [];
          for(let i = 1; i < arrl; i++){
          rows.push(allTextLines[i].split(';'));
         
          }
          
          for (let j = 0; j < arrl; j++) {
      
              tarrR.push(rows[j]);
              
          }
         //Push rows to array variable
          this.linesR.push(tarrR);
      }
    }
  }
  
}

5. Now friends we just need to add below code into src/app/app.component.html file to show csv data into bootstrap data table:

<div class="container">
      <h1 class="mt-4">TheRichPost.com</h1>
     
      <input class="form-control mb-5" type="file" class="upload" (change)="changeListener($event.target.files)">
   
      <table class="table table-bordered table-dark mt-5">
        <thead>
          <tr>
            <th *ngFor="let item of lines[0]; let i = index">{{item}}</th>
          </tr>
        </thead>
        <tbody>
          <tr *ngFor="let item of linesR[0]; let i = index">
            <td *ngFor="let itemm of lines[0]; let j = index">{{item[j]}}</td>
            
          </tr>
        </tbody>
      </table>
    </div>

Now we are done friends. If you have any kind of query, suggestion and new requirement then feel free to comment below.

Guys, in my next post, I will tell you, how to save csv file data into database in angular?

Note: Friends, In this post, I just tell the basic setup and things, you can change the code according to your requirements. For better live working experience, please check the video on the top.

I will appreciate that if you will tell your views for this post. Nothing matters if your views will be good or bad because with your views, I will make my next posts more good and helpful.

Jassa

Thanks

Ajay Malhotra
the authorAjay Malhotra
Hello to all. Welcome to therichpost.com. Myself Ajay Malhotra and I am freelance full stack developer. I love coding. I know WordPress, Core php, Angularjs, Angular 2, Angular 6, Angular 7, Angular 8, Angular 9, Angular 10, Angular 11, Angular12, Angular 13, Bootstrap 5, Nodejs, Laravel, Codeigniter, Shopify, Squarespace, jQuery, Google Map Api, Vuejs, Reactjs, Big commerce etc.

12 Comments

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.