Skip to main content
faizank94658980
Known Participant
Jun 5, 2024 4:42 PM UTC
Question

Excel file modification records and save modified file at target location

I am finding solution in ColdFusion21 to get a file from a folder. I want to make changes in that file and want to remove top few header rows as well as blank rows. 

Then i want to filter records based on keywords "Water" that is in column 6. Then I have to remove last 2 coulmns that is 9 and 10.

After all that changes I have to save that modified Excel file at target location.

Note: Top header rows exsists in 2 columns only where detailed rows is in 10 columns.

    This topic is closed to new replies. Start a new post to keep the conversation going.

    2 replies

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    Jun 7, 2024 12:39 PM UTC

    See the suggestion for debugging that I gave in your other thread: https://community.adobe.com/t5/coldfusion-discussions/i-need-expert-assistance-for-excel-file-modification/td-p/14663190 

    Translate
    kglad
    Community Expert
    kgladCommunity Expert
    Community Expert
    Jun 5, 2024 4:59 PM UTC

    in the future, to find the best place to post your message, use the list here, https://community.adobe.com/

    p.s. i don't think the adobe website, and forums in particular, are easy to navigate, so don't spend a lot of time searching that forum list. do your best and we'll move the post (like this one has already been moved) if it helps you get responses.



    <"moved from using the community">
    Translate
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices