Reading from excel

[#1]

Hi All,

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)

4) all other fields from the Timesheet ...

Kindly advice how to proceed.....

link to the excel file - IBM.xlsx

there will be multiple excel files on week/monthly wise and qv needs to read periodically........................

[simondachstr]

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.