How to access the Excel Worksheet Color

[GlorryHob]

I can access the text/ values present in the worksheet cell successfully, but i'm not able to access their properties as BOLD,their Color etc.This is the code to access the worksheets..::\[code\] Excel.Application xlApp = new Excel.Application(); Excel.Workbook xlWorkBook = xlApp.Workbooks.Open(sourcefile, Missing.Value); Excel.Worksheet xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Sheets[1]; System.Data.DataTable dt = new System.Data.DataTable("dtExcel"); DataSet ds = new DataSet(); ds.Tables.Add(dt); DataRow dr; int jValue = http://stackoverflow.com/questions/13859429/xlWorkSheet.UsedRange.Columns.Count; int iValue = xlWorkSheet.UsedRange.Rows.Count; // get data columns for (int j = 1; j <= jValue; j++) { dt.Columns.Add(); } // get data in cell for (int i = 1; (i <= iValue); i++) { dr = ds.Tables["dtExcel"].NewRow(); for (int j = 1; j <= jValue-1; j++) {Excel.Range oRng = (Microsoft.Office.Interop.Excel.Range)xlWorkSheet.Cells[i, j]; string strValue = http://stackoverflow.com/questions/13859429/oRng.Text.ToString(); dr[j] = strValue; } ds.Tables["dtExcel"].Rows.Add(dr); } xlWorkBook.Close(true, misValue, misValue); xlApp.Quit();\[/code\]I'm using DataSet to access the rows, so i'm getting only the values...So, What should i be able to do to get the the font properties as Well...????thanks