Answered

Office Scripts: Unable to copy paste filtered rows of table to new worksheet

(0) Share

Report

Posted on by Neha2904

I am trying to apply filter to a Excel table using office scripts and copy the data to a new worksheet. I am using getVisibleView() but it pastes all data to new worksheet, and not just the filtered rows.

 table1 = workbook.getTable("Table1");

 // Apply checked items filter on table table1 column Logged in Last 120 Days?
 table1.getColumnByName("Logged in Last 120 Days?").getFilter().applyValuesFilter(["YES"]);

 // Add a new worksheet
 let QuarterMapping = workbook.addWorksheet(QuarterMappingSheetname);

 const source = table1.getRange().getVisibleView().getRange();

 // Copy the data into the other sheet.

 const otherRangeCorner = QuarterMapping.getRange("A1");
 otherRangeCorner.copyFrom(source, ExcelScript.RangeCopyType.all);

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (1)

Report
Re: Office Scripts: Unable to copy paste filtered rows of table to new worksheet

Hi @Neha2904 ,

I've made a test but it worked well on my side:

function main(workbook: ExcelScript.Workbook) { workbook.getTable("Table1").getColumnByName("Logged in Last 120 Days?").getFilter().applyValuesFilter(["YES"]); // Add a new worksheet let QuarterMapping = workbook.addWorksheet("QuarterMappingSheetname"); const source = workbook.getTable("Table1").getRange().getVisibleView().getRange(); // Copy the data into the other sheet. const otherRangeCorner = QuarterMapping.getRange("A1"); otherRangeCorner.copyFrom(source, ExcelScript.RangeCopyType.all); }

Best Regards,

Bof

Was this reply helpful? Yes No
geddb 109 on at

Like (0)

Report

Re: Office Scripts: Unable to copy paste filtered rows of table to new worksheet

Hi @v-bofeng-msft,

I'm having the same issue. I have replicated your test exactly and I am not getting the filtered data on the new sheet 'QuarterMappingSheetname'. Am I doing something wrong?

Many thanks,

Gedd.

Was this reply helpful? Yes No