0

The problem which I faced: all huge numbers during process of import by readxl converting to "-2147483648". Examples of my "huge" numbers: 45000000000,55000000000. Converting to text in Excel didn't help, defining col_types as "text" either. Is any way to workaround it?

lebelinoz
  • 4,890
  • 10
  • 33
  • 56
Евгений М
  • 244
  • 5
  • 11
  • Show your code and output – CPak Sep 08 '17 at 16:17
  • Look into the package `readr` which has `readlines` or `read_tsv(..., col_types="c")` – CPak Sep 08 '17 at 16:18
  • code is simple. `cols <- read_excel(files, sheet = 1,col_names = FALSE )` . output in examples above. I just found partial solution:`col_types="numeric" ` give a correct output for huge numbers, but I can't specify col_types for all colums, as number of columns is really big. – Евгений М Sep 08 '17 at 16:25
  • 1
    do you get the correct numbers with `col_types="list"` ? – Stéphane Laurent Sep 08 '17 at 16:40

0 Answers0