Hf dZddlZddlZddlmZddlmZdZdZdZ dZ d Z d Z e eeeee eje eje eje ee de eei Zd Zd ZdS) z pyexcel.formatters ~~~~~~~~~~~~~~~~~~~ These utilities help format the content :copyright: (c) 2014-2022 by Onni Software Ltd. :license: New BSD License, see LICENSE for more details N)Decimal) constantsc|tkr# t|}nQ#t$r|}YnCwxYw|tkr2 t|}t|}n#t$r|}YnwxYw|}|S)z"Convert string to specified format)float ValueErrorintvalue target_formatrets d/var/www/ffwdstore.be/apps/py-env/lib/python3.11/site-packages/pyexcel/internal/sheets/formatters.pystring_to_formatrs ,,CC   CCC  #   ,,Cc((CC   CCC  Js ,,A A)(A)cv|tkrt|}n|tkrt|}n|}|S)z!Convert float to specified format)rstrr s r float_to_formatr$s<%jj #  %jj Jcv|tkrt|}n|tkrt|}n|}|S)zConvert int to specified formatrrr s r int_to_formatr0s<Ell #  %jj Jrc@|tkrt|tjr|d}nbt|tjr|d}n2t|tjr|d}n|}|S)z Convert date to specified formatz%d/%m/%yz%H:%M:%S)r isinstancedatetimedatestrftimetimer s r date_to_formatr;s eX] + + -..,,CC x0 1 1 -..,,CC x} - - -..,,C Jrcn|tkrt|}n|tkr |dkrd}nd}n|}|S)z Convert bool to specified formattruefalserr s r boolean_to_formatr!IsFEll #   A::CCCC JrcV|tkrd}n|tkrd}n tj}|S)z'Convert empty value to specified formatgr)rrr DEFAULT_NA)_r r s r empty_to_formatr%Ws3 #  " Jrc*tj|S)N)jsondumps)r to_types r default_formatterr*os :e  rc||dkrd}nt|}nd}t|t}|||S)zWrapper utility function for format different formats :param type from_type: a python type :param type to_type: a python type :param value value: a python value N)typeCONVERSION_FUNCTIONSgetr*)r)r from_typefuncs r to_formatr2ssT  B;;IIU II  # #I/@ A AD 4w  r)__doc__r'rdecimalrpyexcelrrrrrr!r%rrrrrboolr.r*r2rr r8s  ******&           ? ~ M> M> / _      r