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

Parents

No Data

Reply

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

Children

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