Feedback by UserVoice

Excel for the web

Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more

Welcome to the web version of Excel's feedback forum! This is the place for users to send us suggestions and ideas on how to improve. To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Demo script - return entire table content

    Would be good with a demo script showing how to return an entire tables content. Assume its something like
    let entireTable = workbook.getTables('Table1');
    return entireTable;
    Demo script could include converting data to table first, then returning entire data content.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    This code below will achieve that:

    function main(workbook: ExcelScript.Workbook) {
    const entireTable = workbook.getTable(‘Table1’);
    return entireTable.getRange().getTexts();
    // Or return values
    // return entireTable.getRange().getValues();
    }

  2. Sample Script To Add New Record From Other Locations in Sheet

    Sample Script To Add New Record From Other Locations in Sheet. I have a sheet used to fill out information and I want to use another sheet as a database and just add a new record to the next available Row.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    This script will allow you to add a row to a worksheet at the end:

    function main(workbook: ExcelScript.Workbook) { const sheet = workbook.getWorksheet(‘Sheet2’); // SAMPLE DATA – Use 1-dimensional array to represent the row to add const dataToAdd = [‘22773342’, ‘markdown-preview’, ‘MIT License’, ‘https://api.github.com/licenses/mit’]; const startCellToUpdate = sheet.getUsedRange(true).getLastRow().getCell(0,0).getOffsetRange(1,0); console.log(startCellToUpdate.getAddress()); const targetRange = startCellToUpdate.getResizedRange(0, dataToAdd.length-1); targetRange.setValues([dataToAdd]); }
  • Don't see your idea?

Feedback and Knowledge Base