Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Fitting high order polynomials
- Contour plots with Excel and Matplotlib
- Using Linest for non-linear curve fitting, examples, hints and warnings
- The history of the theory of beam bending - Part 1
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Installing PyPardiso and speed of Scipy spsolve
- Passing variable argument lists from Excel to Python via xlwings
- 64 bit Excel and PtrSafe
Recent Comments
Tag Archives: import csv
Dealing with dates 3: opening and saving csv files without data corruption
This post makes use of a spreadsheet for reading data from text files, including comma separated value (csv) files. The latest version includes a routine for saving the imported data in csv format. It can be downloaded (including full open-source … Continue reading
Daily Download 32: Text functions
Today’s daily download covers functions to import data from text files into Excel quickly and efficiently, a function to combine text strings, with improved functionality over the built-in Concatenate function, and functions to extract numbers from the beginning or end … Continue reading
Posted in Excel, UDFs, VBA
Tagged combine text strings, Excel, import csv, Import large files, import text, UDF, VBA
1 Comment
Automatic download of csv files
I was recently asked if I could assist with preparing a spreadsheet to automatically download .csv files from an internet location, with the filename incorporating the date of issue. The process turned out to be quite straightforward, and works well … Continue reading