Office Script Data Redesign
Budget: $30 – $100 USD
I already have a working Office Script in Excel for the web, but I need to extend it with one key feature: show the processed data in a completely new, custom layout instead of the current default view.
Here is what I’m looking for:
• Review my existing TypeScript-based Office Script and understand its current flow.
• Add the new logic that reshapes or re-orders the data exactly as I’ll outline. The first several rows of data are identical for most columns so there is no need to display them. Instead the headers and the first row of data should be displayed so that they are always in view as you scroll down through the unique data.
• Inject the layout directly in the worksheet so it renders automatically each time the script runs—no manual formatting afterward.
• Keep the rest of the functionality intact; only the display layer changes.
• Comment your code clearly so I can tweak column names or positions later.
I’ll provide the workbook, the current script, and a mockup of the layout I want. I've added worksheets that display the basic current output and the desired output for reference. Once the updated script drops the data into that format without breaking existing calculations, the job is done.
Here is what I’m looking for:
• Review my existing TypeScript-based Office Script and understand its current flow.
• Add the new logic that reshapes or re-orders the data exactly as I’ll outline. The first several rows of data are identical for most columns so there is no need to display them. Instead the headers and the first row of data should be displayed so that they are always in view as you scroll down through the unique data.
• Inject the layout directly in the worksheet so it renders automatically each time the script runs—no manual formatting afterward.
• Keep the rest of the functionality intact; only the display layer changes.
• Comment your code clearly so I can tweak column names or positions later.
I’ll provide the workbook, the current script, and a mockup of the layout I want. I've added worksheets that display the basic current output and the desired output for reference. Once the updated script drops the data into that format without breaking existing calculations, the job is done.