Доступ к объекту созданному в другом методе - C#
Формулировка задачи:
class Program
{
static void Main(string[] args)
{
Program.ImExcel("C:/1.xls");
Console.WriteLine(DtSet.Tables[0].Rows[0]["F1"].ToString());
Console.ReadKey();
}
public static void ImExcel(string nfile)
{
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(nfile);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
string sheet = xlApp.ActiveSheet.Name;
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();
System.Data.OleDb.OleDbConnection MyConnection;
System.Data.DataSet DtSet;
System.Data.OleDb.OleDbDataAdapter MyCommand;
MyConnection = new System.Data.OleDb.OleDbConnection(string.Format(@"provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};
Extended Properties=Excel 8.0;", nfile));
MyCommand = new System.Data.OleDb.OleDbDataAdapter(string.Format("select * from [{0}$]", sheet), MyConnection);
DtSet = new System.Data.DataSet();
MyCommand.Fill(DtSet);Решение задачи: «Доступ к объекту созданному в другом методе»
textual
Листинг программы
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open("filename");
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
string sheet = xlApp.ActiveSheet.Name;
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();
System.Data.OleDb.OleDbConnection MyConnection;
System.Data.DataSet DtSet;
System.Data.OleDb.OleDbDataAdapter MyCommand;
MyConnection = new System.Data.OleDb.OleDbConnection(string.Format(@"provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};
Extended Properties=Excel 8.0;", "filename"));
MyCommand = new System.Data.OleDb.OleDbDataAdapter(string.Format("select * from [{0}$]", sheet), MyConnection);
DtSet = new System.Data.DataSet();
MyCommand.Fill(DtSet);