Sunday, September 11, 2016

Online Data Doesn't have to be Dumb

An Article on Automatic Excel Filters by Garry Robinson



Imagine if your Excel spreadsheet opened up with Filters are turned on, this would make your spreadsheet become more useful instantly. If we export our data to a basic spreadsheet, we should think about providing our users with filters and sorting from the get go rather than hoping they will find the Filter button in the menu of the Excel User Interface.

This article shows how you can use Excel Automation to add filters and demonstrates what that looks like in Excel Online. It then gives you clues as to how you can start to apply filters of your own to your OutputTo XLSX spreadsheets.


This article follows on from last months piece on Excel Online - File types and other basics

No comments: