Excel file modification records and save modified file at target location

Forum|Forum|1 year ago
June 5, 2024
2 replies
175 views

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 has been closed for replies.

BKBK

Community Expert

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

kglad

Community Expert

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

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded