topic Re: Help with spreadsheets in QlikView

Help with spreadsheets

carolinne88 — Wed, 25 Nov 2020 16:16:04 GMT

Hello, guys!

Hello guys!
I need help putting together a read script for this attached spreadsheet template.
I need to extract the drive and date information in addition to the information in the post table.
I'm finding it difficult to fix a script that returns this bound data (the unit and the date bound to the table information).
I have several spreadsheets in this same template and would looping the script so they all read, differentiating only date and unit information.

Re: Help with spreadsheets

felipedl — Thu, 23 Nov 2017 18:59:47 GMT

Hi Carolinne,

I've made some small changes to the layout of the file (by adding an additional empty row for each sheet and redifining the layout of the header for the initial 5 rows) and attached the Excel and QVW file I've used to get the data.

See if that's what you need.

Felipe.

Re: Help with spreadsheets

carolinne88 — Thu, 23 Nov 2017 19:18:03 GMT

Hi Felipe. Thank you!
What I'm looking for is not to change the layout of the worksheets and I'll tell you why.

I will receive monthly the same updated worksheets from another person who has already filled this basic template for a long time and simple changes are received negatively.

Since there are many spreadsheets (over 20), I would have to modify them one by one every month.
Each worksheet is of a different unit.

Re: Help with spreadsheets

felipedl — Thu, 23 Nov 2017 19:46:42 GMT

The adjustments I used in the fields can be remade with the original file format, but you will need a sheet, or a text file of some sort for all the labels you have in the excel sheets containing data because it won't be able to loop through all the sheets otherwise.