Development

Flexible and simple Export to Excel for .Net

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 […] Read more»

.Net & C#

How to compare 2 Dates in TypeScript / JavaScript

Javascript logo

The Date is an object in JavaScript and TypeScript. When you have some spare time, try to compare 2 objects, you will find a lot of interesting things 🙂 Obviously, you need to compare not object, but their properties. Read more»

React

Improve Site Quality with Lighthouse

Sometimes I like to use calculate different measures for one or another site. Last weekend I read about Lighthouse – it’s a part of DevTools in Google Chrome. I have already forgotten that I have such a powerful tool in my pocket and don’t use it. What is Lighthouse? Lighthouse is an open-source, automated tool […] Read more»

React

SharePoint List Template ID Reference

SharePoint 2016 Logo

Its’s more and more complicated to find information about SharePoint. I don’t really know why it’s so. That’s why I often write down the references and examples. Today I tried to remember how to create a SharePoint list with PNPJS and there’s a parameter which template you will use. Read more»

SharePoint

How to create a striped DataGrid in Material UI (React, TypeScript)

Material UI

DataGrid looks like a table, but it’s another component, it consists of multiple div-elements. But for a user it’s a table and common table attributes are often required. One of them is striped rows. Below there’s an example how to implement it. Read more»

React

Swagger error ‘Failed to load API definition’

When you execute your Web Api and at Swagger Page you can see Swagger error ‘Failed to load API definition’, you can’t really determine, where the error is. It is in one of the controllers. But do you want to check all of them? Read more»

.Net & C#

Feed uniqueidentifier field with Random GUID value in SQL

There’s a data type ‘uniqueidentifier’ in SQL. If you need to feed this field with random value, you can use NEWID(). The ‘uniqueidentifier’ value in SQL looks like this: ‘234779E5-996F-45AC-90C3-21631AF4A08D’. Read more»

SQL and databases

Popular Posts