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

Display MS Excel Sheets and Charts in ASPX Pages using C#

, 8 Nov 2006
Rate this:
Please Sign up or sign in to vote.
How to display an Excel sheet with its format and also charts in an ASPX page.


The purpose of this article is to show how to display the exact values in an Excel sheet, with its comments, in an aspx page. The code-behind file is in C#. The method shown here helps to display an Excel sheet with its formatting including the font, color, alignment etc. This will be very useful for developers who do MS Office automation. The pre-requisites are that in the DCOM CONFIG your Excel application should be given permissions to be accessed and loaded in the server system.

Sample Image - ExcelShtAndChrt-In-aspx.jpg

Conversion of the Excel formats require only a few lines of code. The format details include conversion of Excel attributes to .NET attributes, like Excel color to .NET Color.

/// <span class="code-SummaryComment"><SUMMARY>
/// Converts Excel Color to Dot Net Color
/// <span class="code-SummaryComment"></SUMMARY>
/// Excel Object Color
/// <span class="code-SummaryComment"><RETURNS>Returns System.Drawing.Color</RETURNS>
private System.Drawing.Color 
        ConvertExcelColor2DotNetColor(object objExcelColor)

    string strColor = "";
    uint uColor = 0;
    int nRed = 0;
    int nGreen = 0;
    int nBlue = 0;

    strColor = objExcelColor.ToString();
    uColor = checked((uint)Convert.ToUInt32(strColor));
    strColor = String.Format("{0:x2}", uColor);
    strColor = "000000" + strColor;
    strColor = strColor.Substring((strColor.Length - 6), 6);

    uColor = 0;
    uColor = Convert.ToUInt32(strColor.Substring(4, 2), 16);
    nRed = (int)uColor;

    uColor = 0;
    uColor = Convert.ToUInt32(strColor.Substring(2, 2), 16);
    nGreen = (int)uColor;

    uColor = 0;
    uColor = Convert.ToUInt32(strColor.Substring(0, 2), 16);
    nBlue = (int)uColor;

    return System.Drawing.Color.FromArgb(nRed, nGreen, nBlue);

The format details also include conversion of Excel horizontal alignment to .NET horizontal alignment:

/// <span class="code-SummaryComment"><SUMMARY>
/// Converts Excel Horizontal Alignment to DotNet Horizontal Alignment
/// <span class="code-SummaryComment"></SUMMARY>
/// Excel Horizontal Alignment
/// <span class="code-SummaryComment"><RETURNS>HorizontalAlign</RETURNS>
private HorizontalAlign ExcelHAlign2DotNetHAlign(object objExcelAlign)
    switch (((Excel.Range)objExcelAlign).HorizontalAlignment.ToString())
        case "-4131":
            return HorizontalAlign.Left;
        case "-4108":
            return HorizontalAlign.Center;
        case "-4152":
            return HorizontalAlign.Right;
            return HorizontalAlign.Left;

Next is the conversion of Excel vertical alignment to .NET vertical alignment:

/// <span class="code-SummaryComment"><SUMMARY>
/// Converts Excel Vertical Alignment to DotNet Vertical Alignment
/// <span class="code-SummaryComment"></SUMMARY>
/// Excel Vertical Alignment
/// <span class="code-SummaryComment"><RETURNS>VerticalAlign</RETURNS>
private VerticalAlign ExcelVAlign2DotNetVAlign(object objExcelAlign)
    switch (((Excel.Range)objExcelAlign).VerticalAlignment.ToString())
        case "-4160":
            return VerticalAlign.Top;
        case "-4108":
            return VerticalAlign.Middle;
        case "-4107":
            return VerticalAlign.Bottom;
            return VerticalAlign.Bottom;


Chart View

Sample Image - ExcelShtAndChrt-In-aspx.jpg

The selection of sheet name will be displayed by "*" delimited. This is because "*" cannot be accepted in Worksheet names.

Problems faced in displaying a Worksheet

  1. Merging of rows is not included because it needs to find out the logic of combining rows (whereas columns merge is possible on insertion as a TableRow).
  2. The chart object is a GIF file, it is generated and put in the server and displayed in an ASPX page. (Here, there is no need to get the chart object inside the page). This is a preliminary trial to put a chart on an ASPX page.

Forthcoming Plans

To display all types of MS Office files in ASPX pages and to produce intelligence on data values etc.

Points to Consider

This meets the business requirements with data display alone and no activities processed. A template of Excel with cell references to other Excel files will give a real time stylesheet data report.


This page will be enhanced by including several functionalities of MS Excel.


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


About the Author

Gnanandam Gopalan
Web Developer
India India
I am basically a C++ Programer done various project for Industrial Automation Activities.

Comments and Discussions

Questionhey bro reaply me fast i need solution of this error... Pinmemberntc994-Nov-14 22:04 
GeneralMy vote of 5 PinmemberAsif Iqbal A.Khan5-Aug-13 2:35 
QuestionProblem occured !!!!!!! Pinmemberzimzamzim20-Sep-11 2:04 
after selecting the List button following error occurs
System.Runtime.InteropServices.COMException (0x800A03EC): 'PopulationSample.xls' could not be found. Check the spelling of the file name, and verify that the file location is correct. If you are trying to open the file from your list of most recently used files, make sure that the file has not been renamed, moved, or deleted. at Excel.Workbooks.Open(String Filename, Object UpdateLinks, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru, Object Local, Object CorruptLoad) at ExcelSheetDisplay.GetListofSheetsAndCharts(String strFileName, Boolean bReadOnly, DropDownList drpList) in c:\Users\sivanesan\Desktop\New folder\ExcelSheetChartDisplay\ExcelSheetDisplay.aspx.cs:line 131
Please suggest me a right solution ..
Note: i have tried permission concept but not acceptingConfused | :confused:

AnswerRe: Problem occured !!!!!!! Pinmembermatrixology27-Nov-11 19:14 
GeneralNo display for image PinmemberMember 778553224-May-11 5:51 
GeneralOld format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD)) PinmemberNuclearStorm16-Feb-11 5:26 
GeneralImage in excel is not Displaying Pinmemberam7429-Mar-10 22:36 
GeneralProblem in Displaying Excel PinmemberPallaviwakde5-Feb-10 1:06 
GeneralRe: Problem in Displaying Excel Pinmembersnpcrud20-Dec-10 10:44 
GeneralRe: Problem in Displaying Excel Pinmembersnpcrud20-Dec-10 11:11 
GeneralRe: Problem in Displaying Excel Pinmembermatrixology27-Nov-11 19:25 
GeneralRe: Problem in Displaying Excel Pinmembersnpcrud28-Nov-11 10:59 
GeneralRe: Problem in Displaying Excel Pinmembermatrixology28-Nov-11 18:04 
GeneralNeed same code for VB.Net PinmemberAnOnYmOuS_S24-Nov-09 3:18 
GeneralCool application PinmemberLulama8-Mar-09 22:55 
GeneralNice Application Pinmemberatheequepasha12-Nov-08 19:14 
Generaltemp gif file PinmemberMember 391781022-Sep-08 6:24 
GeneralLoading takes a long time PinmemberAgnes Loyola16-Jul-08 4:29 
GeneralDisplay Excel inside the aspx page PinmemberAgnes Loyola11-Jul-08 21:56 
GeneralTo display excel sheet PinmemberAgnes Loyola11-Jul-08 2:24 
AnswerRe: To display excel sheet PinmemberGnanandam Gopalan11-Jul-08 3:46 
GeneralRe: To display excel sheet PinmemberAgnes Loyola11-Jul-08 4:06 
Questionhow to load the Excel sheet in the page load PinmemberAgnes Loyola10-Jul-08 2:05 
AnswerRe: how to load the Excel sheet in the page load PinmemberGnanandam Gopalan10-Jul-08 2:14 
GeneralThanks for nice Example, But I am getting one errors [modified] PinmemberMember 204885626-Feb-08 21:50 
GeneralNice PinmemberPooya Musavi19-Oct-07 9:00 
GeneralRe: Nice PinmemberGnanandam Gopalan22-Oct-07 0:11 
QuestionVB Version Pinmembersmcirish17-Oct-07 5:19 
GeneralProblem in Horizontal Alignment. PinmemberAnees Mhd25-Sep-07 2:13 
GeneralRe: Problem in Horizontal Alignment. PinmemberAnees Mhd25-Sep-07 18:48 
GeneralYour Application is greate but ... Pinmemberhishammm17-May-07 3:57 
GeneralRe: Your Application is greate but ... PinmemberGnanandam Gopalan21-May-07 0:15 
GeneralRe: Your Application is greate but ... Pinmembershahzad_mca11-Oct-07 7:20 
QuestionExcel process not closed Pinmembersandu200415-Nov-06 21:36 
AnswerRe: Excel process not closed PinmemberGnanandam Gopalan17-Nov-06 4:28 
GeneralRe: Excel process not closed Pinmembersandu200417-Nov-06 6:00 
GeneralRe: Excel process not closed PinmemberGnanandam Gopalan19-Nov-06 21:04 
GeneralProblem open the Excel Sheet PinmemberJ@vi Martinez9-Nov-06 6:32 
AnswerRe: Problem open the Excel Sheet PinmemberGnanandam Gopalan9-Nov-06 19:21 
GeneralRe: Problem open the Excel Sheet PinmemberJ@vi Martinez9-Nov-06 21:10 
GeneralRe: Problem open the Excel Sheet PinmemberJ@vi Martinez14-Nov-06 1:43 

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
Web03 | 2.8.150224.1 | Last Updated 9 Nov 2006
Article Copyright 2006 by Gnanandam Gopalan
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid