Click here to Skip to main content
11,495,945 members (62,909 online)
Click here to Skip to main content

ExcelQuicker

, 26 Jun 2005 92.6K 3.3K 53
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 ! Pin
Mazen el Senih21-Mar-12 12:36
memberMazen el Senih21-Mar-12 12:36 
GeneralExcelQuicker for Winforms Pin
dswdl7-Feb-09 23:10
memberdswdl7-Feb-09 23:10 
GeneralRe: ExcelQuicker for Winforms Pin
IBOLS4-Feb-10 18:28
memberIBOLS4-Feb-10 18:28 
GeneralSample Project Can't be Run Pin
Aaron61523-Feb-08 4:19
memberAaron61523-Feb-08 4:19 
Generalexcel project deployment Pin
fatih isikhan11-Apr-06 4:56
memberfatih isikhan11-Apr-06 4:56 
GeneralRe: excel project deployment Pin
Dogu Tümerdem28-Jun-06 3:13
memberDogu Tümerdem28-Jun-06 3:13 
GeneralRe: excel project deployment Pin
fatih isikhan28-Jun-06 3:20
memberfatih isikhan28-Jun-06 3:20 
GeneralWinformsexample Pin
hugobq10-Jan-06 8:14
memberhugobq10-Jan-06 8:14 
QuestionRe: Winformsexample Pin
nguyen van long1-Jun-06 22:24
membernguyen van long1-Jun-06 22:24 
GeneralFaulty CHM Pin
SohailB3-Sep-05 3:15
memberSohailB3-Sep-05 3:15 
GeneralExcel.EXE Pin
epasinetti26-Aug-05 2:40
memberepasinetti26-Aug-05 2:40 
GeneralRe: Excel.EXE Pin
Eunge12-Sep-05 2:03
memberEunge12-Sep-05 2:03 
GeneralWindows Forms sample Pin
Alomgir Miah11-Jul-05 10:49
memberAlomgir Miah11-Jul-05 10:49 
GeneralRe: Windows Forms sample Pin
Eunge11-Jul-05 19:32
memberEunge11-Jul-05 19:32 
GeneralRe: Windows Forms sample Pin
js ko11-Sep-05 21:42
sussjs ko11-Sep-05 21:42 
QuestionRe: Windows Forms sample Pin
Golyakoff Andrew2-Aug-06 1:22
memberGolyakoff Andrew2-Aug-06 1:22 
AnswerRe: Windows Forms sample Pin
Golyakoff Andrew2-Aug-06 1:23
memberGolyakoff Andrew2-Aug-06 1:23 
GeneralRe: Windows Forms sample Pin
sv21913-Apr-07 13:58
membersv21913-Apr-07 13:58 
GeneralRe: Windows Forms sample Pin
dylan chou13-Sep-13 1:49
memberdylan chou13-Sep-13 1:49 
GeneralNaming of "source" files Pin
fwsouthern28-Jun-05 19:00
memberfwsouthern28-Jun-05 19:00 
GeneralRe: Naming of "source" files Pin
Eunge30-Jun-05 5:05
memberEunge30-Jun-05 5:05 
GeneralFormulas Pin
angel.carrillo20-Jun-05 6:57
memberangel.carrillo20-Jun-05 6:57 
GeneralRe: Formulas Pin
Eunge20-Jun-05 19:20
memberEunge20-Jun-05 19:20 
GeneralGood project! Pin
uuy12-Jun-05 20:59
memberuuy12-Jun-05 20:59 
GeneralRe: Good project! Pin
Eunge13-Jun-05 8:06
memberEunge13-Jun-05 8:06 
GeneralUm... Pin
Jamie Nordmeyer6-Jun-05 5:57
memberJamie Nordmeyer6-Jun-05 5:57 
GeneralRe: Um... Pin
Eunge6-Jun-05 6:20
memberEunge6-Jun-05 6:20 
GeneralRe: Um... Pin
Jamie Nordmeyer6-Jun-05 6:24
memberJamie Nordmeyer6-Jun-05 6:24 

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
Web02 | 2.8.150520.1 | Last Updated 27 Jun 2005
Article Copyright 2005 by Eunge
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid