From 50d64b892cc4cff681a9306edcdd9dfbff32ce83 Mon Sep 17 00:00:00 2001
From: Nevena Bojovic <nenabojov@gmail.com>
Date: Tue, 3 May 2022 16:50:11 +0200
Subject: JSON, XLSX formati

---
 .../form-dataset/form-dataset.component.html       |  2 +-
 .../form-dataset/form-dataset.component.ts         |  4 +++
 frontend/src/app/_services/csv-parse.service.ts    | 38 ++++++++++++++++++++++
 3 files changed, 43 insertions(+), 1 deletion(-)

(limited to 'frontend/src')

diff --git a/frontend/src/app/_elements/form-dataset/form-dataset.component.html b/frontend/src/app/_elements/form-dataset/form-dataset.component.html
index 0ecb3d30..7bbe0921 100644
--- a/frontend/src/app/_elements/form-dataset/form-dataset.component.html
+++ b/frontend/src/app/_elements/form-dataset/form-dataset.component.html
@@ -9,7 +9,7 @@
                 <label>{{filename}}</label>
         </div>
                 
-        <input class="file" id="file-upload" (change)="changeListener($event)" #fileInput type="file"  accept=".csv">
+        <input class="file" id="file-upload" (change)="changeListener($event)" #fileInput type="file"  accept=".csv, .xlsx, .json">
         
         
         <div class="mt-5 datatable">
diff --git a/frontend/src/app/_elements/form-dataset/form-dataset.component.ts b/frontend/src/app/_elements/form-dataset/form-dataset.component.ts
index 030e15ca..c7efe098 100644
--- a/frontend/src/app/_elements/form-dataset/form-dataset.component.ts
+++ b/frontend/src/app/_elements/form-dataset/form-dataset.component.ts
@@ -85,6 +85,10 @@ export class FormDatasetComponent {
     this.dataset.name = this.filename.slice(0, this.filename.length - 4);
   }
 
+  /*exportAsXLSX():void {
+    this.excelService.exportAsExcelFile(this.data, 'sample');
+  }*/
+
   checkAccessible() {
     if (this.dataset.isPublic)
       this.dataset.accessibleByLink = true;
diff --git a/frontend/src/app/_services/csv-parse.service.ts b/frontend/src/app/_services/csv-parse.service.ts
index 4a05535a..6d2fd8d8 100644
--- a/frontend/src/app/_services/csv-parse.service.ts
+++ b/frontend/src/app/_services/csv-parse.service.ts
@@ -1,4 +1,10 @@
 import { Injectable } from "@angular/core";
+import * as FileSaver from 'file-saver';
+import * as XLSX from 'xlsx';
+
+const EXCEL_TYPE = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=UTF-8';
+const EXCEL_EXTENSION = '.xlsx';
+
 @Injectable({ providedIn: 'root' })
 export class CsvParseService {
 
@@ -53,4 +59,36 @@ export class CsvParseService {
 
     return (arrData);
   }
+
+  ConvertJSONToCSV(objArray, headerList) {
+    let array = typeof objArray != 'object' ? JSON.parse(objArray) : objArray;
+    let str = '';
+    let row = 'S.No,';
+    for (let index in headerList) {
+     row += headerList[index] + ',';
+    }
+    row = row.slice(0, -1);
+    str += row + '\r\n';
+    for (let i = 0; i < array.length; i++) {
+     let line = (i+1)+'';
+     for (let index in headerList) {
+      let head = headerList[index];
+      line += ',' + array[i][head];
+     }
+     str += line + '\r\n';
+    }
+    return str;
+   }
+
+  public exportAsExcelFile(json: any[], excelFileName: string): void { 
+    const worksheet: XLSX.WorkSheet = XLSX.utils.json_to_sheet(json);
+    const workbook: XLSX.WorkBook = { Sheets: { 'data': worksheet }, SheetNames: ['data'] }; 
+    const excelBuffer: any = XLSX.write(workbook, { bookType: 'xlsx', type: 'array' });
+    this.saveAsExcelFile(excelBuffer, excelFileName);
+  }
+
+  private saveAsExcelFile(buffer: any, fileName: string): void {
+    const data: Blob = new Blob([buffer], {type: EXCEL_TYPE});  
+    FileSaver.saveAs(data, fileName + '_export_' + new  Date().getTime() + EXCEL_EXTENSION);
+ }
 }
\ No newline at end of file
-- 
cgit v1.2.3