Using Excel Files with Webix Widgets

As a rule, companies work with a lot of data and already use Excel files in their workflows. Among other things, business process automation requires shared access to files. For sharing, Excel files can be published as web pages or uploaded to web services like Google Docs. And still, there is a problem because such services do not allow you to embed spreadsheets into web applications and web sites. I’ll show you how Webix UI library can help you with this task.

Excel with Webix Widgets

How to Create Custom Report Engine with Webix Spreadsheet

Software can make your routine simpler and with better results. For instance, making clear and good-looking reports would turn into a real battle without a helpful tool. One of these tools is Excel, a well-known mega-beast of valiant deeds and immortal glory. Yet, if business-warriors have to make some custom report, it’s developer-warriors who get their share of the job. This might be a problem. Every time you have to involve extra people in routine procedures, it’s costly and time-consuming (to say nothing of the fact that developer-warriors have a lot of other battles to fight).

create custom report

It would be good to design a report engine — another mega-beast that is as powerful and helpful. The complex widget SpreadSheet, one of the components of the Webix UI library, is a relevant core element for a decent mega-beast to win the deathmatch and save your end-users from extra expenses. Join me, developer-warriors, and I’ll show you how to enhance SpreadSheet and make it serve business-warriors well in their battles. Together we’ll create a spreadsheet-based report engine that will allow your end-users to make a custom report themselves by choosing templates from a list and editing them to their liking.

Creating a Gmail-like Interface with Webix

An app logic well done is only half a job accomplished. The other half is designing such a UI that would enhance the functionality of the app and make it rational and easy to navigate. Besides, it’s important to create a nice-looking interface to make apps recognizable and visually appealing.

Gmail has one of the most recognizable interfaces on the web. It’s neat and clean and can be used to rationally organize the massive app contents. In fact, Gmail UI can be used not only for email management but for other tasks as well. If you would like to know how to recreate such an interface and don’t know where to begin (or in case you are just curious), follow me. I’ll show you how to implement Gmail’s approach to designing interfaces with the Webix UI library.

Gmail-like interface with Webix

In-App Navigation Patterns

When the content of your web app gets bigger and bigger, it’s a good idea to split it into multiple screens. This, in its turn, demands convenient navigation, so that users could quickly find what they need. User experience isn’t supposed to turn into the quest for the Holy Grail.

Numerous navigation patterns have been designed to achieve this honorable goal. So if you are looking for ways to make your apps more handy and good-looking, join me on my ship, and together we’ll find our way in the sea of In-App Navigation and visit four remarkable islands of the Webix Archipelago: Sidebar, Tabbar, Top Menu, and Winmenu.

navigation design patterns

Master-Details Pattern with Webix UI

I guess, the master-details pattern needs no special introduction for practised web developers who create business apps that work with users, sales and such. Nearly any real life app has such a relation model and demands clear and easy navigation and inspection of information. Whether you plan to develop an email app, an address book, an RSS reader, a CRM, a social net app or any other app that is based on a list-details layout, the master-details pattern is a relevant solution.

Webix UI Library provides a number of ways to implement this technique: from simple to more complex, from pretty awkward to really handy ones. I’ll demonstrate them all while creating a mock email management app, and at the end of it all, you’ll see the most efficient, reliable and good-looking solution. Well, without further ado, let’s get down to the details of our master plan.

Master-details pattern with Webix UI

1 2 3 4 5 33