I need to open excel in my application and display it in a grid ... but i have some formatting in that excel but when i open it it simply shows me data no formatiing is there plz help me

Set oXLBook = oXLApp.Workbooks.Open(Trim(cmnDlgs.filename))
Set oXLSheet = oXLBook.Worksheets(1)