Using cfform to update an Excel sheet

[tracjerian]

I am building a cfform to update a spread sheet, but am not sure how to indicate what column/row that the form field should update in the excel file.
anyone have any ideas?

[tracjerian]

I am building a cfform to update a spread sheet, but am not sure how to indicate what column/row that the form field should update in the excel file.
anyone have any ideas?

[zz3top]

The easiest way is to store the Spreadsheet name, Sheetname and address of the
cell - e.g. "Example.xls", "Sheet1" and "A1" then use these through either the
COM Interface, Apache POI or even ODBC to update the spreadsheet.

Step 1 - read the spreadsheet area desired - Sheet1!A1:C12
Step 2 - display a form (ala CFGRID) to display the Excel data or a more
simple approach is to have the user select a row and then have an edit form
display the row's content for update
Step 3 - update the spreadsheet

simple example - setup a table with 3 columns and 2 rows. place a CFFORM
before and after the table. Make the Spreadsheet name and the Sheetname a
hidden attribute of the form. For each cell in your table, you will have a
hidden field containing the field reference - e.g. A1, B1, C1 and an input
field that contains the value of the cell.