No, but it is easy to write code in ASP, ASP.NET, JSP, PHP to insert and retrieve data.
Yes, you can write functions of your own.
The cells are accessable, but not as a grid, but as variables and arrays. We optimized the grid away, since it in theory can contain 1,000,000 cells per sheet.
There are several solution. For example, you can send them over an URL with the syntax http://www.foo.com/calc.htm?bar=56 will set the field call bar to 56. You name cells in Excel.
This assumes that you are prefilling an input cell. Here is a better solution that can be used to set any value.
If you know ASP, the simplest solution is to take the HTML page, make it into a ASP-page over replace statements like
p1A1 = 1234
p1A1 = <%= reference to variable which contains the value for cell A1 on sheet 1 %>
where 1234 is the default value that you set in Excel and which you want to read from the database instead.
This solution also works for PHP.
If you want to set constants, see <a href=”/tutorials/programmers/in itialize-values-on-server/Default.htm”>How to initialize values on the server</a>
Click on Download to install and test this Excel add-in for Windows.
Click on Upload to let us convert a spreadsheet for you for free.