Hello,
I have a grid that shows a client's stock at a selected date and the client can export to Excel the grid.
My problem is that i want to put the date of the stock and the name of the client at the begining of the excel.
Is there any way to achieve this?
Can i export the grid with a title or can i make that the exportation of the grid headers begin at row index 1 instead of row index 0?
Thanks
Hello fjVazquez,
Thank you for posting in the community!
Exporting WebDataGrid to Excel with a title can be achieved with WebExcelExporter method overloads. It allows exporting the grid on a certain position in the excel worksheet leaving space for the title wherever it`s needed:
WebExcelExporter.Export( WebDataGrid, worksheet, rowOffset, columnsOffset).
Some further reference could be found at:
http://help.infragistics.com/Help/NetAdvantage/ASPNET/2012.2/CLR4.0/html/Infragistics4.Web.v12.2~Infragistics.Web.UI.GridControls.WebExcelExporter~Export(WebDataGrid,Worksheet,Int32,Int32).html
Title could be some custom text of your own or a value of one of the grid`s cell depending on your requirement. I am attaching a small sample for this scenario.
Do not hesitate to contact me if you have any additional questions.
I am still following your case. Have you been able to resolve the issue?If you still have any concerns or questions I will be glad to help. If you need any additional assistance do not hesitate to ask.
Thanks for your answer Vasya, it worked perfectly.
I am glad you have been able to resolve you issue. Feel free to contact me if you need any further support.