So the business/IT hybrid person with the power BI set of tools is where the future is. Along come power query, power pivot, and power BI which business people can learn and use for really great reporting. He essentially says that IT and trained BI people don’t know what business users want or need in terms of data and reporting, but business people don’t have the skills to do it themselves. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors DateĪ community since MaDownload the official /r/Excel Add-in to convert Excel cells into a table that can be posted using reddit's markdown. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified

Only text posts are accepted you can have images in Text posts.

Use the appropriate flair for non-questions.

Post titles must be specific to your problem.

The file should contain 8 ascii files (they're surface temperatures for a site on the surface of Mars). Here's a link to one of the files, I can't provide a link to the website I'm operating, it's not up and running yet. I would prefer not to tell users to use the terminal though, if I can avoid it. Warning : 3 extra bytes at beginning or within zipfile (attempting to process anyway) Opening the zip file in the terminal using unzip works, though gives the warning

I don't think that's the case with mine because it works fine on my Linux machine. Going by a google search the zip-cpgz loop looks like it is a pretty common problem, but almost all the solutions suggest that the original file was poorly formatted a zip of a non-existant initial file, a zip produced by a windows machine with a different file ending, things like that. Double clicking the cpgz file creates another cpgz, etc etc. But if I download the files using my Mac laptop the files will not unzip, double clicking creates a cpgz file. It works perfectly on the Fedora linux computer I'm running it on.

I'm using PHP ZipArchive to allow website users to combine a few files into a zip file, and then download them. Dynamically created zip files by ZipStream in PHP won't open in OSX

Zip cpgz loop