Reading Excel file make changes and save at target folder.

Report · Jun 05, 2024

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.

Report · Jun 07, 2024

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