pg_importxl: Read tabular data in excel file (xls or xlsx) and write it in...

In diegogarcilazo/pgr: Set of wrapper functions to work with PostgreSQL.

Read tabular data in excel file (xls or xlsx) and write it in PostgreSQL.

Description

Read tabular data in excel file (xls or xlsx) and write it in PostgreSQL.

Usage

pg_importxl(
  con,
  file = file.choose(),
  sheet = "Hoja 1",
  schema,
  table,
  col_types = NULL
)

Arguments

con:	Pg connection.
file:	path excel file.
sheet:	excel sheet where is the table.
schema:	name of schema to write.
table:	table name.
col_types:	chr Either NULL to guess from the spreadsheet or a character vector containing "blank", "numeric", "date" or "text".

diegogarcilazo/pgr documentation built on Nov. 16, 2023, 6:24 p.m.