Hi All, First of all I would like to thank you for the support. I am new in coding and need assistance in getting a specific xml content to an excel spreadsheet or to a datagridview. the XML file is not a standard one (i think and belo ...

Hi All, I've got some problems with placing formulas in a cell in excel using C#; I'm trying to add a CONCATENATE(B1;C1) to cell A1. When I do not Numberformat the cell to text I get an error message, but when i do numberformat the c ...

I'm looking for a way to hatch cells in excel using c#. I was searching the internet but the only thing I came across was by using some paid extension. While hatching cells from within excel itself is a basic feature this should also be pos ...

how to select the whole excel sheet using c# to apply some styles or formatting to the sheet. Thanks in advance

Hi, I am trying to connect to excel 12.0 from c# 4.0. I use the following code. [code] string excelConnection = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + txtFile.Text + "; Extended Properties= ...

Hi I have a loop that verifies if 4000 Excel cells are each locked or not using the folowing method. But it takes much time!!! about 12 seconds!!! if ((rangeuse.Cells[j, i] as Excel.Range).Locked.ToString() == "False") { ...

Hi, Here's the situation: I try to access 4000 Excel worksheet cells that I need to modify using the folowing code but it takes more than 15 seconds: Excel.Range NewCell = (Excel.Range)newWorkSheet.Cells[row_index, column_index]; ...

Vous ne pouvez pas voter pour votre propre billet. 0 Hi, Here's the situation: I try to modify my Excel file using values and formulas that I pick up from an XML file. So first I have to access cells that I need to modify with th ...

I want to add first two columns of excel file into hashtable.. I wrote following code but it is giving me eror saying indexing not allowed in datacolumn... [CODE] Hashtable ExcelSheets = new Hashtable(); System.Data.DataColumn dc; ...

How do I import an Excel Spreadsheet into C# as an array in a way that can be ported to both PC and mac. Using the GTK# Library?

How can I import an excel spreadsheet like in this tutorial (http://www.davidhayden.com/blog/dave/archive/2006/05/26/2973.aspx) into a C# Array. Thanks, Theo

Hi guys. I am hoping someone would be able to help me with this project I am working on. I have an excel file that my vb project reads and writes to. The text from textbox1.text is stored to this excel file in cell(1,1). 1) How can I ...

Hi guys. Been a while since I have asked anything here and the same amount of time since I worked with VB2008. I have decided to make a program for my uncle and then try to sell it to a larger company if it works the way I think it can. ...

Hello, i am working with vs2008 (web application) and I want to copy some content from an excel sheet and and using the clipboard i want to copy the contents in a gridview I have tried using Clipboard.GetDataObject() but no matter what ...

I just tried using Office Interop Excel = Microsoft.Office.Interop.Excel; I'm looking out for a way with which I can make a particular worksheet (as Active worksheet) in the Excel workbook. Something like this:[code]if (checkBox1 ...