Asp.net Excel Interop

[mithun narayanan]

I am using interop for creating excel .. i ve cretaed the excel file. Now i need to hide or delete some of the columns.... Can u plz tell me the code for that... Thanks in Regardss....

[Lost User]

Instead of creating Excel u can create XML and that xml u can open with Excel. and jo will easier to add and delete from Excel Thanks, Amit

[Lost User]

Do some experimentation yourself. Although I am not an expert in Excel Automation, I remember something like Worksheets[0].Columns collection.

[Christian Graus]

How are you using Excel with ASP.NET ?

Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

[mithun narayanan]

Thanks for the Reply..... I have found the solution.... for hiding first column Excel.Range rangen2 = oSheet.get_Range(oSheet.Cells[5, 4]); rangen2.EntireColumn.Hidden = true; :thumbsup:

[mithun narayanan]

Thanks for the Reply..... I have found the solution.... for hiding first column Excel.Range rangen2 = oSheet.get_Range(oSheet.Cells[5, 4]); rangen2.EntireColumn.Hidden = true;

[jonesberyl]

Besides the XML there is a c# excel component Spire.XLS,it can creating Excel .