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

XlsIO importing rows of zero height

Thread ID:





53418 Dec 13,2006 02:01 PM UTC Dec 14,2006 11:39 AM UTC WinForms 1
Tags: GridControl
Jonathan Hartley
Asked On December 13, 2006 02:01 PM UTC

Hello there,

We're using XlsIO to import Excel .xls files into our Essential Grid application, with much success, so thanks very much for some fine components.

One problem we've noticed is that rows with height of zero are reported as having the default row height (12.75 for us) by the return from:

Workbook wb = ExcelEngine.Excel.Workbooks.Open(filename);
h = wb.Worksheets[0].Rows[1].RowHeight;

Other non-default row sizes are reported accurately.

Any clues, workarounds, fixes, etc? Thanks for any assistance,


Administrator [Syncfusion]
Replied On December 14, 2006 11:39 AM UTC

Hi Jonathan,

This can be acheived by derving the GridExcelConverterBase and create the new ExcelToGrid method to set the rowheight properly. Here is a code snippet to show this.

public class GridExcelConverterExt: Syncfusion.GridExcelConverter.GridExcelConverterBase
public GridExcelConverterExt():base(){}

public new void ExcelToGrid( string strFileName, GridModel grid )
ExcelEngine engine = CreateEngine();
IWorkbook book = engine.Excel.Workbooks.Open( strFileName );
IWorksheet sheet = book.Worksheets[ 0 ];
ExcelToGrid( sheet, grid );


book.Close( false );

private void CopyRowHeightToGrid( IWorksheet sheet, GridModel grid )
IRange usedRange = sheet.UsedRange;
for( int i = usedRange.Row, last = usedRange.End.Row; i <= last; i++ )
if( sheet.IsRowVisible(i))
grid.RowHeights[ i ] = sheet.GetRowHeightInPixels( i );
grid.RowHeights[ i ] = 0;

Please refer to attached sample for more details.

Best Regards,


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