Export Image in Printing

chael711

Image cant be exported in Excel and CSV?
Is this possible?

allan

Buttons will strip HTML from the export by default. You can stop it doing that using the stripHtml option of the buttons.exportData() method (which for the print button you can control using the exportOptions parameter).

Allan

chael711

Printing using print button works fine , but when i export to csv or excel, images are missing

F12Magic

CSV will never support images because it's a plain text file. Unless you mean you want the url to your image as text in the csv. With the standard excel export it isn't possible either to display the image. It would require major customizations.

In case you would like the links( html ) in the exported files, use something like below to initialize your datatable:

$('#myTable').DataTable(
    buttons: [
        {
            extend: 'csvHtml5',
            text: 'CSV',
            exportOptions: {
                stripHtml: false
            }
        },
        {
            extend: 'excelHtml5',
            text: 'Excel',
            exportOptions: {
                stripHtml: false
            }
        }
    ]
);

chael711

Is there any possible way to do this? export in excel?

F12Magic

I haven't tried it yet myself. But it should be possible. But would require a lot of googling.

allan

Yes, it would indeed be possible since the file being created is a true xlsx file. However, it isn't something I've attempted myself and I suspect it would be relatively complicated. The first set would be to read through the Open Spreadsheet specification to understand how images should be embedded into such a file. You could also create an XLSX file and inspect its raw XML and file structure to understand how Excel itself does it.

Allan

DeFKnoL

I think that what would be really great is if the export algorithm encountered an image, that it would use the ALT attribute for the image tag.