saving with csv

the data i have is with xlsx and when i'm savaing it as csv it gives me worning that some rows will be efficted shall i contenue ? or i can import the data in Rstudio with xlsx ?

You can import data from xlsx files directly. Check out the packages:

  1. readxl
  2. xlsx
  3. openxlsx.

And, in case you are confused between R and RStudio, please take a look at this post:

1 Like

This should take you where you want to go:

library('readxl')
my_data = read_excel(path = 'path/to/my_data.xlsx', sheet = 'my_sheet')
1 Like

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.