Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
carolinne88
Creator
Creator

Help with spreadsheets

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.

3 Replies
felipedl
Partner - Specialist III
Partner - Specialist III

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.

carolinne88
Creator
Creator
Author

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.

felipedl
Partner - Specialist III
Partner - Specialist III

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.