null в excel

Ответ от Modern Иванов[гуру]
Примерно так. Имена ф-ций олжны быть понятны.
//класс для работы с Excel
public class MyExcel
{
public const string UID = "Excel.Application";
public object oExcel = null;
public object WorkBooks, WorkBook, WorkSheets, WorkSheet, Range, Interior;
public MyExcel()
{
oExcel = Activator.CreateInstance(Type.GetTypeFromProgID(UID));
//oExcel.GetType().InvokeMember("Visible", BindingFlags.SetProperty,null, oExcel, new object[] { true });
}
public void NewDocument(string name)
{
WorkBooks = oExcel.GetType().InvokeMember("Workbooks", BindingFlags.GetProperty, null, oExcel, null);
WorkBook = WorkBooks.GetType().InvokeMember("Add", BindingFlags.InvokeMethod, null, WorkBooks, null);
WorkSheets = WorkBook.GetType().InvokeMember("Worksheets", BindingFlags.GetProperty, null, WorkBook, null);
WorkSheet = WorkSheets.GetType().InvokeMember("Item", BindingFlags.GetProperty, null, WorkSheets, new object[] { 1 });
}
public void SaveDocument(string name)
{
if (!File.Exists(name))
WorkBook.GetType().InvokeMember("SaveAs", BindingFlags.InvokeMethod, null, WorkBook, new object[] { name});
else
MessageBox.Show("таблица с таким именем уже существует. ");
WorkBook.GetType().InvokeMember("Close", BindingFlags.InvokeMethod, null, WorkBook, new object[] { false });
oExcel.GetType().InvokeMember("Quit", BindingFlags.InvokeMethod, null, oExcel, null);
}
public void SetCell(string range, string value)
{
Range = WorkSheet.GetType().InvokeMember("Range", BindingFlags.GetProperty, null, WorkSheet, new object[]{range});
Range.GetType().InvokeMember("Value", BindingFlags.SetProperty, null, Range, new object[]{value});
}
}
Далее в коде используем так
MyExcel excel = new MyExcel();
excel.NewDocument(saveFileDialog1.FileName);//используем диалоговое окно
excel.SetCell("A1", value1);
excel.SetCell("B2", value2);
excel.SetCell("C3", value3);