o wh@sFdZddlZddlZddlZddlmZddlmZddlmZddZ dd Z d2d d Z d3ddZ ddZ ddZddZddZeejejejeeedZedededejdejdejdediZermdee<dee<e eeeee d Zd!dZd"d#Zd$d%Zd&d'Z d(d)Z!d*d+Z"ee e!e"eed,Z#d-d.d/d0d-d-d/d1Z$dS)4z pyexcel_io.service ~~~~~~~~~~~~~~~~~~~ provide service code to downstream projects :copyright: (c) 2014-2017 by Onni Software Ltd. :license: New BSD License, see LICENSE for more details N)PY2) constants) exceptionscCs|t|kS)z/check if a float value had zero value in digits)mathfloorvaluer D/var/www/html/env/lib/python3.10/site-packages/pyexcel_io/service.pyhas_no_digits_in_floatsr cCsd}z;t|dkrtj|d}|}W|St|dkr'tj|d}W|St|dkr;tj|ddd}W|SW|StyGY|Sw) z? Read the date formats that were written by csv.writer N %Y-%m-%dz%Y-%m-%d %H:%M:%Srz%Y-%m-%d %H:%M:%S.%f)lendatetimestrptimedate ValueError) cell_textretr r r detect_date_values(      rTFcCs|do |ddu}|rdS|rd}t||rdSz'|r-|dkr(WdSt|WS|dkr?||krYnw|dkrItd ||S) z1convert to data value accroding ods specificationinvalidr r rz%Y-%m-%dT%H:%M:%Srrz%Y-%m-%dT%H:%M:%S.%fzBad date value %s)rrrrr Exceptionr-r r r date_valuejs$       r1cCsddl}|d|}|r@t|dkr@t|d}t|d}t|d}|dkr6t|||}|Stj|||d}|Sd}|S) z1convert to time value accroding the specificationrNzPT(\d+)H(\d+)M(\d+)Sr&)hoursminutesseconds) rrrgroupsr)grouprtime timedelta)rrresultshourminutesecondrr r r time_values r@cCs(|dkrd}|S|dkrd}|S|}|S)zget bolean valuetrueTfalseFr r-r r r boolean_valuesrC)rrr:r;boolean percentagecurrencyrstringrr:r;rDthrow_exception)rrr:r;rDrEcCstd|Nz %s is too big)rIntegerAccuracyLossErrorrr r r rHscCs|tjkr td||SrI)r MAX_INTEGERrrJrr r r ods_float_values rLcC |dS)Nr strftimerr r r ods_date_value rPcCrM)Nz PT%HH%MM%SSrNrr r r ods_time_valuerQrRcCs|durdSdS)zconvert a boolean value to textTrArBr rr r r ods_bool_valuesrScCs:|jd|jd}|jdd}|jd}d|||fS)z"convert a cell value to time deltar4i<zPT%02dH%02dM%02dS)daysr7)cellr5r6r7r r r ods_timedelta_values rW)rr:rDr;rrHrz date-valuez time-valuez boolean-value)rrr:rDrErFr;)TFN)T)%__doc__rrrpyexcel_io._compactr pyexcel_iorrr rr%r,r.r1r@rCrrr:r;boolODS_FORMAT_CONVERSIONr)strODS_WRITE_FORMAT_COVERSIONunicodelongVALUE_CONVERTERSrHrLrPrRrSrWODS_VALUE_CONVERTERS VALUE_TOKENr r r r s~     "