Write json file from Excel in IONIC Angular

Question

I pass Excel file to json and I need to put the information from the object in one json file placed in assets folder. I try using FILE component but I can not find the solution any Help please. The ExcelData need to write to files """

import { Component, OnInit } from '@angular/core';
import * as XLSX from 'xlsx'
import { HttpClient, HttpHeaders } from '@angular/common/http';

export class ExcelPage implements OnInit {

 ExcelData: any;
files= this.httpClient.get('../../assets/json/data.json')


  constructor( private httpClient: HttpClient) { }

  ngOnInit() {
  }

  ReadExcel(event:any){
    let file= event.target.files[0];
    let fileReader = new FileReader();

    fileReader.readAsBinaryString(file);
    fileReader.onload =(e)=>{
      var wb = XLSX.read(fileReader.result,{type:'binary'});
      var sheetNames = wb.SheetNames;
      this.ExcelData = XLSX.utils.sheet_to_json(wb.Sheets[sheetNames[0]])
     // console.log(this.ExcelData)
      JSON.stringify(this.ExcelData)

  XLSX.writeFile(this.ExcelData, "../../assets/json/data.json")

"""

Zrelli Majdi · Accepted Answer · 2022-05-22 13:11:56Z

0

The assets folder is read only at run time.

You can only store files in it during development time.

answered May 22, 2022 at 13:11

Zrelli Majdi

1,2682 gold badges11 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Write json file from Excel in IONIC Angular

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related