Can i add in Excel export image on top of excel page where is the title

Can i add in Excel export image on top of excel page where is the title

ds1234ds1234 Posts: 2Questions: 2Answers: 0
edited April 2022 in DataTables
 {
          extend: 'excel',
          className: 'colorName',

          text: '<h2>EXPORT TO EXCEL</h2>', //'Export to Excel',
          //orientation: 'landscape',
          //pageSize: '11x17',
          title: 'Hello',
          exportOptions: {
            modifier: {
              search: 'applied',
              order: 'applied'
            }
          },
          customize: function (doc: any) {
            console.log(doc);
            const worksheets = doc.xl.worksheets;
            const sheet1 = worksheets['sheet1.xml'];
            console.log(sheet1)
            sheet1.querySelector('c is t').innerHTML = 'Testing';
          }
        }

Edited by Colin - Syntax highlighting. Details on how to highlight code using markdown can be found in this guide.

Answers

  • colincolin Posts: 14,610Questions: 1Answers: 2,493

    This thread is asking the same thing.

    Cheers,

    Colin

Sign In or Register to comment.