.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Displaying formatting of an Excel sheet in a datagridview within a C# application

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :Windows Application

I've successfully used the Excel COM objects in C# to extract the contents of the sheets. I then use this information in a datagridview.

Rather than just cycle through each cell for the values to build up what needs to be displayed however I used the Worksheet.UsedRange.get_value() method instead which returns a 2D array of objects containing the string values of the cells.

I've done this since going through each cell individually appears to slow things down considerably, especially when larger Excel files are being opened. I would like to also apply as much of the formatting as possible from the file too, however there doesn't appear to be a clear way to extract formatting information in a similar way to get_value. I could go back to cycling through the cells, but this would probably incur an unacceptable loss in speed as a result.

Does anybody know how to retrieve formatting information using a way that's similar in terms of output to the way that get_value works?

View Complete Post

More Related Resource Links

How to export from DatagridView to Excel Sheet in C# Windows Forms



I am developing an application that loads a spreasheet to a datagrid, i then add a column (with data) dynamically in the datagrid. How can I take the data in the whole datagrid and display it in a new spreadsheet. Please help!

display data into GridView from excel sheet

I have to display data from excel sheet into my gridview and also I need to figure out a way to store data into excel files from my web page. I am using C# 3.5, VS 2008.

Read Excel file from Web Application (C#)



I have a web app where user uploads a file.

File is saved in server locally and I want to read some data from it.

Currently my development  server has office 2003.

So do I need office 2007 in order to be able to  read an excel from office 2007 ?

What are other requirements  ?

I tried a test, using

Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook wrkBook; // = new Microsoft.Office.Interop.Excel.Workbook();

wrkBook = excelApp.Workbooks.Open(@"C:\www\excel_files\b.xls", ....);

But When trying to open the file I get the error:

Exception from HRESULT: 0x800A03EC

So I'm wondering what I'm missing.


delete record from excel sheet



           I have write the code for deleting the data in excel sheet. but we have got the error" Deleting data in a linked table is not supported by this ISAM."

     below I paste some code snippest.

string strDelete = "Delete  from [" + strSheetName + "$]";

            cmdExcel.Connection = con;
            cmdExcel.CommandType = CommandType.Text;
            cmdExcel.CommandText = strDelete;


Please can anybody this answer.It is urgent

delete data in excel sheet



           I have write the code for deleting the data in excel sheet. but we have got the error" Deleting data in a linked table is not supported by this ISAM."

     below I paste some code snippest.

string strDelete = "Delete  from [" + strSheetName + "$]";

            cmdExcel.Connection = con;
            cmdExcel.CommandType = CommandType.Text;
            cmdExcel.CommandText = strDelete;


Please can anybody this answer.It is urgent

How to read value of CheckBox in EXCEL sheet


I am using OLEDBConnection (@"Provider=Microsoft.ACE.OLEDB.12.0;") to connect to the EXCEL file and read contents. When I read the contents, I get all the contents from the excel sheet but i dont get contents for checkboxes placed inside.

My Excel sheet contains set of checkboxes and I need to know If they are checked or not.These checkboxes are controls which are added from Developer tab in EXCEL.

I dont want to use Excel Assemblies for reading contents as it is not recommended. And also i am using OLEDBconnection and want to stick to this .

Awaiting replies from you guys. Thanks in Advance.

Export Gridview data to Excel sheet


Hi ,

     I have a requirement where i need to export the gridview data to excel.My code export the data in excel that was fine.

But the enchancement needed now , I was exporting the 3 gridview in same excel sheet under the workbook.

Now i need to export the 3 grid view in 3 different sheet in the same workbook.

so can please tell or share the updated code in my below code ...

public void writeovrsummary()


        Response.Write("Overall Summary");
        //Response.Write("Report as of " + DateTime.Now.ToString("hh:mm ss tt"));

        StringWriter sw = new StringWriter();
        HtmlTextWriter hw = new HtmlTextWriter(sw);

        SqlCommand com = MyConnection.CreateCommand();
        com.CommandText = "useroverall_Report";
        SqlParameter[] par = new SqlParameter[1];
        par[0] = new

Export Dataset to excel sheet in a required format?



I know how to export a grid view to excel.

But here i have a Dataset which consists of data like below and also it need to display in a required format like below.

pno psubno pstate pdetailid pdetails

 12    1          CA         1           cbsdjcbdjc     

12     1          CA          2        cndcnjdcjcj

12     2           VA         4          xcndwkfcgygry

13     1            AL        1           ncdcnjdcndj

My excel sheet  should like this.

pid       pstate     

 12/1      CA             &nb

Mulitiple Connections to Excel Sheet


I have a spreadsheet that I want to link to Sharepoint as a list.  I want to use Sharepoint to make updates to the spreadsheet as well as for lookups in other lists.

My problem is that the spreadsheet already has a data connection to a SQL database.  The spreadsheet doesn't update the DB directly but the DB connection is used to keep the spreadsheet updated with new data edited directly in the DB.  I don't own the DB or the spreadsheet so cannot convince them to do their editing another way (directly from the info in the spreadsheet for example) so ...I HAVE to keep the existing connection to the DB. 

My question is...is it possible to keep the connection to the DB AND link to Sharepoint?

OR..is there another solution? 

Sheet Master in Excel vs Slide Masters in PowerPoint


Is it possible to create a Sheet Master in Excel as we create Slide Masters in PowerPoint?

For example, I'd like to insert a picture in several sheets and i couldn't find a better way than copying/pasting the pic in each sheet.



Sending 'ctrl-c' to the datagridview row of an external application using win32 api. Please help.

I'm just not able to send ctrl-c using my C# application to an external WinForm application. Here is my sequence of commands. I compared the messages using Spy++, and it matches except for my SendMessages are showing up as Send and Receive, vs. the same operation done on the WinForm is showing up as posted. My command sequence : NativeMethods.SendMessage(hwnd, WM_KEYDOWN, 0x00000011, 0x001D0001); NativeMethods.SendMessage(hwnd, WM_KEYDOWN, 0x00000043, 0x002E0001); NativeMethods.SendMessage(hwnd, WM_CHAR, 0x00000003, 0x002E0001); NativeMethods.SendMessage(hwnd, WM_KEYUP, 0x00000043, 0xC02E0001); NativeMethods.SendMessage(hwnd, WM_KEYUP, 0x00000011, 0xC01D0001); My Spy++ sequence : <00001> 0059043C S WM_LBUTTONDOWN fwKeys:MK_LBUTTON xPos:299 yPos:52 [wParam:00000001 lParam:0034012B] <00002> 0059043C R WM_LBUTTONDOWN <00003> 0059043C S WM_LBUTTONUP fwKeys:MK_LBUTTON xPos:299 yPos:52 [wParam:00000001 lParam:0034012B] <00004> 0059043C R WM_LBUTTONUP <00005> 0059043C S WM_KEYDOWN nVirtKey:VK_CONTROL cRepeat:1 ScanCode:1D fExtended:0 fAltDown:0 fRepeat:0 fUp:0 [wParam:00000011 lParam:001D0001] <00006> 0059043C R WM_KEYDOWN <00007> 0059043C S WM_KEYDOWN nVirtKey:'C' cRepeat:1 ScanCode:2E fExtended:0 fAltDown:0 fRepeat:0 fUp:0 [wParam:00000043 lParam:002E0001] <00008> 0059043C R WM_KEYDOWN <00009> 00590

In export, i want to disable column in excel sheet

Hello, I am doing Import/Export. While export i want to disable some column in excel sheet, so during upload or import same primary key I can use, instead of user modify such column. Regards, Sandeep    

Displaying PDF in Silverlight Application

Hi I am going to show the pdf file in my silver light application, now i am trying to display the pdf in a iframe inside div container, and then displaying that grid with the use of the javascript. is there any solution to show the pdf file with in the silver light application   Thanks in advance. Gagandeep Singh

Excel sheet is not saving data while sending email

Hey Guys,  I am creating a SSIS package, where I am getting all the data into the excelsheet1, which is not formatted. So i created a formated excelsheet2, where i am giving reference to excelsheet1 cells reference. And I am sending email by attaching excelsheet2.              I am having issue when the data is updated, but my email attachment excel is showing old data. When i open the excelsheet1 it is being updated. I don't know why excelsheet2 is not updated automatically. I am using BIDS 2005 . Can anyone please suggest what will solve my problem. Thanks in Advance Priyamvadha

Read Excel sheet by Sheet Name using office interop

Hi,I am using office interop to read Excel sheet.I want to read the contents of the sheet  using the name of the sheet.For example I want to read the contents of the sheet- "ABC" (if ABC exists).Thanks

Displaying XML in label control using xslt formatting

I am using an XML file as a database and I am using a text box and a button to search for a node within the xml file and display that node on a label control using the format required by the xslt file.  I have created an example to use as the real file is rather big. If I add an xml control to the page and set the documentSource and transformSource to my existing files, it will display the node on the page in the correct format.  If I try and pass the query to the label, it only shows the inner text of the XML tags with no spaces and no formatting as specified in the xslt file. Is there a way to pass the query to a label control and render it using the formatting specified in the xslt file?  In all honesty, it doesn't even have to be a label if I can get the query to render as specified in the xslt file in any way shape or form, I would be happy with that.I feel like I am just one statement away from having it complete but for the life of me can't seem to figure out what it is.  Any help is apprecaited.XML File:<?xml version="1.0" encoding="utf-8" ?><?xml-stylesheet type="text/xsl" href="animal.xslt"?><animals>    <animal name="dog">        <color>brown</color>        <hair>lo
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend