I tried writing formulas with xlsxWriter and the
worksheet.write_formula but in my excel I only have zero.

I have installed the package to insert the XSL file in R studio using the following code:
“install. packages(“readxl”),
then I library it by code :
“library(readxl)”
finally, I installed the XSL file by the code:
“XLSLFile= read_xlsx(“E:/R programming/data/Table_3 (1).xlsx”)
now I can not find the function to save this file by the code
“write.xlsx (XLSLFile, file path),
the question is ; how can i get the true function if the R programming give me an error code

In my work I do product pricing with purchase price, minimum price to sell, etc. Each producer has a file on Google’s shared drive. The files contain several sheets.