Excel Export + add row between Header and data

535

Prathiba posted over 16 years ago

Hi,

I am using UltraWebGridExcelExporter and UltraWebGrid. When I export data to excel, I want to have 1 row between header and data. How can I do that with this control. It is simple export functionality. Do not prefer to use API or excel engine or code it.

I appreciate your response.

Thanks,

Prathiba

250

Rohit posted over 15 years ago in reply to David

Add code to Excel button click UltraWebGridExcelExporter1.ExcelStartRow = 3;
UltraWebGridExcelExporter1.DownloadName = "grid.xls"

UltraWebGridExcelExporter1.Export(gridname);
Also add this  protected void UltraWebGridExcelExporter1_BeginExport(object sender, Infragistics.WebUI.UltraWebGrid.ExcelExport.BeginExportEventArgs e)
    {
        e.CurrentWorksheet.Rows[0].Cells[0].Value = "Header";        e.CurrentWorksheet.Rows[0].Cells[0].CellFormat.Font.Color = System.Drawing.Color.Crimson;        e.CurrentWorksheet.Rows[0].Cells[0].CellFormat.Font.Height = 300;
    }

This will work...
Cancel
Reply

Verify Answer

Cancel
25

David posted over 15 years ago

Did you ever find an answer to this question? I have the same need in my project.
Thanks!
Dave
Cancel
Reply

Verify Answer

Cancel