Tuesday, July 15, 2008 9:27 PMAll,
I've gone through several iterations on this and am convinced that Excel\Interop is simply not doing what it should....
I can open worksheets, select ranges, etc but I cannot Insert data\values (or formulas) into the cell (the cells or worksheet are NOT Protected).
I "Can" insert a comment into the cell and I "Can" get "Replace" to work.....
StartRange.Replace(StartRange.Value2, "Start", m, m, m, m, m, m);
//this does not work (no error....just no result)
StartRange.Text = "Start";
//This does not work
StartRange.FormulaR1C1 = "Foo";
furthermore, I simply CANNOT Insert A row (I need to do this individually and by blocks of rows)
//doesnt work (Again, no error at all, just no result behavior that effects sheet)
//this alos doesnt work.....
(I am Positive that the range and sheet objects are valid here.....)
Gregory A Jackson
- Moved by jack 321 Friday, July 18, 2008 8:14 AM off topic for C# general
Friday, July 18, 2008 8:14 AM
Discussions in office development
Please remember to mark the replies as answers if they help and unmark them if they provide no help.