Excel Shell Scripting -- 2
Budget: ₹600 – ₹1,500 INR
I want to convert Excel function to Shell Script with output sent to a given file. It is currently done directly in Excel.
Basically, I want to parse an excel file. Today there is already a function created and I would like to "translate" it to shell script.
=SE(J2="Settlement Price";"MarketPrice;"&G2&";8;BVMF;"&SE(L2>=0;"+";"")&SUBSTITUIR(L2;",";".")&";1;"&SUBSTITUIR(K2;"_";";");"EconomicIndicator;"&G2&";8;BVMF;"&SE(L2>=0;"+";"")&SUBSTITUIR(L2;",";".")&";"&SUBSTITUIR(K2;"_";";"))cc
Basically, I want to parse an excel file. Today there is already a function created and I would like to "translate" it to shell script.
=SE(J2="Settlement Price";"MarketPrice;"&G2&";8;BVMF;"&SE(L2>=0;"+";"")&SUBSTITUIR(L2;",";".")&";1;"&SUBSTITUIR(K2;"_";";");"EconomicIndicator;"&G2&";8;BVMF;"&SE(L2>=0;"+";"")&SUBSTITUIR(L2;",";".")&";"&SUBSTITUIR(K2;"_";";"))cc