Excel file modification records and save modified file at target location

[faizank94658980]

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.

[kglad]

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">

[BKBK]

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-modifi...