potential invalid date format

[cos2000]

Hi there,

I have an XLSX file with a text column. In this column sometimes the value "#nv" occurs. When trying to convert this file, I got the error "wrong Float format" in the old version. In the current version (0.8.1) I get the error "potential invalid date format".

If I remove the entries with the value "#nv" then everything works. What can I do?

with kind regards

[dilshod]

Can you provide a sample file?

[cos2000]

Yeah i have a testdocument. Only one column. On Line 9 there is a "#nv" as value! When you try to convert, it will run until line 9 and give the error "potential invalid date format"

own.xlsx

[dilshod]

Thanks! I've added handling #N/A values.

[cos2000]

Thanks a lot. Is there coming a new version?

[cos2000]

Ive tested your fix, but now lines that has any #nv value will be ignored. Thats not nice, because when the line has other data i need, its not cool, wenn a complete line will ignoren when one field contains a #nv value!

It will be better to export the line - just export #nv als #nv.

The CSV of my sample file should look like:

43025712
43025713
43025714
43025715
43025716
43025717
43025718
#NV

if #nv is in a text defined field, then #nv is an allowed value. Just skip is not the right way.

can you change this please?
i need all data of my csv

i provided a new sample file. 2 cols - the line with "swan" as animal hast a number that ist #nv - the complete line is ignored! I need all lines!

Thank you

own.xlsx

[dilshod]

it looks good to me:
own.csv

[cos2000]

ok i have cloned the git to make it runable on my server. In my case the line with the #na value is skipped! is there a parameter to tell the program not to skip these lines?

[BeheSQ]

hi @dilshod I ran into similar problem but with #NAME? value of a date cell. (well, long story, its imported from Excel macro into Google Sheets). would it be possible to ignore this value also?

or, better, just to add a switch to ignore those errors and output the original value, I can handle it from there.

thanks a lot!