Categories

Wednesday, June 12, 2024
#919814419350 therichposts@gmail.com
Angular 10Bootstrap 4Bootstrap 4.5

How to read csv file in angular 16+?

HOW TO READ CSV FILE IN ANGULAR 16+?

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 16+?

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

Angular 10 read csv file data

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

  1. Angular16 Basic Tutorials
  2. Angular Free Templates

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

1. Firstly friends we need fresh angular 16 setup and for this we need to run below commands but if you already have angular 16 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:any = []; //for headings
   linesR:any = []; // for rows
   //File upload function
   changeListener(files:any) {
    let fileList = (<HTMLInputElement>files.target).files;
    if (fileList && fileList.length > 0) {
      let file: File = fileList[0];
      console.log(file.name);
      console.log(file.size);
      console.log(file.type);

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

        let headers = allTextLines[0].split(",");
        let data = headers;
        let tarr = [];
        for (let j = 0; j < headers.length; j++) {
          tarr.push(data[j]);
        }
        this.lines.push(tarr);
        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]);
        }
        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)">

  <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

therichpost
the authortherichpost
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 14, Angular 15, Angular 16, Angular 17, Bootstrap 5, Nodejs, Laravel, Codeigniter, Shopify, Squarespace, jQuery, Google Map Api, Vuejs, Reactjs, Big commerce etc.

14 Comments

Leave a Reply

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