DataTableFormatProvider

[Serge]

Hello,

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 :)

[Dimitar]

Hi Serge,

I was not able to reproduce the exception. I have attached my test project with a sample file with a filter. Can you please check it and let me know what I need to change in order to reproduce this?

A possible workaround is to set the  ShouldSetDataTypes property to false and you would not get the exception:

DataTableFormatProvider provider = new DataTableFormatProvider();
provider.ExportSettings.ShouldSetDataTypes = false;

Or you can remove the filters: 

workbook.Worksheets[0].Filter.ClearFilters();

I am looking forward to your reply.

Regards,
Dimitar
Progress Telerik

[Serge]

Hey Dimitar,

 

Thanks for the answer, using the File.ReadAllBytes along with Filter.ClearFilters() and ShouldD worked perfectly.