Posts This Month
· Using formulas in Microsoft Excel CSV files
· Startup Applications List
· Welcome to the Hex Hub (Named Hexadecimal Color Codes for HTML)
More blogs on this site:
Computer Blog - thebroadroom.net: August 2008
Disclaimer: all of the following is purely from personal experience. TheBroadroom.Net urges you to use your own instincts,
common sense, and willingness to take risks when applying any of the information below.
Using formulas in Microsoft Excel CSV files
posted by Colleen Shirazi,
Wednesday, August 13, 2008
at 9:46 PM (Pacific)
Did you know you can use Excel formulas in CSV (comma separated values) files? It works perfectly. You just hardcode the parts of the formula which can be hardcoded, and use your programming code to add in, say, row numbers. Open the file inside Excel and you get working Excel formulas.
Labels: csv, microsoft excel