How do I get filepath and label of oledb object placed in excel using C sharp?

See more:

C#

XML

MS-Excel

OleDb

, +

Hello guys,

This is my first time in the site, so possibly i am unsure how to ask questions. Still here it is -

I have an excel file containing xml files in oledb object form.

What i need is, how can i get the label and file path of that xml file stored in oledb using C#.

Note: OE1.name is not getting me the right thing.

What I have tried:

private void button2_Click(object sender, EventArgs e)
       {

           xlapp = new Excel.Application();
           xlwb = xlapp.Workbooks.Open("C:\\Users\\Vijay\\Documents\\File1.xlsm");
           xlws = xlwb.Worksheets["Sheet1"];



           foreach (Excel.OLEObject OE1 in xlws.OLEObjects())
           {

            MessageBox.Show(Convert.ToString(OE1.Name));

           }

           xlwb.Close();
           xlapp.Quit();

       }