How to prevent converting numbers into scientific form while importing excel files in R?

Question

Using Openxlsx package and read.xlsx function. It reads the data but converts numbers into scientific form.

The number is 132178278. It gets converted to 132178278E8.

Tried using the read.xlsx function from xlsx package. But it takes too long to read the file when compared to using openxlsx.

Answer 1

Before attempting this, first set:

options(scipen=999)

After reading the Workbook in openxlsx and storing it in a dataframe, just convert the column with scientific notation to Numeric, as it may be treating it as a Character.

as.numeric(df$`Column in Scientific Notation`)