Dear All, i had use Microsoft.Office.Interop.Excel method in C# to query a data in excel file. Based on below code, may i know how to set Other font style in oSheet.Cells4, 3 = QueryDB.Rowsr.ItemArray0.ToString;? Kindly advise, thank you. Hi, may i know how to set Other font style in oSheet.Cells4, 3 = QueryDB.Rowsr.ItemArray0.ToString;?

1. Excel Vba Cell Format Text

Hi, Thanks for your post! According to your description, I am afraid your problem is out of support in C# forum. I move your thread to, I think you can get more professional help in there! Movie shabd 2005. We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.

C Tutorial for Beginners - Learn C programming in simple and easy steps starting from basic to advanced concepts with examples including C Overview, language basics. Stock analysis for Citigroup Inc (C:New York) including stock price, stock chart, company news, key statistics, fundamentals and company profile. Dec 18, 2013 C#: How to identify the cell format is Number or currency. Microsoft.Office.Interop.Excel.Application app = new. If the Format that does't match.

Thanks for helping make community forums a great place. Click to participate the survey.

Thanks MSDN Community Support Please remember to 'Mark as Answer' the responses that resolved your issue. It is a common way to recognize those who have helped you, and makes it easier for other visitors to find the resolution later.

Excel Vba Cell Format Text

Hi, may i know how to set Other font style in oSheet.Cells4, 3 = QueryDB.Rowsr.ItemArray0.ToString;?

Hi All I have written a small application that opens a Excel 2007 worksheet as follows: //sheet Microsoft.Office.Interop.Excel.Worksheet sheet = (Microsoft.Office.Interop.Excel.Worksheet)wb.SheetsplaceHoldercell.Sheet; //cell Microsoft.Office.Interop.Excel.Range cell = (Microsoft.Office.Interop.Excel.Range)sheet.CellsplaceHoldercell.Row, placeHoldercell.Column; I can read the Value of the cell fine using ' cell.Value'. However the problem I have is that when I read the value it doesn't retain the format of the value as displayed in the worksheet. For example if the cell is formatted as a Time value or a Fraction, I would like to retrieve this value as the displayed Text representation.

Can someone please help in providing a code snippet that allows me to Read a Cell's value, importantly retaining its format as displayed to the user viewing the document? Hi, According to your description, you want to get the display text from Excel cell.

You can use to achieve the goal. You can refer code below: //sheet Microsoft.Office.Interop.Excel.Worksheet sheet = (Microsoft.Office.Interop.Excel.Worksheet)wb.SheetsplaceHoldercell.Sheet; //cell Microsoft.Office.Interop.Excel.Range cell = (Microsoft.Office.Interop.Excel.Range)sheet.CellsplaceHoldercell.Row, placeHoldercell.Column; //get the text string text=cell.Text; Best regards Fei We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place. Click to participate the survey.