Formatting issues when importing large excel files

Hi,

I'm having a problem with my grid when I import large excel files (around 5,000 rows). When I import those excel files my grid cells formatting changes. The rows become taller and the columns become wider.

Without changing the cell formatting in excel I can reduce the number of rows down to around 8 or so and it imports fine with the cell formatting as it should be.

Has anyone had any issues with this as well.

Thanks

John

Hi John,

Could you post your template excel file here, we will check it soon.

And which version of Aspose.Grid.Web you are using, kindly try the latest version.

Thank you.

Here is the excel file. I'm using the version of grid that comes in aspose.total version 1.4.0.6 which according to the about on the control in vs 2005 it says 1.9.1.0 for the grid.

Thanks
John

Hi John,

I tested importing your template file. I don't find any signifincant problem with row heights and column widths. Kindly use 1.9.4 or greater versions of Aspose.Grid.Web.

Thank you.