Get column as "text" when mapping a column.

Question

Get column as "text" when mapping a column.

timh52280 opened this issue 2 years ago · 6 comments

First thank you very much for making this great library really is very useful, I just want more than to report a bug, I want to see if there is a way to get the data from a column as "text" instead of inferring the data type with the first column, since the excel file I process I have no way to process it by hand, this because I have a column with some keys like the following:

PaymentForm

01
02
03
04
05

And when I map the excel file, in spite of placing the property where it is mapped as a "string", the library obtains the data as shown below:

PaymentFormStringProperty

1
2
3
4
5

Is there any way to get the data as "text" without having to process the file by hand?

Greetings.

Answer 1 · 2022-06-24T14:25:23.000Z

you can try the new TakeDynamicWithColumnType() method, if that not help, I may consider this as a bug and try to fix.

Answer 2 · 2022-06-24T14:30:34.000Z

Thank you, I will test it and get back with the results.

Answer 3 · 2022-06-24T15:29:13.000Z

Doesn't work if the cells for example are Numeric with format.

Answer 4 · 2022-06-24T15:48:10.000Z

I think it is not really a bug but a missing feature, because for example, if the cell has CellType.Numeric NPOI does not allow to get StringCellValue, I have been reading that it is recommended to use DataFormatter and IFormulaEvaluator objects to get the text value of the cells.

Answer 5 · 2022-06-25T06:30:19.000Z

thanks for the info, will fix it in next release.

Answer 6 · 2022-06-27T14:08:25.000Z

Thank you.