import excel file

[Anonymous]

hi every one

i want to import cell reference excel  file to qlikview  in which whenever i try to change the header of that specific cell  or add another column and then update qlikview file, the new one be updated. for example  i have this table in excel file:

  the old one:

    product Id                 Unit

     100                          xxx

      200                         hhh

then i want to change excel file into:

   product/material id         unit         quantity

    100                              xxx          5555

     200                             hhh          1111

     300                             hhh           7777

after i update qlikview i want to the new excel table be replaced. has everyone can help me?

[beck_bakytbek]

Hi Ali,

look at this: http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

i am sure that resolves your solutions

beck

[rahulpawarb · Accepted solution]

Hello Ali,

As per my primary analysis, you don't want to change the Qlikview script though you changed the source excel file. Post reload you should get the all changed data. If this is it then please change the source table structure to below:

Product Id	Field	Value
100	unit	xxx
100	quantity	5555
200	unit	hhh
200	quantity	1111
300	unit	hhh
300	quantity	7777

If you want to change the header of any field then please do the same within Qlikview script.

Hope this will be helpful

Regards!

Rahul

[Anonymous]

hi Rahul

it was so helpful, thank you.

[rahulpawarb]

Cheers,

Rahul