2 Replies Latest reply on Feb 29, 2008 11:31 AM by Newsgroup_User

    Remove Email Addresses From a Formatted Excel File

    jqcf Level 1
      I have an excel file that has some formatting in it that I would like to preserve (some cells have background color, etc). I'd like to remove a list of email addresses from this file. My first thought is to use cffile with action read, use the following in a cfloop: replace(emailAddressToDelete, excelFileVarCreatedFromCffileRead) and then save it back to excel format with cffile using action write. I tried this and the Excel file would not open. The error was:

      test.xls cannot be accessed. The file may be read-only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding.

      I'm guessing something went wrong in the process of reading and writing the files contents and it's not as simple as I want to make it. Anyone have something to tell me that might help me remove email addresses from a formatted Excel spreadsheet?