Recent Posts
· Using formulas in Microsoft Excel CSV files
· Getting an Epson LX-810 printer to work on Windows...
· Javascript code to jump cursor to next box in an H...
· Old versions of software
· Internet Explorer 7 keeps redrawing screen on Wind...
· Blogger: stack overflow at line 54 part 2
· Rules automatically created for the program: Syman...
· Rules automatically created for the program: Syman...
· Rules automatically created for the program: Syman...
· But does it get you off the junk fax lists?

April 2005
May 2005
June 2005
July 2005
August 2005
November 2005
December 2005
January 2006
February 2006
March 2006
May 2006
June 2006
July 2006
August 2006
October 2006
March 2007
May 2007
June 2007
September 2007
November 2007
January 2008
June 2008
August 2008

· Startup Applications List
· Welcome to the Hex Hub (Named Hexadecimal Color Codes for HTML)

More blogs on this site:

Powered by Blogger

Computer Blog -

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.

Geeks rule.
Profile · Current Blog

Google Custom Search

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: ,

0 Comment(s)

How to open an online Excel spreadsheet at a particular cell
posted by Colleen Shirazi, Monday, January 23, 2006 at 3:48 PM (Pacific)

I do not know if this works using the MS Excel Viewer, i.e. I am testing this on a computer with Excel installed in it. (This is usually the least of your worries.)

It seems like a crushingly obvious thing to do and yet the only clue I found as to how to do it, was a rather obscure reference on the Microsoft site:

HOW TO: Link to a Particular Worksheet from a Web Page in Excel 2000

Check it out:!a1!p6


0 Comment(s)