to open Excel with format

[noshaba]

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)

[Bruce Fox]

Is opening an embedded Excel sheet on your Form OK? Or must it be a Grid like ListView/DataGrid?

[noshaba]

its like data grid

[si_the_geek]

How are you actually showing it in the grid? (code)
And what type of grid are you actually using? (datagrid/flexgrid/...)

I assume that you are currently using the "standard" method transfering the text, and ignoring the formatting.. if you want the formatting too, you will need to add the code to re-create it (as they are different).


Bruce Fox's loaded question (using an OLE control) is likely to be the easiest method to get the formatting too, but that may not be appropriate for your needs.. at the moment we dont know what you want to do, (apart from seeing the formatting), so we dont know if you want it editable, etc.