Category: Performance

  • How to fix CLSID {00024500-0000-0000-C000-000000000046} error when using excel component in background code?

    We have  a windows Service application which uses Excel Application Object. It used to work on some machines but not all, the error which I am getting is: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005. After some struggling I found a solution and it works,…

  • JSON date to Date object – javascript

    While working with web services or API with json return, we will get date values in different format, we can’t use this as is where required. To convert to date object we need to extract integer value and then pass to Date object, below example shows how to get valid date object. [javascript] var json…

  • How to display negative time in excel cell

    While working with excel application I found that if we find difference between 2 times is negative then excel doesn’t display time, it shows “##########” instead of values. For positive difference we don’t have any issue. There are 2 ways to handle this, using 1904 date system and other using custom formula. To change the…

  • How to enable HTTP Compression of Static and Dynamic Contents IIS

    Enabling compression of static and dynamic contents of your website will be more help to load your website faster on browsers. To enabling both you must have to install “Dynamic Compression” and “Static Compression” on the server features and roles. Open server manager Roles > Web Server (IIS) Role Services (scroll down) > Add Role…