Hello,I would like to use the excel export to export a data grid with a more sophisticated presentation in the excel file.For example, add a logo, a title and insert the export not in line 1 but in line 10.Is this possible and if so, how to proceed?
Best regards,
Philippe DUFEIL
Hello,
My suggestion in order to have better control over the style and structure of the exported file is to use our Excel Library instead of the Excel Exporter service.
More about the Excel Library as well as code-snippets that demonstrate how different scenarios could be achieved could be found here.
Let me know if I may be of any further assistance.
Sincerely,Teodosia HristodorovaAssociate Software Developer
Hello,Thank you for your reply. Is it possible to have an example of code showing how to insert data grid with Excel Library ?
I have prepared a small sample where I'm creating a workbook with several options, a worksheet and a table in order to demonstrate how it could be exported. Depending on your scenario you could modify the suggested approach in order to achieve your requirement.
Here could be found my sample for your reference. Please test it on your side and let me know if I may be of any further assistance.
Sincerely,
Teodosia Hristodorova
Associate Software Developer
Hello,Thank you very much for the example provided. It helps me.
I am trying to add a logo in my excel file, but I have errors:
const wb = new Workbook(WorkbookFormat.Excel2007) ; const tasksSheet = wb.worksheets().add('Tasks') ; const tasksHeader = tasksSheet.rows(10) ;
//Image Logoconst wsi = new WorksheetImage("/assets/Logo.png")wsi.topLeftCornerCell = tasksSheet.rows(0).cells(0)wsi.topLeftCornerPosition = new Point(0,0)wsi.bottomRightCornerCell = tasksSheet.rows(3).cells(0)wsi.bottomRightCornerPosition = new Point(50,50)wsi.positioningMode = ShapePositioningMode.DontMoveOrSizeWithCellstasksSheet.shapes().add(wsi)
It doesn't seem to recognise the path of the image. I have the following error:
_message: "The image doesn't appear to a valid data url"
Have you some idea ?
Regards,
Philippe
After an investigation, I have created a private support case with an ID of C-00221571 for you and I will continue assisting you via this support case. In order to view it on our web site please follow these steps:
1) Go to our Customer Portal - https://account.infragistics.com/
2) Log in with your account, if needed
3) From the tab menu select ‘Support’ - https://account.infragistics.com/support-cases
There you will find a list of all the active cases.
Please let me know if you have any additional questions regarding this matter.