xls file with multiple header row

[#1]

Hello all,

I need your help to solve my issue. I have a excel file with a multiple header row like this :

so what i would doing is : when i went to loaded this excel file, and add may be some script to define that the first header week it contains the second header so the values 27, and 28. and the third header contains d1, d2, d3, d4 and d5 for the value 27.

i need to have something like this : when i click on week, it appears 27 and 28 and when i click on 27 i can see the days for the week number 27 ( d1,d2, d3,...).

Thank you !

Bonjour à tous,

J'ai besoin de votre aide pour résoudre mon problème. J'ai un fichier excel qui contient plusieurs entêtes, et ce que je voudrais faire c'est d'indiquer peut être à l'aide d'un script que l’entête week contient l’entête 27 et 28 qui correspond au numéro de week, et les numéros de week contiennent les jours. Plus précisément je voudrais quand je clique sur week, ça m'affiche  27 et 28 et quand je choisi une valeur entre les 2, ça m'affiche d1, d2,d3,d4,d5 dans le cas de week 27, et d6, d7,d8,... dans le cas de 28.

Merci de m'aider à résoudre mon souci.

[#2]

Could you send me the 2 scripts in txt format please ?

[settu_periasamy]

Find attached..

[#4]

I replace SET vSourceFile =  'pivotimporttest.xls' by the name of my excel file, but i have this errer.

[settu_periasamy]

Hi,

Try

1. Convert your xlsx file into xls

2. Qvw file and xls, should be in same folder (don't forget to check the Relative paths)

Edit:

if you dont' want to change your xls file..

you can try

SET vSourceFile =  'pivotimporttest.xlsx';

SET vSheet = '[Sheet1]';

SET vType = 'ooxml';

[#6]

Hi,

I change type and I make Qvw file and xls in same folder, but I have the same problem

[settu_periasamy]

Can you post your updated qvw?

[mohamed_ahid]

for type changing ,you will need to use" save as" and not juste changing extension .

have you done it like this way ?

[#9]

yes, I use save as

[#10]

Find attached the script

[mohamed_ahid]

and you choosed .xls (Excel 97-2003). ?