Dynamic excel mapping for creating XBRL with help of Python/elementTree/xlrd

Posted on Sat 14 July 2012 in XBRL • Tagged with excel, excel macro, python, python xbrl creation, xbrl creatiion, xlrd, xml/xbrl • Leave a comment

Yesterday was a great day for me.. .After 3 months of development i got little bit success, i have created xbrl package from excel with help of python language.

I have developed my own mapping language which needs to be defined in excel which recognizes financial facts and their properties ...

Continue reading

Excel Macro to Prevent Excel from Removing Leading and Trailing Zeros in a single Cell or Selection of Cells

Posted on Sat 23 June 2012 in General • Tagged with excel, leading zero, macro, Trailing zero • Leave a comment

With use of macro given below you can apply ="cell_value" on any selection.

Solution is:

[caption id="attachment_397" align="alignleft" width="460"]macro for preventing leading and trailling zeros in excel macro for preventing leading and ...

Continue reading