to load special records from worksheet in main memory: C#

Hello

Thank you very much

I wrote this code and all things are ok:

        private void button4_Click(object sender, EventArgs e)
        {
            var fileName = Application.StartupPath + @"\Book1.xlsx";
            var connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}; Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";", fileName);
            OleDbConnection conn = new OleDbConnection(connectionString);
            conn.Open();
            var adapter = new OleDbDataAdapter(@"SELECT * FROM [Sheet1$"+ "A1:B100]", conn);
            var ds = new DataSet();
            adapter.Fill(ds,"range");
            ds.WriteXml(Application.StartupPath + @"\sample.xml");
            conn.Close();
        }