topic Loading multiple excels in App Development

Loading multiple excels

ecabanas — Sat, 16 Nov 2024 18:49:16 GMT

I have a folder with several excel files. I would like to import all files with the same tab to a table. I create a connection to the folder where the files are, but the script fails, any idea what's wrong?

Se ha producido el siguiente error: Cannot open file: 'lib://Miservi_Excels (ulabox_ecabanas)/*.xlsx;' (Native Path: *** System error: ***) El error se ha producido aquí: Miservi: LOAD Planta, 'PE'&TarjaPagamentNom as order_id, Data, Hora, Caixa, Caixer, Total, LiniesTiquet, Base FROM [lib://Miservi_Excels (ulabox_ecabanas)/*.xlsx;] (ooxml, embedded labels, table is Capçaleres) No se han cargado los datos. Por favor, corrija el error y pruebe a cargar de nuevo.

Thanks

Re: Loading multiple excels

haskia — Tue, 07 Apr 2020 13:48:44 GMT

Hi @ecabanas ,

I think there's a typo in your FROM statement. Try changing it into

FROM [lib://Miservi_Excels (ulabox_ecabanas)/*.xlsx] ;

Another common error when loading from Excel spreadsheets - is different sheet naming. In that case you would need to adjust or drop this part:

table is Capçaleres

Re: Loading multiple excels

ecabanas — Tue, 07 Apr 2020 14:09:43 GMT

Hi @haskia

Thank you!!!! I too tired 😉