Generally we come across following issues when generating office documents at server :
1.Creating and Reading MS Office XPS (.XLSX, DOCX) file formats by using Interop libraries at server end requires MS office client installed on server.
2.When creates office documents which will invoke corresponding executable process(winword.exe,excel.exe) for every request and executable process hangs on server memory until garbage collected properly.
3.Response time of our request to create files will take long time if more requests made at a time.
The best way to overcome these problems (mentioned in Problem Statement) is using Office Open XML Standards to generate MS office files at server. Microsoft .NET Framework provides set of classes and wrappers around the System.IO.Packaging namespace which is in WindowsBase.dll to process the new Office Open XML file format. It extracts away the complexity of dealing with the individual XML components making it real easy to create sophisticated spreadsheets and documents on the server.
There are so many .NET helper libraries are available to generate Office files at server :
• DocX (http://docx.codeplex.com/)
• ExcelPackage (http://excelpackage.codeplex.com/)
• EPPlus (http://epplus.codeplex.com/)
• Simple OOXML (http://simpleooxml.codeplex.com/)
Among them we are using “EPPlus” which supports setting values and formulas, cell styling, auto filters, add drawings (charts, shapes and pictures) and more in excel (XLSX) format.
Office OpenXML Standards
General Benedict Alphonse Tuesday, April 27, 2010 0 comments
Cheatsheets - Every WebDeveloper Mush Have
JavaScript
Addison-Wesley’s JavaScript Reference Card
JavaScript and Browser Objects Quick Reference
CSS
Design 215 CSS Quick Reference
HTML/XHTML
HTML Character Entities Cheat Sheet
Character Entity References in HTML 4 and XHTML 1.0
AJAX
Scriptaculous Combination Effects Cheat Sheet
ASP.net AJAX Client Life-Cycle Events
Colors
Microformats
Microformats Helper Cheat Sheet
Jack Daniel’s Microformats Cheat Sheet
Browser Compatibility
Browser Compatibility Interactive Table
XML
XML TopicMaps 1.0 - Quick Reference Card
XML Schema - Structures Quick Reference
XML Schema - Data Types Quick Reference
PHP
Jack Daniel’s PHP Cheat Sheet (HTML)
Interactive PHP Cheat Sheet (HTML)
Blue Shoes Developer - PHP Cheat Sheet (HTML)
PHP Cheat Sheet (HTML)
PHP Cheat Sheet (HTML)
Regular Expressions Reference Sheet (HTML)
Tiger PHP Cheat Sheet (PDF)
PHP 4 Reference Card (PDF)
PHP Templates Cheat Sheet (PDF)
Ruby
Ruby Cheat Sheet (PDF)
Jack Daniel’s Ruby on Rails Cheat Sheet (HTML)
Textmate Rails Cheat Sheet (PDF)
Zen Spider Ruby Quick Reference (HTML)
Rails Reference 1.1 (PDF)
Rails Active Resource Cheat Sheet (PDF)
ActiveRecord Relationships (PDF)
Rails Strings Cheat Sheet (PDF)
What Goes Where Cheat Sheet (PDF)
Ruby on Rails Cheat Sheet (PDF)
Ruby on Rails Form Helpers (PDF)
Perl
Perl Quick Reference (PDF)
Perl Cheat Sheet (HTML)
Perl 5 Cheat Sheet (HTML)
Perl Testing Reference Card (PDF)
Perl Quick Reference Card (PDF)
ASP.net
ASP.net Page Lifecycle Diagram (PNG)
.NET Format String Quick Reference (PDF)
ASP.NET 2.0 Page Life Cycle & Common Events (PDF)
Visual Studio 2005 Built-in Code Snippets (C#) (PDF)
Visual Studio 2005 Default Keybindings C# (PDF)
Visual Studio 2005 Default Keybindings VB.net (PDF)
ASP.NET AJAX Client Life Cycle & Events (PDF)
VB.net and C# Comparison (PDF) (Word)
Casting in VB.net and C# (HTML)
ASP.net Basics (PDF)
Python
Python 2.4 Cheat Sheet (HTML)
Python 2.2 Quick Reference (HTML)
Python Cheat Sheet (HTML)
Python 101 Cheat Sheet (HTML)
Python PHP Cheat Sheet (PDF)
Python Quick Reference (PDF)
ColdFusion
ColdFusion Reference Sheet (PDF)
ColdFusion Cheat Sheet (HTML)
ColdFusion Quick Reference (HTML)
Java / JavaServer Pages
JavaServer Pages Syntax (PDF)
JSP 2.0 XML Cheat Sheet (HTML)
Java Cheat Sheet : Java Glossary (HTML)
Java Reference Sheet (PDF)
MySQL
Jack Daniel’s MySQL Cheat Sheet (PDF) (PNG)
MySQL Reference Card (PDF)
Neal Parikh MySQL Cheat Sheet (HTML)
MySQL Reference Sheet (PDF)
Handy Cheat-Sheet of MySQL Commands (HTML)
MySQL Commands (HTML)
SQL Injection Cheat Sheet (HTML)
SQL Server
Jack Daniel’s SQL Server Cheat Sheet (PDF) (PNG)
A to Z SQL Server 2005 (HTML)
SQL Injection Cheat Sheet (HTML)
General Benedict Alphonse Sunday, May 31, 2009 0 comments
Microsoft's New Decision (Search) Engine - Bing
Microsoft Corp. unveiled Bing, a new Decision Engine and consumer brand, providing customers with a first step in moving beyond search to help make faster, more informed decisions. Bing is specifically designed to build on the benefits of today’s search engines but begins to move beyond this experience with a new approach to user experience and intuitive tools to help customers make better decisions, focusing initially on four key vertical areas: making a purchase decision, planning a trip, researching a health condition or finding a local business.
The result of this new approach is an important beginning for a new and more powerful kind of search service, which Microsoft is calling a Decision Engine, designed to empower people to gain insight and knowledge from the Web, moving more quickly to important decisions. The new service, located at http://www.Bing.com, will begin to roll out over the coming days and will be fully deployed worldwide on Wednesday, June 3.
The explosive growth of online content has continued unabated, and Bing was developed as a tool to help people more easily navigate through the information overload that has come to characterize many of today’s search experiences. Results from a custom comScore Inc. study across core search engines show that as many as 30 percent of searches are abandoned without a satisfactory result. The data also showed that approximately two-thirds of the remaining searches required a refinement or requery on the search results page.
“Today, search engines do a decent job of helping people navigate the Web and find information, but they don’t do a very good job of enabling people to use the information they find,” said Steve Ballmer, Microsoft CEO. “When we set out to build Bing, we grounded ourselves in a deep understanding of how people really want to use the Web. Bing is an important first step forward in our long-term effort to deliver innovations in search that enable people to find information quickly and use the information they’ve found to accomplish tasks and make smart decisions.”
More Details : http://www.microsoft.com/presspass/press/2009/may09/05-28NewSearchPR.mspx
General Benedict Alphonse Friday, May 29, 2009 0 comments
Posts
