Dear Experts, I have obtained the results through applying Time Varying VAR model in R. Now I want to save my results in a excel sheet. Kindly guide me how to create a excel or excel table. Although I have tried the following code but I face error. Write.xlsx(x, "table name.xlsx") Kindly guide. Regards Chishti [[alternative HTML version deleted]]
I went to google and typed in "save excel in r" and got a few hits:
http://www.sthda.com/english/wiki/writing-data-from-r-to-excel-files-xls-xlsx
This is a good site, but there are others:
https://www.statology.org/r-export-to-excel/
https://www.geeksforgeeks.org/how-to-export-a-dataframe-to-excel-file-in-r/
and many more.
Tim
-----Original Message-----
From: R-help <r-help-bounces at r-project.org> On Behalf Of Muhammad
Zubair Chishti
Sent: Thursday, July 14, 2022 3:40 PM
To: r-help at r-project.org
Subject: [R] Kindly Guide
[External Email]
Dear Experts,
I have obtained the results through applying Time Varying VAR model in R.
Now I want to save my results in a excel sheet. Kindly guide me how to create a
excel or excel table. Although I have tried the following code but I face error.
Write.xlsx(x, "table name.xlsx")
Kindly guide.
Regards
Chishti
[[alternative HTML version deleted]]
______________________________________________
R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://urldefense.proofpoint.com/v2/url?u=https-3A__stat.ethz.ch_mailman_listinfo_r-2Dhelp&d=DwICAg&c=sJ6xIWYx-zLMB3EPkvcnVg&r=9PEhQh2kVeAsRzsn7AkP-g&m=UJkYmZ1qWcJJ0LfLyhLuxeXL_y05ktVLqPyzmV69ar6sOhNRtsVRKTuwDCus8Mlb&s=0nYlal67UZo9DLRtun3VyrocJ90_iskyiDTI19r8CkQ&ePLEASE
do read the posting guide
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.R-2Dproject.org_posting-2Dguide.html&d=DwICAg&c=sJ6xIWYx-zLMB3EPkvcnVg&r=9PEhQh2kVeAsRzsn7AkP-g&m=UJkYmZ1qWcJJ0LfLyhLuxeXL_y05ktVLqPyzmV69ar6sOhNRtsVRKTuwDCus8Mlb&s=b9wQQfFdvLd-7HavGZlIhz3vR587ZiZye-3rVJJ9i9I&eand
provide commented, minimal, self-contained, reproducible code.
Hello, Inline. ?s 20:39 de 14/07/2022, Muhammad Zubair Chishti escreveu:> Dear Experts, > I have obtained the results through applying Time Varying VAR model in R.Can you post a minimal example of the data and code used? If you use functions from contributed packages please start the example with calls to library() in order to load the necessary packages. Hope this helps, Rui Barradas> Now I want to save my results in a excel sheet. Kindly guide me how to > create a excel or excel table. Although I have tried the following code but > I face error. > Write.xlsx(x, "table name.xlsx") > > Kindly guide. > > Regards > Chishti > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code.
Typo? Try
write.xlsx(x, "table name.xlsx")
Example
install.packages('openxlsx')
library(openxlsx)
write.xlsx(df, "stations.xlsx")
On Thu, 14 Jul 2022 at 15:40, Muhammad Zubair Chishti
<mzchishti at eco.qau.edu.pk> wrote:>
> Dear Experts,
> I have obtained the results through applying Time Varying VAR model in R.
> Now I want to save my results in a excel sheet. Kindly guide me how to
> create a excel or excel table. Although I have tried the following code but
> I face error.
> Write.xlsx(x, "table name.xlsx")
>
> Kindly guide.
>
> Regards
> Chishti
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
--
John Kane
Kingston ON Canada