| | |
| | | } |
| | | let isToExponential = '' |
| | | let list2 = [] |
| | | |
| | | excelMethodList.forEach(item => { |
| | | if (item.valueList&&item.valueList.length>0&&item.valueList.find(m => m.r == r && m.c == c)) { |
| | | var comValue = {} |
| | |
| | | self.postMessage(JSON.stringify(result)) |
| | | } |
| | | } catch (error) { |
| | | |
| | | console.log('error---', error) |
| | | } |
| | | |
| | | } else { |
| | |
| | | try{ |
| | | let val = parseFloat(comResult.toFixed(3)) |
| | | a[b].v.v = isNaN(val) ? '' : val |
| | | }catch(e){ |
| | | }catch(error){ |
| | | a[b].v.v = comResult |
| | | console.log('error---', error) |
| | | } |
| | | break |
| | | } |
| | |
| | | } |
| | | self.postMessage(JSON.stringify(result)) |
| | | } catch (error) { |
| | | |
| | | console.log('error---', error) |
| | | } |
| | | } |
| | | |
| | |
| | | } |
| | | return num; |
| | | } catch (error) { |
| | | |
| | | console.log('error---', error) |
| | | } |
| | | } |
| | | /** |
| | |
| | | } |
| | | return max; |
| | | } catch (error) { |
| | | |
| | | console.log('error---', error) |
| | | } |
| | | } |
| | | /** |
| | |
| | | } |
| | | return min; |
| | | } catch (error) { |
| | | |
| | | console.log('error---', error) |
| | | } |
| | | } |
| | | /** |
| | |
| | | return null; |
| | | } |
| | | } catch (error) { |
| | | |
| | | console.log('error---', error) |
| | | } |
| | | } |
| | | /** |
| | |
| | | try { |
| | | return Math.abs(val); |
| | | } catch (error) { |
| | | |
| | | console.log('error---', error) |
| | | } |
| | | } |
| | | /** |
| | |
| | | return null; |
| | | } |
| | | } catch (error) { |
| | | |
| | | console.log('error---', error) |
| | | } |
| | | } |
| | | |
| | |
| | | } |
| | | } |
| | | } catch (error) { |
| | | |
| | | console.log('error---', error) |
| | | } |
| | | } |
| | | |
| | |
| | | letter += String.fromCharCode(65 + (i % 26)); |
| | | return letter + (parseInt(cellId[1]) + 1); |
| | | }catch(e){ |
| | | console.log('error',cellId) |
| | | console.log('error',e) |
| | | } |
| | | } |
| | | /** |
| | |
| | | } |
| | | return id; |
| | | }catch(e){ |
| | | console.log('error',id) |
| | | console.log('error',e) |
| | | } |
| | | } |
| | | |
| | |
| | | }) |
| | | return arr2; |
| | | } catch (error) { |
| | | |
| | | console.log('error',error) |
| | | } |
| | | } |
| | | /** |
| | |
| | | 'AVERAGE', |
| | | 'ABS', |
| | | ] |
| | | f = f.replace(regex, ',').replaceAll('"&','').replaceAll('&"','') |
| | | f = f.replace(regex, ',').replace(new RegExp('"&', 'g'),'').replace(new RegExp('&"', 'g'),'') |
| | | fouList.forEach(item=>{ |
| | | f = f.replaceAll(item,',') |
| | | f = f.replace(new RegExp(item, 'g'),',') |
| | | }) |
| | | let arr = f.split(',').filter(item=>{ |
| | | return item&& /[a-zA-Z]/.test(item)&&item!='undefined'&&item!='null' |
| | | }); |
| | | return arr; |
| | | } catch (error) { |
| | | |
| | | console.log('error',error) |
| | | } |
| | | } |
| | | /** |
| | |
| | | }) |
| | | return arr0; |
| | | } catch (error) { |
| | | |
| | | console.log('error',error) |
| | | } |
| | | } |
| | | |
| | |
| | | obj[item] = item |
| | | } |
| | | }) |
| | | str = str.replaceAll(':', '-') |
| | | str = str.replace(new RegExp(':', 'g'),'-') |
| | | // 替换参数 |
| | | for (var a in obj) { |
| | | str = str.replaceAll(a, obj[a]) |
| | | str = str.replace(new RegExp(a, 'g'),obj[a]) |
| | | } |
| | | // 计算 |
| | | for (var a in arr) { |
| | | str = str.replaceAll(a, arr[a]) |
| | | str = str.replace(new RegExp(a, 'g'),arr[a]) |
| | | } |
| | | if(str.includes(',,')){ |
| | | str = str.replaceAll(',,', '') |
| | | str = str.replace(new RegExp(',,', 'g'),'') |
| | | } |
| | | if(str.includes('&"/"&')){ |
| | | return str.replaceAll('&"/"&', '/').replaceAll('//','') |
| | | return str.replace(new RegExp('&"/"&', 'g'),'/').replace(new RegExp('//', 'g'),'') |
| | | }else { |
| | | return eval(str) |
| | | } |
| | | } catch (error) { |
| | | |
| | | console.log('error',error) |
| | | } |
| | | } |
| | | |