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 : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Behavior different if excel 2007

Thread ID:

Created:

Updated:

Platform:

Replies:

79652 Feb 19,2009 01:01 PM UTC Feb 20,2009 10:29 AM UTC WinForms 1
loading
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.BeginUpdate();
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;
headerStyle.EndUpdate();




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

Hi,

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:

http://websamples.syncfusion.com/samples/XlsIO.Windows/F79652/main.htm

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.

Regards,
Geetha


CONFIRMATION

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.

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

;