Sorry Mike,

you were right. I had a problem with Excel installation on my virtual machine. Solved it, I was able to solve the error related to excel file opening in your sample.

So, your sample works like a charm. I still have that problem copying and paste ig sample on local environment, but for sure there will be something to sort out in a different way, because the way I tried to solve it (first post) shows the meaning of the error.

Anyway, your sample is enough. I will start implementation basing on it.

Thank you very much!

FM

Hi,

of course: I have Excel installed on my laptop. And no, no errors during exports…

Flavio M.

Hi Mike!

Thank you very much for your sample. I was able to start the Excel exportation (to be honest I didn't find where is the bug on the online sample on my pc, but I see there are a lot of functions on the web sample that are not contemplated in yours).

Anyway, just one more thing: the system exports an Excel file, but I am not able to open it… It asks me again to save the file when I open it, and it says to me that the format is not correct…

Thansk in advance

Flavio M.

Hi Sanjaysutar,

let’s wait for an infragistis team confirm, but I think this is what you were looking for:

//Initialize

$(".selector").igGrid({

    autoGenerateColumns: false,

    columns: [

        { headerText: "Product ID", key: "ProductID", dataType: "number", format: "number" },

        { headerText: "Production Date", key: "ProductionDate", dataType: "date", format: "ddd, MMM-d-yy HH:mm" },

    ]           

});

You can find it directly on the Infragistics objects help:

https://www.igniteui.com/help/api/2025.1/ui.iggrid

If you look at the options, you will findcolumnsand then different possible attributes, such asdataType(for your sample it will be “date”),headerTextand, of course,format(for your sample a string with format type, such as “dd-MM-yyyy” or everything else).

Hope will help you,

Flavio