import excel

1 files changed, 28 insertions, 8 deletions

diff --git a/src/pages/my/recomendation/components/products-recomendatison.jsx b/src/pages/my/recomendation/components/products-recomendatison.jsx
index 9438eb46..c20aaa5b 100644
--- a/src/pages/my/recomendation/components/products-recomendatison.jsx
+++ b/src/pages/my/recomendation/components/products-recomendatison.jsx
@@ -1,9 +1,32 @@
 import Menu from '@/lib/auth/components/Menu';
-import { cons } from 'lodash-contrib';
+import { useState } from 'react';
+import * as XLSX from 'xlsx'; 
 
 const ProductsRecomendation = ({ id }) => {
-  const handleSubmit = () => {}
-  const handleFileChange = () => {}
+  const [excelData, setExcelData] = useState(null);
+
+  const handleSubmit = (e) => {
+    e.preventDefault();
+    if (excelData) {
+      // Lakukan operasi pencarian atau operasi lainnya di sini
+      console.log('ini data excel',excelData); // Contoh: Menampilkan data excel ke konsol
+    } else {
+      console.log('No excel data available');
+    }
+  };
+  const handleFileChange = (e) => {
+    const file = e.target.files[0];
+    const reader = new FileReader();
+    reader.onload = (event) => {
+      const data = new Uint8Array(event.target.result);
+      const workbook = XLSX.read(data, { type: 'array' });
+      const sheetName = workbook.SheetNames[0];
+      const sheet = workbook.Sheets[sheetName];
+      const jsonData = XLSX.utils.sheet_to_json(sheet, { header: 1, range: 1 });
+      setExcelData(jsonData);
+    };
+    reader.readAsArrayBuffer(file);
+  };
   return (
     <div className='container mx-auto flex py-10'>
       <div className='w-3/12 pr-4'>
@@ -33,12 +56,9 @@ const ProductsRecomendation = ({ id }) => {
           </table>
         </div>
         <div className='container mx-auto mt-8'>
-          <form onSubmit={handleSubmit} >
+          <form onSubmit={handleSubmit}>
             <div className='mb-4'>
-              <label
-                htmlFor='excelFile'
-                className='text-sm  font-semibold'
-              >
+              <label htmlFor='excelFile' className='text-sm  font-semibold'>
                 Upload Excel File (.xlsx)
               </label>
               <input