Click here to Skip to main content
Click here to Skip to main content

ExcelQuicker

, 26 Jun 2005
Rate this:
Please Sign up or sign in to vote.
The program is designed to simplify the development of reports, based on Office Excel 2000 or above environment.

Background

  1. Worldwide

    As we know, Microsoft Office is the most fashionable system all over the world. And Excel is one of the most important elements. We can see Office on nearly every PC with Windows OS.

  2. Performance

    The function of Excel is very powerful, specially in routine reporting, data statistics and analysis, and is even comparable to the popular report systems such as Crystal Reports and Fast Report.

    As we know, Excel not only supports .xls files but also can cope with .htm and several other formats. Besides various supported formats, it allows OLAP, rich style and VBA macros. Even many companies develop applications based on Excel.

  3. Low-Cost

    Talking about report services, I think most programmers are familiar with Crystal Reports and Fast Report. But the price of these professional report systems is very high. I know a full-license of Crystal Reports will cost several million RMB (Chinese currency).

    Comparing with these report systems, Microsoft Office system only costs several dollars. Yes, we can know it is several times cheaper than other report systems.

  4. Development

    If we are familiar of the Excel COM Interfaces, we can see they are not friendly indeed. Microsoft provides us the best applications but does not expose the best and efficient way. That's why I developed this control.

  5. Technology

    Lots of people know how powerful the Excel is. But they encounter technical problems often. Such as they cannot dispose memory efficiently after an operation, or the rate of output of an Excel document maybe too slow. Indeed, these are only caused by their inexperience on developing on Excel and the complex structures of Excel COM Interface.

Introduction

Yes, those reasons are why ExcelQuicker is invented now. It is based on the cut-price Office system and it can provide powerful functions as Office's. Meanwhile, it combines Excel COM interface and shows you a new, simple and clear class diagram.

ExcelQuicker does not only provides us .xls format report, but also can create .html online reports. Inside it, there is favorable design and algorithmic optimization. The rate of generating reports is very fast, and you can see that from the statistics below (environment: P4 2.4G CPU+ 1G RAM):

As the diagram shows, at the beginning, it will cost 25 minutes when we generate a report with 2W records (20000 rows * 10 columns). But now ExcelQuicker v2.2 only needs 2 minutes. And it also illustrates that I am upgrading and optimizing ExcelQuicker constantly. I think it will be better in the future.

CSS - HTML = VBA - Excel

Besides performance, ExcelQuicker brings us a new idea that is design mode. I think every web application developer knows how important the CSS is to a web page. Now, the idea is that the VBA macro is also very important to reports when we use ExcelQuicker to develop reports.

We can record some VBA macros in Excel applications and save them in an Excel file. The Excel file assumes it as Excel template document when we are using ExcelQuicker. It will create report files based on this Excel template document. And you can set the VBA hooker to call these VBA macros in an Excel document. You can change the reports easily without re-compile the projects.

For example, at the beginning, customer requires us to design report title font in red. But after sometime, he changes the requirement and asks us to create black title font. In this case, if we design the title font style as VBA macros in an Excel document, we only need to modify those VBA macros in the Excel template document. It's not necessary to re-compile the project now. It's very convenient.

Maybe you know nothing about Excel VBA macros. It doesn't matter. You can record VBA macros in Excel applications easily. And then, nearly 80% of those VBA macros can be used in ExcelQuicker.

You can write as follows to construct a VBAHooker object:

EQVBAHooker vba = new EQVBAHooker("AdjustWidth");

It means that it will call the VBA macro "AdjustWidth" automatically in the Excel document at runtime.

Finally, ExcelQuicker not only relies on VBA macros call. Indeed, it's a framework, it has many classes and can help you to create reports.

Estimation

I comparing here the benefits of ExcelQuicker and Crystal Reports.

You can choose ExcelQuicker based on Office 2000 or Office 2003. Office 2000 is 200 dollars less than Office 2003, but your application using ExcelQuicker based on Office 2003 in much more stable and safe than that using Office 2000. Whatever your choice, I think you know they are much cheaper than a Crystal Reports solution.

So, my advice is that keep calm when you need to choose report solutions. If there is no special requirement, I think it's not necessary to adopt Crystal Reports.

Moreover, as an open source and non-commercial software, I advice you choose ExcelQuicker. It can bring you a highly efficient and performable experience in development or runtime.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

Eunge
President TCWH
China China
I've worked as a software architect and developer based on Microsoft .NET framework and web technology since 2002, having rich experience on SaaS, multiple-tier web system and website development. I've devoted into open source project development since 2003, and have created 3 main projects including DataQuicker (ORM), ExcelQuicker (Excel Report Generator), and RapidWebDev (Enterprise-level CMS)

I worked in BenQ (8 mo), Bleum (4 mo), Newegg (1 mo), Microsoft (3 yr) and Autodesk (5 yr) before 2012. Now I own a startup company in Shanghai China to deliver the exceptional results to global internet users by leveraging the power of Internet and the local excellence.

Comments and Discussions

 
SuggestionHello ! PinmemberMazen el Senih21-Mar-12 12:36 
GeneralExcelQuicker for Winforms Pinmemberdswdl7-Feb-09 23:10 
GeneralRe: ExcelQuicker for Winforms PinmemberIBOLS4-Feb-10 18:28 
GeneralSample Project Can't be Run PinmemberAaron61523-Feb-08 4:19 
Generalexcel project deployment Pinmemberfatih isikhan11-Apr-06 4:56 
GeneralRe: excel project deployment PinmemberDogu Tümerdem28-Jun-06 3:13 
GeneralRe: excel project deployment Pinmemberfatih isikhan28-Jun-06 3:20 
GeneralWinformsexample Pinmemberhugobq10-Jan-06 8:14 
QuestionRe: Winformsexample Pinmembernguyen van long1-Jun-06 22:24 
GeneralFaulty CHM PinmemberSohailB3-Sep-05 3:15 
GeneralExcel.EXE Pinmemberepasinetti26-Aug-05 2:40 
GeneralRe: Excel.EXE PinmemberEunge12-Sep-05 2:03 
GeneralWindows Forms sample PinmemberAlomgir Miah11-Jul-05 10:49 
GeneralRe: Windows Forms sample PinmemberEunge11-Jul-05 19:32 
GeneralRe: Windows Forms sample Pinsussjs ko11-Sep-05 21:42 
QuestionRe: Windows Forms sample PinmemberGolyakoff Andrew2-Aug-06 1:22 
AnswerRe: Windows Forms sample PinmemberGolyakoff Andrew2-Aug-06 1:23 
GeneralRe: Windows Forms sample Pinmembersv21913-Apr-07 13:58 
GeneralRe: Windows Forms sample Pinmemberdylan chou13-Sep-13 1:49 
GeneralNaming of "source" files Pinmemberfwsouthern28-Jun-05 19:00 
GeneralRe: Naming of "source" files PinmemberEunge30-Jun-05 5:05 
GeneralFormulas Pinmemberangel.carrillo20-Jun-05 6:57 
GeneralRe: Formulas PinmemberEunge20-Jun-05 19:20 
GeneralGood project! Pinmemberuuy12-Jun-05 20:59 
GeneralRe: Good project! PinmemberEunge13-Jun-05 8:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.150331.1 | Last Updated 27 Jun 2005
Article Copyright 2005 by Eunge
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid