Unlocking a column in excel using C#
I have the Microsoft .Office.Interop.Excel installed but my question is
I want to unlock a column H. I do have data to reach H1..H500 but it could be less rows.
I want to unlock only until the last row with data. It should not affect more than the last row with data.
whats the code?
I want to unlock a column H. I do have data to reach H1..H500 but it could be less rows.
I want to unlock only until the last row with data. It should not affect more than the last row with data.
whats the code?
Senior .Net Developer
CERTIFIED EXPERT
try the following:
Excel.Range all = app.get_Range("H:H", Type.Missing);
all.Locked = false;
I want to put gridlines in the column. Right now column is solid white with no gridlines. like the column look normal .
what is the code to do that in addition to above. THANKS!!!
what is the code to do that in addition to above. THANKS!!!
Hi,
pls try
Regards
pls try
xlRange = (Excel.Range)xlWorkSheet.get_Range(xlWorkSheet.Cells[1, 8] as Excel.Range, (xlWorkSheet.Cells[xlWorkSheet.Cells.Rows.Count, 8] as Excel.Range).get_End(Excel.XlDirection.xlUp));
xlRange.Locked = false;
xlRange.Cells.Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuou
Regards
Can Usedrange substitute on this or not? Does usedrange cover only to the last row of data or till the 65,000+
Last row?
Last row?
then try
Excel.Range xlRange= (Excel.Range) xlWorkSheet.Cells[1, 8];
xlRange.Interior.Color = Excel.XlRgbColor.rgbYellow;
then try
Excel.Range xlRange= (Excel.Range) xlWorkSheet.Cells[1, 10];
xlRange.Interior.Color = Excel.XlRgbColor.rgbYellow
Excel.Range xlRange= (Excel.Range) xlWorkSheet.Cells[1, 10];
xlRange.Interior.Color = Excel.XlRgbColor.rgbYellow
It's not changing the color. Originally it was yellow on J1. Can the formatting start on J2 ..down instead because J1 is a header with background yellow?
this code:
range = xlsWorkSheet.UsedRange.Col
Maybe this is easier to understand for me.
range = xlsWorkSheet.UsedRange.Col
Maybe this is easier to understand for me.
range = xlsWorkSheet.UsedRange.Columns[10, Type.Missing].Resize(xlsWorkSheet.UsedRange.Rows -1 , 1).Offset(1);