Privet vsem.

Ia sozdaiu textovoi file, cotoroi imeet structuru CSV.
I mne nujno evo sohraniti cac Excel is C#.

1-ea protzedura CreateApplication (), zagrujaiet csv file.
i Save, sohraneaiet.

Esli otcrivaiu CSV file v Excel, i daiu ottuda save as (format excel), to rabotoaiet,
a esli is programmi, format ne pravilinii(kak budta, save as ne prohodil, cerez excel, a prosto izmenili extension).


public void CreateApplication(string fileName)
{
eApplication = new Excel.Application();
eWorkbook = eApplication.Workbooks.Add(fileName);
eApplication.SheetsInNewWorkbook = 1;
eWorksheet = (Excel.Worksheet)eWorkbook.ActiveSheet;
}

public void Save(string fileName)
{
object missingValue = Type.Missing;
object oFileName = fileName;
eApplication.DisplayAlerts = false;
object fileFormat = Excel.XlFileFormat.xlExcel2;
eWorkbook.SaveAs(oFileName, fileFormat, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
eWorkbook.SaveAs(oFileName, fileFormat, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

}

Pomogite v cem problema. U menea net sovsem opita v Office Automation, prosto nujno zdelati.

Spasibo.

Спасибо funddd за то подказал про виртуальную клавиатуру.

Я нашёл ответ.

Смотрите на параметры Функций Open() и SaveAs().

public void CreateApplication(string fileName)
{
eApplication = new Excel.Application();
eWorkbook = eApplication.Workbooks.Open(fileName, Type.Missing, Type.Missing, 6, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, ";", Type.Missing, Type.Missing, Type.Missing,Type.Missing, Type.Missing, Type.Missing);

eApplication.SheetsInNewWorkbook = 1;
eWorksheet = (Excel.Worksheet)eWorkbook.ActiveSheet;
}

public void Save(string fileName)
{
object missingValue = Type.Missing;
object oFileName = fileName;
eApplication.DisplayAlerts = false;
object fileFormat = Excel.XlFileFormat.xlExcel9795;

eWorkbook.SaveAs(oFileName, fileFormat, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
}