January 17th, 2013

Saving SkyDrive Excel Survey Data To Sql Server Database with ASP.NET MVC

SkyDrive provides the excel survey feature which allows you to create online surveys and analyze results using the free Excel Web App or Excel on your desktop. You can display the survey results by embedding the excel in a web page. ExcelMashup.com allows you show a workbook directly in your website. It also lets you easily sort, filter, and interact with the workbook as in Web Excel with powerful Javascript API. We will create a sample survey and save result data to database using ASP.NET MVC and Entity Framework.

April 12th, 2011

How to Remove Line Numbers in Excel Column

It explains how you can remove line numbers and get proper data in a excel column. Suppose you have data in following format in A column:
1. First Data
2. Second Data
3. Third Data
4. Fourth Data
5. Fifth Data

You have to remove line numbers and get content in another column. See following screen-shot:

February 18th, 2010

Convert MS Word document or Excel sheet to images (JPEG)

Someone asked me how MS Word document can be converted into JPEG images. It was very interesting practical question because It can’t be done using Save As.. option. One way is to use Print Screen, paste it in paint and remove unnecessary stuff. But, for this, the whole page should come in screen else we need to merge two screenshots. It is too complex process. On googling, I found there is no direct way to do this. There are 3rd party tools. but, I want to do this in easy steps. At last, I got solution using Microsoft Office OneNote.

February 11th, 2010

Selection tips for MS Word

This article explains the selection tips to simplify the common tasks in MSWord.

1. Select multiple areas that aren’t next to each other: Generally, it is required to copy multiple portions of document. It is not convenient to copy one by one and paste it. We can do it in single attempt.