Download pretty reports

Software:Fast text manipulation and data extraction. Fix websites, database data and electronic text with pattern match, convert DOS/Unix end of line characters, restrict changes to line/column ranges, add/remove lines/columns, sort, split and join filesSee also: text conversion, end of line conversion, unix, convert, text, find and replace, search and replace, replace, search, ...[ Download - Buy now - More info ]ECMerge compares and merges safely your files and folders, side-by-side. It provides syntax colouring for many languages, supports many office and archive formats, pretty prints XML. It generates patch/XML/HTML reports for review or reuse.See also: directory, folder, file, compare, synchronization, comparison, tool, merge, diff, ...[ Download - Buy now - More info ]ECMerge compares and merges safely your files and folders, side-by-side or 3-way. It provides syntax colouring for many languages, supports many office and archive formats, pretty prints XML. It generates patch/XML/HTML reports for review or reuse.See also: directory, folder, file, compare, synchronization, comparison, tool, merge, diff, ...[ Download - Buy now - More info ]See also the other sections: Software Development Utilities section 1, Software Development Utilities section 2, Software Development Utilities section 3, Software Development Utilities section 4, Software Development Utilities section 5, Software Development Utilities section 6, Software Development Utilities section 7, Software Development Utilities section 8, Software Development Utilities section 9, Software Development Utilities section 10, Software Development Utilities section 11, Software Development Utilities section 12, Software Development Utilities section 13, Software Development Utilities section 14

In this tutorial we're going to reformat Excel reports with Power Query.Why? Because external systems can create some pretty ugly reports. Here’s one from a popular Australian accounting system, MYOB:It’s not just ugly because of how it looks. It’s also ugly because the layout prevents you from (easily) doing any further analysis of the data.According to Excel legend the most common button in external reporting systems is ‘Export to Excel’. Unfortunately 99% of these external systems spew out useless formatted reports like the one above, when what we really need is the data in a Tabular format.What’s an Excel Geek to do?You could spend some time cutting/pasting/transposing etc. to reformat the report into a Tabular format, but doing this every month gets pretty tedious.You could write some VBA to automatically reformat the report for you. But then you have to know how to write VBA to do that.My preference is to use Power Query to transform the report into this super useful Tabular layout like this:Once it’s in a Tabular format you can easily use Excel’s tools to analyse the data. Tools like PivotTables, SUMIF(S), COUNTIF(S) and other aggregate functions to summarise the data.Not sure if you have Power Query in your version of Excel? Here is a list of which versions of Excel include Power Query.Download the WorkbookEnter your email address below to download the sample workbook.By submitting your email address you agree that we can email you our Excel newsletter.Watch the VideoReformat Excel Reports with Power QueryThere are several steps to transform the ugly duckling MYOB report into a super useful Excel swan, but they’re easy (unlike VBA). It took me 1 minute 30 seconds to complete the following steps.And even better, once you create those steps you can use it again next month with the click of the Refresh button. Select the data you want to work with, in my case it’s in cells B9:C221. Go to the Power Query tab (or Data Tab for Excel 2016), From Table:Note: if your data isn’t formatted in an Excel Table then it will do this for you and ask you if it has headers before loading it into Power Query. We need to start culling parts of the report that we don’t need. I’ll use the column filters (they work just like in Excel), to remove the empty and ‘Total:’ rows from the Entitlements column and from the Value

Learn how to download a file from a URL that returns a redirection instead of the file directly. It's a common practice to serve files through PHP instead of serving them directly with PHP. Usually, as they are served after solving some captcha or something like that, you wont have a direct file download with the proper headers, but some random url that redirects to the file with the download headers. When you are trying to automatize stuff, this kind of behaviour is really a trouble. Personally, i decided to download the files with cURL, which makes pretty easy to download a file by simply following the redirection, for example:curl -L -o "./download.zip" " can be achieved simply using the -L parameter or the so called location. If the server reports that the requested page has moved to a different location (indicated with a Location: header and a 3XX response code), this option will make curl redo the request on the new place:curl -L -o "${filename}" "${uri}"Happy coding !