Need to develop a application were user will view the current project status based on color (green/amber/red) from the excel file attached. I need a script were qv will read the - 1. Project Status (from report sheet) 2. Key Mile Stones 3) Emp name (from timesheet)
Go to the script - at the very bottom you have a tab called Data -> Data from Files. Select Table files and pick your IBM.xlsx file. There you should be able to see your fields you wish to read. Everything else from there on should be straightforward.
If you wish to read multiple excel files I recommend creating a standard xls-file name e.g. TimeSheet_Owner_Date.xlsx and then load all files at once using the * qualifier e.g.
TimeSheet_*.xlsx
This will read all available xlsx files with the same beginning filenames.
