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 ...

Guys, is possible to format the back colour of a datagridview cell based on a string value, example: my "Datagridview1" has "Description1" & Description2", "Color1" & "Color2" columns, no ...

Is it possible to insert text into multiple rows in one go with a button click? Example: my datagrid "salesDataGridView" has a column called "Payment" or it's number would be[4] lets say it had 10 rows in the datagrid ...