From forms to cells

  • steinerized

    (@steinerized)


    9 years, 7 months ago

    Hi there,

    I’m looking for a way to edit a specified Excel spreadsheet throughout forms.

    I got this spreadsheet which is not linear in costruction and has some macros which permit to edit only few selected cells. I want to create one form for each editable cells and eventually put it in a page to allow everybody to edit the and eventually send it to an email address.

    It is possible throughout plugin or not?

Viewing 1 replies (of 1 total)
  • Moderator bcworkz

    (@bcworkz)

    9 years, 7 months ago

    I’m not aware of any such plugin. Spreadsheet plugins seem to be focused on importing or exporting data, not altering specific cells AFAIK.

    Assuming the spreadsheet is saved in XML format, it would be feasible to write a custom script that locates the particular cell within the file’s data stream and inserts whatever content there. Basic PHP file and string manipulation is all that is required, along with an understanding of the spreadsheet’s XML schema.

    Writing user data to a file that can run macros when it’s loaded in it’s native application has serious security implications. Be sure you validate and sanitize the user data to prevent code injection attacks. The native cell protection does nothing when you access a file this way.

Viewing 1 replies (of 1 total)

The topic ‘From forms to cells’ is closed to new replies.