C#\Excel - opening excel from application and autofit.

[yoavyoavyoav]

Hi,

I'm creating a project in which I create CSV files and then I want them to be displayed to the user in excel automaticlly.

I used :

 
Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.ApplicationClass();
 
excelApp.Visible = true;
 
string path = txtOutputPath.Text; 
 
excelApp.Workbooks.Open(path, 0, false, 2, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);
 
 

this worked - it opened the excel with the csv in it. my question is - how can I alter the active worksheet (there is only one) - I would like to use AutoFit so every column will match the max text length in it. How do I do that ?

Thanks in advance. :-)

[yoavyoavyoav]

Anyone please ? it shouldn't be that complicated