GridView to Excel

To revisit a post from 6 months ago, Does Aspose.Cells handle converting the contents of a GridView control to Excel? Or, does anyone have a snippet of code that will do this? A few months ago, Warren Zhang said they were implementing this next week.

Thank you!

Hi,

Please try the Cells.ImportGridview() method.

I'm using runtime version 2.0.50727, version 4.4.1.0 of Aspose.Cells, I don't see an ImportGridView() method. Do I not have the latest version?

Thanks.

Hi,

Thanks for sharing this,

We will check it soon.

Thank you.

Hi,

Please try this fix.

And if you update Aspose.Cells, you have to refere to Aspose.Cells for Net 2.Otherwise, you could not use Cells.ImportGridView method.

In this fix,we use Cell.GetStyle and SetStyle method replace the property of Cell.Style. The two methods will save more memory usage than cell.Style property.

If you want to set style of the cell, please change your codes as :

//Getting the style of the cell.

Style style = cell.GetStyle();

//Setting the property of the style.

.......

//Setting the style of the cell

cell.SetStyle(style);