I'm actually building an app in UWP which has for objective to convert a xls(x) file into a sécurisé pdf file. To make that conversion, one of the step I need (and made) was the conversion from a RaadSpreadsheet.Workbook into a DataTable via the wonderful tool you provide, DataTableFormatProvider.Export()
It does wonder until I was recently given a sample xls with some filter in it. And during the conversion, I've received an error concerning the wrong datatype (ListDictionaryInternal) in place of string. I understand where the error come from and I understand that I just need to get rid of theses excel filter (or to ignore them during conversion but I was unable to find how.
Right now, I'm thinking about converting by myself each spreadsheet row/cell into datatable row/cell one by one but I still want to know if there is an option to the formatage to ignore this type of data ?
Or maybe is there a way to delete/clear theses ListDictionaryInternal from the spreadsheet ? (btw, I've tried deleting the row but it seems like the filter is pasted onto the document even if it is not visible)
I would appreciate any help. Thank in advance :)