recentpopularlog in


« earlier   
formatting - How can I format bytes a cell in Excel as KB, MB, GB etc? - Stack Overflow
[<1000000]0.00," KB";[<1000000000]0.00,," MB";0.00,,," GB" Format numbers in excel as KB, GB, MB for memory, files, etc.
excel  format 
yesterday by iamthefury
Power Query Source from Relative Paths
Query sources from a path relative to the Analysis Tool file
excel  programación  M-script  power-query 
2 days ago by menosesmas
Combining Data From Multiple Excel Files - Practical Business Python
A common task for python and pandas is to automate the process of aggregating data from multiple files and spreadsheets.

This article will walk through the basic flow required to parse multiple Excel files, combine the data, clean it up and analyze it. The combination of python + pandas can be extremely powerful for these activities and can be a very useful alternative to the manual processes or painful VBA scripts frequently used in business settings today.
python  excel  pandas 
4 days ago by cothrun
How to merge Excel files into one
How to merge Excel files with VBA
If you have multiple Excel files that have to merged into one file, a faster way would be to automate the process with a VBA macro.
excel  vba 
4 days ago by cothrun
SpreadsheetLight for .NET Framework
Open source developer-friendly spreadsheet library compatible with Microsoft Excel 2007/2010/2013 and LibreOffice Calc
SpreadsheetLight is an open source Open XML spreadsheet library for .NET Framework written in C#, and is released under the MIT License. You can create new Open XML spreadsheets, or work with existing Open XML spreadsheets that are compatible with Microsoft Excel 2007/2010/2013 and LibreOffice Calc.
c#  excel 
4 days ago by cothrun

Copy this bookmark:

to read