EasyXLS™: Export data to MS Excel Workbooks

By | 2017-04-27

Introduction In my second article about EasyXLS focus is on how to export data to MS Excel Workbooks by using the excellent .NET component. Again it strikes me how easy it is to work with EasyXLS’s Excel object model. Also, the few code lines it requires to create powerful solutions. It’s difficult to find new approaches in view… Read More »

admin

EasyXLS™ : Manage MS Excel Data & Files Excellent.

By | 2017-04-12

Introduction Nowadays I get very rarely impressed by any software. I believe I can count them on one hand only. The software component I will introduce with today’s article is actually one of them, EasyXLS. EasyXLS is a powerful .NET component that can manage MS Excel files by reading from them and writing to them. It can be installed on a server or on… Read More »

admin

Xojo: Creating Excel Reports with ExcelWriter

By | 2017-04-01

Introduction Developing with Xojo gives us two options to control and manage Excel workbooks without MS Excel. One of the option is to use the MBS XL Plugin from Monkeybread Software. It’s the most expensive solution as the plugin is part of the commercial package MBS Xojo Plugins. The MBS XL requires also us to have a license of… Read More »

admin

VB6: Manage Excel Reports Not By Automation

By | 2017-03-21

Introduction Ever since I wrote the first VB6 article and MS Excel automation I have had this type of article in my mind. As this article shows, it’s possible to interact with workbooks without having MS Excel installed even with an old tool like classic VB. Here the classic Microsoft ActiveX Data Object (ADO) model is used to retrieve data… Read More »

admin

Xojo: Manage Excel Reports Through Automation

By | 2017-03-15

Introduction Here I go again! This time I use Xojo to control and manipulate MS Excel’s files with. Here I use the add-in for MS Office that is shipped with Xojo. It requires that MS Excel is installed. At present I look through my add-ins to see if I still have the add-in for MS Excel and that… Read More »

admin

Xojo: Call for MS Excel – Another Spreadsheet is Opened!

By | 2017-03-14

On my computer I have MS Excel installed together with several other Spreadsheet software. Among the other Spreadsheet software installed I have WPS Office installed. Don’t recall how I got it… When I ran the following code in Xojo I assumed MS Excel would have been loaded, right? The following screenshot shows that the file, a MS Excel… Read More »

admin

DevExpress: Manage Excel Reports Through Automation

By | 2017-03-03

Introduction In the past the common approach to manage Excel files was to install MS Excel on the server. For years it was applied despite Microsoft disagreement to do so. Today the situation is totally changed. Many third-part vendors provide us with solutions that do not require MS Excel to be available at all. For me automation has… Read More »

admin

VB6: Down the memories line – Automation of MS Excel

By | 2017-02-11

When I wrote the article about B4J and MS Excel I got a stronger feeling on publishing the report solutions based on Classic VB (VB6).  Here it is and I’m happy to share it with You. Despite all the great new developing tools outhere I still prefer to use Classic. Why? Because it’s still an excellent RAD-Tool. The following code is used… Read More »

admin

MS Excel not Your Default Program…

By | 2017-02-08

I couldn’t resist posting this message: What I guess is that everyone else who pretend to be nerd has MS Excel as its default program for viewing and editing spreadsheets 🙂 The question is, what other spreadsheet program is my default? Well, in an upcoming blog I will reveal it! Stay tune, Dennis

admin

B4J: Generate Excel Reports

By | 2017-01-24

Introduction The real power for using MS Excel workbooks as reports lays in the fact that we can create templates. A template in MS Excel is saved with the file extension *.xltx (*.xlt for older versions, 2007 and earlier) where the “t” stands for template. The key feature with it is that whenever we open it via code… Read More »

admin