[Solved] Excel Biff export - formatting

[Prathibarani]

Hi,

I am exporting grid data into an excel. I needed to add company logo at the top in excel. So, I did this:

string

 

 

imageURL = Page.ResolveUrl("~/Images/") + "Companylogo.jpg";
 Radgrid1.ExportSettings.FileName = pFileName;

 

Telerik.Web.UI.ExportInfrastructure.

 

Table table = pExportEventArgs.ExportStructure.Tables[0];

 

xls.

 

Cell cmpCell = table.Cells["A1"];

 

table.InsertImage(cmpCell, imageURL);

table.ShiftRowsDown(1, 8);

Then I need to add some information to the sheet like this on row 9, from starting cell like this:
table.rows[9].cells[0]. value = "Down loaded from company name:" + current Date Time;

For this long text to appear as visible, I want to merge cells and then display.

From row 10, grid data gets displayed. If cell1 is not wide enough, row 9 value partially is visible.

How can I merge cells of particular row and add value to it.

I appreciate your response.

[Daniel]

Hello Prathibarani,

You can use the Colspan property of the Cell object. The default value is 1.
Let me know if you need more information.

Regards,
Daniel
Telerik

[Prathibarani]

Hi Daniel,

Thank you. That worked. I applied the same to the cell that I chose to insert. But image itself didn't show up. this is what I did.

string

 

 

imageURL = Page.ResolveUrl("~/Image/") + "companylogo.jpg"; Telerik.Web.UI.ExportInfrastructure.Table table = pExportEventArgs.ExportStructure.Tables[0];

 

table.Title = pWorkSheetName;

xls.

 

Cell cmpCell = table.Cells["A1"];
cmpCell.ColSpan = 4;

 

table.InsertImage(cmpCell, imageURL);

 

 

//table.InsertImage(new Microsoft.Office.Interop.Excel.Range("A1","C5"), imageURL);

 

table.ShiftRowsDown(1, 9);

Above code wouldn't insert image at all. I tried range. When I try the above commented line using range, it wouldn't event let me build.

Thanks,
Prathiba

[Daniel]

Hello Prathiba,

The commented code won't work because the Interop Range object is not the same as ours. This is why I would recommend that you use an alias for the namespace. For example:
using ei = Telerik.Web.UI.ExportInfrastructure;
You can then try ei.Range, ei.Cell, and so on.
I'm not sure however what causes the issue in your scenario. Could you please prepare a small, runnable example that demonstrates the problem? I will debug it locally and then try to provide more to-the-point answer.

Regards,
Daniel
Telerik