@@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
Man I need your help !! … I’ll forever grateful. there’s a empty excel sheet, in that certain column have full of drop-down cell. It’s empty now. Now I have a JSON data to fill the excel sheet . Now how do I fill the excel sheet with json data. Like how do I fill the drop-down cell with dynamic data from the json ?? . The json data looks like this - array of objects, and each objects has one key called dropdown. That dropdown value is array of string. Please help me .what to do ??
Hy mr Vincent i love you're tutorials.. can you make a video explaining how to display pdf on mobiles with php or js.. without downloading. . Thank you a lot
why is the date in that format? can we change that? I wanted to make charts and as such with dates being the independent variable and the stock prices as the dependent variables. Pls help
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
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.
It was a really nice one. But I need to only write to the xls file? can you please share the code for only writing to the excel sheet? I tried with your code but it didnt work for me.
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?
That was a pretty good tutorial I followed you step by step and it worked but now if I need to create a chart and push it to a work sheet is this possible ? whether it's using this package or any other one ? can anyone please help me ?
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 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 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.
Hello, the video is very helpful, but now I'm currently working on a web app and I want the user to be able to print the file but I don't know how to do this with xlsx. If someone has an idea about it, I would be grateful to hear 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");
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. th-cam.com/video/KP_8gN8kh4Y/w-d-xo.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.
I am only amazed at the kind of content and examples you give. This is super helpful and continue to deliver more great content Vincent :)
Happy to hear that!
Thank you soooo much. You've showed me more in 5 minutes than hours of documentation. Thank you for your work.
Glad it was helpful!
I'm new to this. Do I need to download / install / src something in order to use fs, xlsx and jsontoxml?
Thank you for the tutorial. Finally I realized that you actually meant "New Column" by "New Row".
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 😄
This might be a dumb question, but is it possible for excel doc to be an api source? And if so. Can you point me to a resource
Man I need your help !! … I’ll forever grateful. there’s a empty excel sheet, in that certain column have full of drop-down cell. It’s empty now. Now I have a JSON data to fill the excel sheet . Now how do I fill the excel sheet with json data. Like how do I fill the drop-down cell with dynamic data from the json ?? . The json data looks like this - array of objects, and each objects has one key called dropdown. That dropdown value is array of string. Please help me .what to do ??
This video is very helpful for me. Thanks.
This can help me in the future project. thank you very much!
Great explanation on this library!
Thank you!
How to add heading in this excel which function to use
I guess I can change the data by change Json witch is already in excel file?
Is there any way to keep the file open while it is being modified?
Simple, informative and helpful 💪👍 Thanks a lot for this tutorial!
Glad it was helpful!
Hy mr Vincent i love you're tutorials.. can you make a video explaining how to display pdf on mobiles with php or js.. without downloading. . Thank you a lot
Thank you very much!
Hello, thank you for your video. I have a question:
- If I have an "id". I wanna del all the row that has the Id. How can I do it?
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");
Hi, Can we use this to convert xls format file to xlsx?
Excellent video. But how I delete a columns?
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");
why is the date in that format? can we change that?
I wanted to make charts and as such with dates being the independent variable and the stock prices as the dependent variables. Pls help
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
how to import the dependencies? someone please answer, thankss
can we make styling in this sheet. Something like a heading for the whole sheet
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.
can provide validations for an specific xl file before going to upload in react js
Sorry I don't know any react.
Hello,
How to add style to header xlsx ? thanks ;)
hey how to make individual json files for each sheet in a xlsx file
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
How to get the sheetname?
It was a really nice one. But I need to only write to the xls file? can you please share the code for only writing to the excel sheet? I tried with your code but it didnt work for me.
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.
Thanks, this help me
Happy to help
I also wanted to ask that why are you working on a js file? why not show it by working on a VueJs component?
Because I like keeping back-end stuff in the back-end, and front-end stuff in the front-end.
how to create dropdown ?
Thank you.
Welcome!
That was a pretty good tutorial I followed you step by step and it worked but now if I need to create a chart and push it to a work sheet is this possible ? whether it's using this package or any other one ? can anyone please help me ?
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.
How to add cell styles in xlsx??
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.
How to deal with dates value please comment
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
Hello, the video is very helpful, but now I'm currently working on a web app and I want the user to be able to print the file but I don't know how to do this with xlsx. If someone has an idea about it, I would be grateful to hear it :)
th-cam.com/channels/bmwl3iMyHmjgcQzbgmgFGA.html
How to delete worksheet?
// 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
how do I do this on the client-side ?
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.
th-cam.com/video/KP_8gN8kh4Y/w-d-xo.html
do you know how to style it ?
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
Clear
Thanks
Be blessed by Lord Jesus Christ!