We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Behavior different if excel 2007

Thread ID:





79652 Feb 19,2009 01:01 PM UTC Feb 20,2009 10:29 AM UTC WinForms 1
Tags: XlsIO
Administrator [Syncfusion]
Asked On February 19, 2009 01:01 PM UTC

When I turn off grid lines, row headers and set styles on a worksheet it works find it the sheet is Excel97to2003. These same properties have NO affect if the sheet is added as Excel2007.

How do I get the grid lines off, row headers off and set styles if the workbook is Excel 2007? (I have saved the report as xlsx)

m_WorkBook = m_ExcelApp.Workbooks.Add(ExcelVersion.Excel2007);
m_WorkBook.Worksheets[0].IsGridLinesVisible = false;
m_WorkBook.Worksheets[0].IsRowColumnHeadersVisible = false;

IStyle headerStyle = m_WorkBook.Styles.Add(Utility.getColumnHeaderStyleName());
headerStyle.WrapText = true;
headerStyle.Font.Bold = false;
headerStyle.Font.FontName = "MS Sans Serif";
headerStyle.Font.Size = 7;
headerStyle.VerticalAlignment = ExcelVAlign.VAlignCenter;
headerStyle.HorizontalAlignment = ExcelHAlign.HAlignCenter;
headerStyle.ColorIndex = ExcelKnownColors.Grey_25_percent;

Geetha M [Syncfusion]
Replied On February 20, 2009 10:29 AM UTC


Thank you for your interest in Syncfusion products.

Ability to toggle the visibility of row and column header for Excel 2007 format is yet to be supported by Essential XlsIO. Besides that, I was not able to reproduce the other problems. You could check the test sample in the link below:


Please try running the above sample and do let me know if you could see the same output as in the screenshot. Also please let me know the Essential Studio version which you are using.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon