Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Fichier table/ multiple onglet

Bonjour,

Je souhaite intégrer un fichier table Excel avec plusieurs onglets.

Est il possible de variabiliser l'intégration ?

Les onglets portent les nom 121031/120930/120831 etc...

1 Solution

Accepted Solutions
cje
Employee
Employee

Bonjour,

Oui.

Exemple :

// declaration de variable

Let vNomOnglet=’Sheet1’ ;

// traitement de chargement

Load * from

LOAD *

FROM

(ooxml, embedded labels, table is $(vNomOnglet));

Si vous souhaitez parcourir votre liste d’onglets sous la forme d’une boucle, c’est possible également.

Vous trouverez un exemple type dans le QlikView reference manual à l’instruction For…Next à la page 231 du manuel V11.

Cdt

Christophe Jouve

Pre-sales solutions consultant

Direct: +33 1 55 62 65 54

Mobile: +33 6 76 24 22 47

Email: Christophe.Jouve@qlik.com

QlikTech France

93 avenue Charles de Gaulle

92200 Neuilly sur Seine

qlik.com<http://www.qlik.com/>

18 octobre 2012 | De la Business Intelligence à la Business Discovery...

http://www.qlikview.fr/BDWT-Paris

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

View solution in original post

3 Replies
cje
Employee
Employee

Bonjour,

Oui.

Exemple :

// declaration de variable

Let vNomOnglet=’Sheet1’ ;

// traitement de chargement

Load * from

LOAD *

FROM

(ooxml, embedded labels, table is $(vNomOnglet));

Si vous souhaitez parcourir votre liste d’onglets sous la forme d’une boucle, c’est possible également.

Vous trouverez un exemple type dans le QlikView reference manual à l’instruction For…Next à la page 231 du manuel V11.

Cdt

Christophe Jouve

Pre-sales solutions consultant

Direct: +33 1 55 62 65 54

Mobile: +33 6 76 24 22 47

Email: Christophe.Jouve@qlik.com

QlikTech France

93 avenue Charles de Gaulle

92200 Neuilly sur Seine

qlik.com<http://www.qlik.com/>

18 octobre 2012 | De la Business Intelligence à la Business Discovery...

http://www.qlikview.fr/BDWT-Paris

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

Not applicable
Author

Merci

cje
Employee
Employee

Bonjour,

Vous trouverez en pièce jointe un petit exemple qui devrait convenir à votre besoin. J’ai mis des commentaires dans le script pour vous aider.

Cdt

Christophe Jouve

Pre-sales solutions consultant

Direct: +33 1 55 62 65 54

Mobile: +33 6 76 24 22 47

Email: Christophe.Jouve@qlik.com

QlikTech France

93 avenue Charles de Gaulle

92200 Neuilly sur Seine

qlik.com<http://www.qlik.com/>

18 octobre 2012 | De la Business Intelligence à la Business Discovery...

http://www.qlikview.fr/BDWT-Paris

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.