excel office script

  1. Worf

    Office scripts, VBA and a text pivot table

    One way to display text in the values area of a pivot table is to use conditional formatting with a custom number format. Unfortunately, Excel scripts currently cannot apply this kind of feature to pivot tables, only to ordinary cells. On the other hand, good old VBA can do it. So, this is a...
  2. R

    my office script to replace blanks with 0 is not working

    function main(workbook: ExcelScript.Workbook) { let table1 = workbook.getTable("Table1"); // Replace all "" with "0" on table table1 table1.getRange().replaceAll("", "0", {completeMatch: true, matchCase: true}); let selectedSheet = workbook.getActiveWorksheet(); // Set format for range...
  3. M

    Office Scripts - Copy, Paste, and Highlight Each Day

    Hello all! I have a file that needs daily updates to reflect a new day with specific formatting. I am looking for a script that can find the last row used (Row 11 in the attached image), copy from the last row up to the previous days formatting (up to Row 5 in the attached image), paste over...
  4. K

    Office Script - How to i ) delete a column and ii) find the subtotal of a column based on the column headers ?

    I am trying to use Office Script to i) delete a column with a header named "Object Type" and ii) sum up the cells (all the visible filtered cells) in the column named "Hits". I'm new to Office Script and am stuck. I get the following error for getColumnByName: Cannot read properties of...
  5. C

    Excel Office Script - Unable to copy data less than 100K rows from csv to excel file

    Hi, It has been a while since the last time I sought for help. I have been testing a power automate flow which only job is to fetch information from a csv file to an excel file... the last activity of the workflow calls the 'run scripts' step which triggers an excel office script from an excel...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top