[DuncanParticipant]

Hi Peter,

Thanks for the extra information. Unfortunately I’m not using the built-in export function (because of the “this is an incorrect file type” message that it creates), so I’m having to do it manually using XLSX.utils.

Thanks,

—
Duncan

[DuncanParticipant]

Hi Peter,

I’ve tried setting the columns’ exportable property to false wherever their hide property is true, but unfortunately it’s still exporting everything.

As for looping through the returned array, I take it I would need to iterate through the columns using getcolumnat, use that to interrogate the hidden property, and then use that to remove columns from a copy of getrows?

In addition, is there a simple way to apply the formatting of each column to my data so that my Excel file will be formatted the same way?

Thanks,

—
Duncan

[DuncanParticipant]

Hi Martin,

Thanks for that example. The problem is that it requires us to actually have “Select All” as an item in our source list, which isn’t always ideal when we’re loading data in from a database, for example. It also means that the “Select All” item appears in the results of getCheckedItems, so I would need to code around that whenever I want a list of checked items.

It’s obviously not that difficult to do, but it’s a bit clumsy, especially when I’m using a load of drop downs on my page. I was hoping there might be a smoother way to achieve it.

Thanks,

—
Duncan

[DuncanParticipant]

This is using the checkbox option, obviously!

[Author]

Posts