Proveedor de datos para hojas de cálculo

Importa datos de varios orígenes. Por ahora, los formatos de datos externos admitidos son CSV, HTML y XML.

Los datos pueden importarse tanto del almacenamiento local, en forma de archivos CSV, por ejemplo, como de orígenes externos tales como páginas HTML.

Además, es posible manipular los datos a través de varias transformaciones antes de cargarlos en la hoja.

Para acceder a esta orden…

Desde la barra de menús:

Vaya a Datos ▸ Proveedor de datos.

Desde la interfaz en pestañas:

On the Data tab, choose Data Provider.

Desde las barras de herramientas:

Proveedor de datos

Intervalo de base de datos

The database range to receive the data from the provider. Choose the range from the available dropdown list.

Formato de datos

El tipo de datos que se importarán.

URL

El URL del proveedor de datos. Si el proveedor es un archivo local, introduzca la ruta y el nombre. Si es un servicio web, introduzca el URL.

Identificador

The target ID for HTML provided data or Xpath for XML provided data.

Transformaciones

The provided data can be transformed using the available transformations from the dropdown list. You will need to provide further information depending on the transformation. For example, you can set the sort order for the sort transformations.

Eliminar columnas

Deletes columns listed in Columns. Enter the list of columns indexes separated by semicolons.

Eliminar filas

Deletes rows containing the value entered in Lookup value entry and found in Column index number.

Swap Rows

Swap row position between the first and second rows.

Dividir columnas

Separa la columna en dos donde aparezca la cadena separadora.

Combinar columnas

Combina columnas añadiendo la cadena separadora entre cada valor combinado.

Transformación de texto

Transforma los datos textuales de la lista de columnas.

To Lower: transforms all uppercase characters to lowercase.
To Upper: transforms all lowercase characters to uppercase.
Capitalize: capitalizes the first character of each word.
Trim: removes spaces from the data, leaving only a single space character between words.

Ordenar columnas

Sorts rows ascending or descending by the values in the column index number.

Funciones de totalización

Adds the result of an aggregate function to the bottom of the column.

Sum: the sum of the column data.
Average: the average value of the column data.
Maximum Value: the maximum value of the column data.
Minimum Value: the minimum value of the column data.

Numérico

Applies numeric functions on columns.

Sign: returns +1 for strictly positive numbers, -1 for strictly negative and 0 for zero values.
Round: rounds numbers to a certain number of decimal places.
Round Up: rounds numbers to the nearest upper integer.
Round Down: rounds numbers to the nearest lower integer.
Absolute value: returns the absolute value of the numbers.
Log with base e: returns the natural logarithm of the numbers.
Log with base 10: returns the logarithm base 10 of the numbers.
Cube: returns the cube of the numbers.
Square: returns the square of the numbers.
Square Root: returns the square root of the numbers.
Exponent: returns the exponential of the numbers (e^x).
Is Even: returns +1 is the number is even, 0 if the number is odd. Decimal numbers returns 0.
Is Odd: returns +1 is the number is odd, 0 if the number is even. Decimal numbers returns 0.

Replace Null

Replaces null or missing data in the list of columns with the supplied text.

Fecha y hora

Performs date and time transformations on data in the list of column indexes.

The date and time values depends on the locale settings.

Cadena de fecha:
Year: returns the year of the date.
Start of Year: returns the date value of the first day of the year.
End of Year: returns the date value of the last day of the year.
Month: returns the month number of the date.
Month Name: returns the month name of the date.
Start of Month: returns the date value of first day of the month.
End of Month: returns the date value of the last day of the month.
Día: devuelve el día del mes.
Day of Week: returns the day of the week.
Day of Year: returns the day of the year.
Quarter: returns the quarter number of the date.
Start of Quarter: returns the date value of the first day of the quarter.
End of Quarter: returns the date value of the last day of the quarter.
Hour: returns the hour of the date.
Minute: returns the minute of the date.
Second: returns the second of the date.
Time: returns the time of the date.

Buscar y reemplazar

Finds and replaces values in Column index number.

Añadir

Click Add to include the selected transformation to the transformation set. Transformations are included at the bottom of the list.

If the order of transformations is important, plan the sequence of transformations in advance.

Eliminar

Elimina la transformación de la lista.

Aplicar

Applies the transformations to the provided data and displays results in the preview area for inspection. The data is not loaded in the spreadsheet until you press OK.

The data formatting can be set with a right-click on the preview table column headers. The corresponding database range column is then selected. Format the cells with the context menu.

XPath tutorial