Once again I have to make Export of to Excel. And this time there are requirements to the template – colors, formatting and others. Not so long ago I implemented the export to Excel with XLSX package for React, and it was rendered at client. This solution is good but has many constraints. So, I started to look for another solution.

CsvHelper is a very good library for reading and writing CSV files. It’s really easy for coding and fast for work. You can install it via Nuget in Visual studio or download from the project page in GitHub https://github.com/JoshClose/CsvHelper.  (read more...)

You can merge Excel cells in 3 simple steps:

1. Select a range of cells.
2. Right click on the selected cells and then choose Format Cells (Figure 1)
3. Go to the Alignment tab and check the checkbox "Merge cells" (Figure 2).

The other way to merge cells in Excel is via Excel Ribbon. This way is one step less. (read more...)

Excel has a huge number of tools for customizing text and tools to count data. So, one of useful things is to rotate text on any angle. It can be useful for customizing table headers. (read more...)

When you work in Excel with large tables, for example, price list, sometimes while scrolling you forget what columns you are watching. To make more comfortable work with tables you can fix position of cells (row or column) so that other cells to be scrolled and the cells with names are fixed. (read more...)