Second Episode of my Comics Strip (now I have to name the series )
This is a short comics strip based on SAP SDN Community. I hope you like it, I would like to dedicate to all of you!
Please comment below 😀
today we would like to present you our new small and handy solution in which we provided a functionality to export Excel data into a fixed column width file format. This means that all your data columns in the file will have a fixed length.
This is an Excel add-in which can become usefull for those who have to work with integrated legacy systems where the input data format should be (or was configured to be) in this fixed column width format. This was actually our case when we had to work with some legacy system which contained some dozens of transformation rules that worked with this data format. In order not to change the system that already worked we just created this handy tool to simplify data export. 🙂
So, how does it work?! As soon as you activate it in the Tools/Add-in menu, you will find YellowRiver menu item with Export to fixed width file submenu which in turn contains (by now) one button of data export. 😉
This add-in is also supplied by a custom function to be used in Excel cells. It is used to determine the maximal text length in the selected range of cells. The function is situated in the Export2File function category and has a name MaxWidth.
Today we would like to present you another solution that we started to use in our company. This is a tool for automatically building ARROW CHARTS!
After spending some time searching for ideas or similar tools in the Internet we found nothing that would perfectly fit our needs, thus, we created our own solution. 🙂
To make the story short, this is how it works:
The tool works with a 4-column table of data where each row starts with a name of the series. An XY chart will be created (or you may use any already created XY chart). Only four columns after the title column are considered. The tool will use the first 2 data columns to put the point and the arrow from the second point will point to the first one. 🙂 (I hope I made myself clear…)
The current version does not work correctly in Excel 2007. In fact, it works perfectly well in Excel 2003. So, make sure you updated your MS Office software. Since this is our tool for internal use, we did not test it on Office 2002 and Office 2000.
Soon we will introduce the support for Office 2007.
This tool can become very useful for the companies which conduct marketing research and need to build dozens of arrow charts. Since Excel does not provide tools for doing that automatically the work is typically done manually. From now on we make Excel do it for us!!! 🙂
Feel free to contact us with any questions, suggestions and ideas about this topic.
Traditionally, you can find this solution on our web site www.yRiver.it
(ArrowCharts.exee [the file you download is a self-extracting archive; change its extension from .exee to .exe])
where in the category OUR PROJECTS
you can also find other projects, solutions, ideas and concepts. 🙂