Question: I am working through a much larger data set with more columns, and want to paste a formula for each column without individually specifying the reference letters for the column. Is there a way to paste a formula across multiple columns where the range will adjust with the new column similar to dragging the formula across the columns within excel?
Sort of, I'm on mobile now so I can't look it up easy. Instead of using a range like "A2" yo would set a cell by row, col number, which you could put in a loop because they are numbers. Much easier than dealing with letters.
Thanks so much for this. It's extremely helpful. However, I had an issue when reading back the excel. If I insert a formula from R it seems to work when I open the Excel file, but when I open it from R the value appears as NA. Do you know how I can fix this? Thanks!
Can you show how one might make conditional formatting in the excel sheet. Let's say you wanted to change the color of a row based on user input in the excel sheet. I have a check-mark column in my sheet, where I would like the sheet to react to user entering an 'X' in the column.
This is really helpful. Thanks Mark!
Have you started using this for something practical yet?
@@CradleToGraveR Hi Mark, Yes. sharing some of my code: (Thanks to your Tutorials)
library(openxlsx)
wb
Question: I am working through a much larger data set with more columns, and want to paste a formula for each column without individually specifying the reference letters for the column. Is there a way to paste a formula across multiple columns where the range will adjust with the new column similar to dragging the formula across the columns within excel?
Sort of, I'm on mobile now so I can't look it up easy. Instead of using a range like "A2" yo would set a cell by row, col number, which you could put in a loop because they are numbers. Much easier than dealing with letters.
Thanks man. Help me a lot.
Awesome. Hope it worked out for you.
You are a life saver!
Thank you,
I followed your tutorial step by step,
I used a different formula,
formula
Hi, thank you.
Is there some function finding o selecting cell by being the first or last, when you apply "ctrl + (->,
Thanks so much for this. It's extremely helpful. However, I had an issue when reading back the excel. If I insert a formula from R it seems to work when I open the Excel file, but when I open it from R the value appears as NA. Do you know how I can fix this? Thanks!
Great video!!!
Glad it helps. I'll be making more soon. Thanks for the compliment.
Can you show how one might make conditional formatting in the excel sheet. Let's say you wanted to change the color of a row based on user input in the excel sheet. I have a check-mark column in my sheet, where I would like the sheet to react to user entering an 'X' in the column.
I will try to do some more tutorials on openxlsx. There is so much that you can do with this package!
Thank you!
So, your asking more of an interaction scenario. This is a start, but far from what you want to do. th-cam.com/video/lUOv2IHVRl4/w-d-xo.html