Browse the content of an EXCEL file using Qlikview script

[#1]

Hello community.

I have an Excel file that has 6 columns.

I would write a script that can Qlikview
allow me to browse the contents of these columns
for manipulating the values ??otherwise.

Thank you for offering me a script that would enable me
to do that.

Thank you in advance for your help

[#2]

Hi Yimen,

If you select your Excel spreadsheet in the Script Editor via the Table Files button, QV will give you a Preview at some point of what the data looks like.

The number of rows you want to show in this preview are set in User Preferences > Design tab, at the bottom you have a field that says File Wizard Sample Size (Rows). Set that to whatever you want, but keep it a reasonable amount.

[#3]

Please, i mean programming

Thanks

[#4]

Hold on a second, I've re-read your post and am not too sure anymore what you want to do with this "view".

Can you check inputfield in the Help Guide, is this what you are looking for. Loading data from Excel and then allowing end-user to manipulate these values?

[#5]

Hi Yimen,

Check my attached QVW. Is this what you are looking for?

There is a pivot table in the front-end using the inputfield (basic instructions in the text box).

And I have commented out the script to tell you how to create inputfields in the back-end and attach to tables.

I hope this is what you are looking for. Otherwise, can you explain a little more what you are trying to do and/or share a sample QVW file?

[#6]

Hi Yimen,

Just a last note. These inputfields can be shared within a bookmark across users, if you have enterprise edition of server.

Don't forget that QlikView is not a data entry application.

The inputfield values get written out to the users folder in the server along with their bookmarks, etc. They will not, and no one should advocate that they should, be written to a database table.

Hope this helps.

[#7]

Can we manipulate cells using the code (script) Qlikview?

thx