my blog. for you.

Let’s talk digital.

I’m an independent IT consultant and entrepreneur in the Internet and software business. I’m interested in design, enterprise applications, web apps and SaaS products. I design and develop business solutions and applications. I help companies in terms of software quality and knowledge transfer, e.g. with Angular and Spring Boot.

PivotHelper: Generate Pivot Tables and Pivot Charts from CSV and Microsoft Excel Spreadsheet Files

Somewhat recently, I regularly had to generate Pivot tables and corresponding charts from datasets provided as both CSV and Microsoft Excel files. Now, with its data source and pivot table tools Microsoft Excel usually lends itself to that sort of task. However, to completely automate this task VBA macros are required. Those too work quite nicely if one overcomes the initial aversion of working with Microsoft's not exactly well-designed and usable IDE for VBA macros (Excel's own macro recording feature is quite ... Read more

Exporting table data in web applications as CSV or Excel files

In business applications being able to export data to Microsoft Excel is a very common requirement. In most business environments Excel is the go-to tool for business analytics and quick-and-easy data processing. Hence, being able to communicate with Excel is an essential feature for most kinds of business software. The usual approach for meeting that requirement is generating a CSV file on the server. However, while simple this approach can come with a few downsides: While CSV is a useful, accessible plain text ... Read more