Design Excel and HTML Report

As we known, 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 System. The function of Excel is very powerful, special in routine report, data statistic and analysis, even comparing to the famous report system such as Crystal Report and Fast Report.

As we know, Excel not only supports .xls file 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 application based on Excel. As report service, I think most programmers are familiar with Crystal Report and Fast Report. But the price of these professional report systems is very high. As I know, a full-license Crystal Report will cost several million RMB (Chinese currency).

Comparing with there report systems, Microsoft Office System only costs several dollars. Yes, we can know it is several tens times cheaper than those report system. If we know something about Excel COM Interface, we can see they are not friendly indeed. Microsoft provides us best application but not expose best and efficient way. That’s why I develop this control, I composite Excel COM Interface inner and integrate them into a high efficient and quality component. Some ones may know how powerful the Excel is. But they encountered technic problem really. Such as they cannot dispose memory efficient after operation, or the rate of output Excel document is too slow. Indeed, these only caused by their inexperience on developing Excel and the complex structure of Excel COM Interface.

Those reasons are why ExcelQuicker is invented now. It based on the cut-price Office System and it can provide the powerful functions as Office’s. Meanwhile, it combines Excel COM Interface and shows you the new, simple and clear class diagram.

ExcelQuicker not provides us .xls format report, but also can create .html online report. Inner of it, there is favourable design and algorithmic optimization. The rate of generating report is very fast, you can know from the statistic below, (Environment: P4 2.4G CPU+ 1G RAM)

CSS - HTML = VBA - Excel

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

What’s it? We can record some VBA macros in Excel application and save in excel file. The excel file assumes as excel template document when we 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 excel document. But the implementation decided on VBA macros in excel template file. You can change the report easily without re-compile the projects.

For example, at the beginning, customer requires us to design red report title font. But after some times, 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 excel document, now we only needs to modify those VBA macros in the excel template document. It’s no necessary to re-compile the projects now. It’s very convenient.

Maybe you know nothing about Excel VBA macros. It doesn’t matter. You can record VBA macros in Excel application 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 have many classes and can provide you to create reports. You can choose ExcelQuicker based on Office2000 or Office2003. Office2000 is 200 dollars less than Office2003, but your application using ExcelQuicker based on Office2003 in much more stable and safe than Office2000. Whatever your choice, I think you can know they are much cheaper than Crystal Report Solution.

So, my advice is that keep calm when you need to choose report solution. If there is no special requirement, I think it’s no necessary to adopt Crystal. Any more, as an open source and non-commercial software, I advice you choose ExcelQuicker. It can bring you high efficient and performable experience however in development or runtime. (Eunge)

Download Source, sample and documentation of ExcelQuicker

1 komentar:

Anonymous said... 8/15/2008

cool buddy!...
this is the tool ive been lookin for..
thanks for sharing..