in reply to write over existing Excel file


This a FAQ in relation to Spreadsheet::WriteExcel and here is the usual (but not completely satisfactory) answer.

--
John.

Replies are listed 'Best First'.
Re^2: write over existing Excel file
by Anonymous Monk on Oct 09, 2005 at 16:35 UTC
    Thanks for the help though... IF I cant find anything else, I will use this but would probably need some clarification... Thanks again..
Re^2: write over existing Excel file
by Anonymous Monk on Oct 09, 2005 at 16:34 UTC
    I would still need to do this even though I would only need to change data in 5 specific cells out of the whole sheet? There's gotta be an easier way somehow??

      I would still need to do this even though I would only need to change data in 5 specific cells out of the whole sheet?

      Unfortunately, yes.

      There's gotta be an easier way somehow?

      Have a look at Excel::Template.

      --
      John.

        John, looks good, Im confused about the XML file. IF I already have an Excel file I want to use, do I just created the XML file to point to my Excel file? I guess I dont understand what the XML file is for. Thanks...