Category: Excel

Python Pandas Pivot Table

Are you tired of creating manual Pivot Tables?
Here is the technique which you can adapt to automate the monotonous stuff you do using powerful python!!

Advertisements

phpoffice/phpspreadsheet

phpoffice/phpspreadsheet is a successor of phpExcel. We recently developed an automated solution to pull all the backup success rate reports from Dell EMC Data Protection Advisor (DPA). The portal which displays the report was good but not enough to use that information further like sharing the reports, pivoting etc..

After trying several methods, found this library to be very useful. There aren’t many examples available on the internet to retrieve data from MySQL and write to XLSX file. Hope this blog might be helpful who would like to use this library for creating XLSX files. Fear not, it doesn’t throw errors while opening this file in MS Office Excel

(more…)

Compare entire excel files online!

Vlookup, Countif etc.. are things of the past to do comparison of tables, columns etc in excel..

Say hello to ‘Cloudy Excel‘ an online tool to compare entire excel files by few clicks. Neither we need an expertise in Vlookup nor knowledge in writing formula.

Upload both source file and altered file to the cloudy excel to see all the difference values between the spreadsheets,