XL-Dennis's Blog : SQLite

Clean Up!

VSTO & .NET & Excel — Sun, 24 Mar 2013 19:52:19 GMT

As part of my maintenance, in order to keep the computer fresh, is to regular run the built-in tool Free up disk space. The tool is accessible via the following commands: Start Button > Control Panel > System and Security > Administrative Tools > Free up disk space After running it the following dialog is [...] Read More......(read more)

Best Practices Export Data to Excel

VSTO & .NET & Excel — Mon, 30 Jan 2012 12:43:28 GMT

If You’re a VBA Developer You should know what best practices is to export data to MS Excel. Two expressions summarize it; Microsoft ActiveX Data Object Library and CopyFromRecordset. However, if You’re a .NET developer and face a situation where You must find a solution to export data to MS Excel then there is a [...] Read More......(read more)

Real Studio – The Perfect Companion for SMEs

VSTO & .NET & Excel — Tue, 20 Dec 2011 23:43:32 GMT

Introduction In the beginning of this year I decided to explore Real Studio (formerly Realbasic, RS) which is a full featured cross-platform software development tool. With it we can create a wide range of applications, from small tiny utilities to enterprise applications that target Mac OS X, Windows, Linux and the web. Initially I had [...] Read More......(read more)

Paradigma offer Valentina Office Server 5.0 for free!

VSTO & .NET & Excel — Tue, 08 Nov 2011 14:43:32 GMT

Paradigma announced today that they will offer the next version (5.0) of their Valentina Office Server for free. The offer targets certain groups of users, including Small and Medium sized companies, and for certain tasks. Not only that, under the same license conditions they also offer Valentina Studio + Valentina Report for free together with any [...] Read More......(read more)

SuperOrca Tool

VSTO & .NET & Excel — Wed, 06 Apr 2011 21:12:16 GMT

In a previously blog entry, The Orca Tool – A MSI Creator and Package viewer, I discussed the Orca tool for working with MSI Databases. The utility does its work so there is nothing to complain about. OK, one negative thing is that we must download the whole Windows SDK in order to get the [...] Read More......(read more)