Working with XLSX in JavaScript 

Happy to hear that!

Glad it was helpful!

Thank you for pointing it out. I always confuse rows and columns. I've changed the project files, but I can't really do anything about the video.

@@VincentLabStudio In my country(🇧🇩) we have RC Cola (alongside Coca Cola and Pepsi Cola) which helps us remember that "R" comes as the first subscription number and then "C". 😄 ... thank you again all your videos. Hope to see more in coming days. en.wikipedia.org/wiki/RC_Cola

​@@Chandan7404 Fun fact thanks 😄

Thank you!

Glad it was helpful!

Glad it helped!

Happy to help

Welcome!

I don't know if it's possible, but I found a few different methods which might work. I have not tested them but I will give you the links here: www.npmjs.com/package/sheetjs-style www.npmjs.com/package/sheetjs-style-v2 github.com/ShanaMaid/sheetjs There's also a pro version of this Library which I think can do it: sheetjs.com/pro I just found this on their documentation: "This is the community version. We also offer a pro version with performance enhancements, additional features like styling, and dedicated support" But I think the libraries I have linked above are a free version of their styling feature.

Sorry I don't know any react.

That's a good question. I assume you can. But I'm not sure. Here is what I found on stack overflow: stackoverflow.com/questions/53163552/format-date-with-sheetjs

For example, I want to delete a row with Id value = 2587. Thanks

@@VietLedeptrai Try the code below. // Import dependencies const fs = require("fs"); const XLSX = require("xlsx"); const jsontoxml = require("jsontoxml"); // Read the file into memory // const workbook = XLSX.read(fs.readFileSync("file-example.xlsx")); const workbook = XLSX.readFile("file-example.xlsx"); // Convert the XLSX to JSON let worksheets = {}; for (const sheetName of workbook.SheetNames) { worksheets[sheetName] = XLSX.utils.sheet_to_json(workbook.Sheets[sheetName]); } // Modify the XLSX worksheets.Sheet1 = worksheets.Sheet1.filter(function(item) { return item.Id !== 2587; }); // Create a new XLSX file const newBook = XLSX.utils.book_new(); const newSheet = XLSX.utils.json_to_sheet(worksheets.Sheet1); XLSX.utils.book_append_sheet(newBook, newSheet, "Sheet1"); XLSX.writeFile(newBook,"new-book.xlsx");

Try the code below. // Import dependencies const fs = require("fs"); const XLSX = require("xlsx"); const jsontoxml = require("jsontoxml"); // Read the file into memory // const workbook = XLSX.read(fs.readFileSync("file-example.xlsx")); const workbook = XLSX.readFile("file-example.xlsx"); // Convert the XLSX to JSON let worksheets = {}; for (const sheetName of workbook.SheetNames) { worksheets[sheetName] = XLSX.utils.sheet_to_json(workbook.Sheets[sheetName]); } // Modify the XLSX worksheets.Sheet1 = worksheets.Sheet1.filter(function(item) { return item.Id !== 2587; }); // Create a new XLSX file const newBook = XLSX.utils.book_new(); const newSheet = XLSX.utils.json_to_sheet(worksheets.Sheet1); XLSX.utils.book_append_sheet(newBook, newSheet, "Sheet1"); XLSX.writeFile(newBook,"new-book.xlsx");

Try something like this: // Import dependencies const fs = require("fs"); const XLSX = require("xlsx"); // Read the file into memory const workbook = XLSX.readFile("file-example.xlsx"); // Convert the XLSX to JSON for (const sheetName of workbook.SheetNames) { fs.writeFileSync(`${sheetName}.json`, JSON.stringify(XLSX.utils.sheet_to_json(workbook.Sheets[sheetName]))); }

@@VincentLabStudio this one worked like a charm, can we filter the empty cells too in this package? i didn't find anything in package docs

Actually I have a requirement to only update the existing sheet i.e i need a method which ll simply write to the excel file.. to writing the excel file i need to pass some parameters like sheetname, column names to be filled up. can you please help me in this regard?

@@sudhansusekharpanda6510 exact same task is given to me rn. Would be grateful if you could share how you did it.

// Import dependencies const XLSX = require("xlsx"); // Read the file into memory const workbook = XLSX.readFile("file-example.xlsx"); // Create a new XLSX file const newBook = XLSX.utils.book_new(); for (const sheetName of workbook.SheetNames) { // And here you add everything except the one you wanted to delete const newSheet = XLSX.utils.json_to_sheet(XLSX.utils.sheet_to_json(workbook.Sheets[sheetName])); XLSX.utils.book_append_sheet(newBook, newSheet, sheetName); } XLSX.writeFile(newBook, "new-book.xlsx");

@@VincentLabStudio thanks for this...but don't we have any function to delete it directly

​@@rajat420420 Unfortunately not

I don't know if it's possible, but I found a few different methods which might work. I have not tested them but I will give you the links here: www.npmjs.com/package/sheetjs-style www.npmjs.com/package/sheetjs-style-v2 github.com/ShanaMaid/sheetjs There's also a pro version of this Library which I think can do it: sheetjs.com/pro I just found this on their documentation: "This is the community version. We also offer a pro version with performance enhancements, additional features like styling, and dedicated support" But I think the libraries I have linked above are a free version of their styling feature.

ru-vid.com/show-UCbmwl3iMyHmjgcQzbgmgFGA

Here is what I found on stack overflow: stackoverflow.com/questions/53163552/format-date-with-sheetjs

@@VincentLabStudio raw false give value in ddmmyy but required ddmmyyyy

Maybe this is helpful. Chartsheet Object Chartsheets are represented as standard sheets. They are distinguished with the !type property set to "chart". The underlying data and !ref refer to the cached data in the chartsheet. The first row of the chartsheet is the underlying header. Source: www.npmjs.com/package/xlsx or docs.sheetjs.com/ I haven't tested it, but this might be what you're looking for. www.npmjs.com/package/xlsx-chart

@@VincentLabStudio OK I'll give it a shot amd respond if it worked as I need, anyways thanks a lot for responding

@@VincentLabStudio yes it worked thanks a lot for your help I really appreciate it it has a slight issue that it only creates one chart if you tried to create another one it overwrites what's in the file and creates the single latest chart I'm still trying to make it work.

I don't know if that would be possible. My recommendation would be to keep back-end functionality on the back end and then exchange information between the back-end and front-end, using an API. And if you want to upload a file from the front-end to the back-end, then you can follow the video linked down below. And the only part you would need to change is the way it handles the file once it's uploaded to the back-end. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-KP_8gN8kh4Y.html

I don't know if it's possible, but I found a few different methods which might work. I have not tested them but I will give you the links here: www.npmjs.com/package/sheetjs-style www.npmjs.com/package/sheetjs-style-v2 github.com/ShanaMaid/sheetjs There's also a pro version of this Library which I think can do it: sheetjs.com/pro I just found this on their documentation: "This is the community version. We also offer a pro version with performance enhancements, additional features like styling, and dedicated support" But I think the libraries I have linked above are a free version of their styling feature.

@@VincentLabStudio thank for your help

Because I like keeping back-end stuff in the back-end, and front-end stuff in the front-end.