Ruby - Excel

Is it possible to have web application like share point where we can have a single excel file with data and pivot, user can select the fields from UI and ruby should read the data from pivot (data after refreshed) after executing the Macro.