Forum Discussion

LearnExcelScript's avatar
LearnExcelScript
Copper Contributor
Sep 27, 2023
Solved

Problem ExcelScript in excel files with compatibility mode 97-2003

I don't really know if this is the problem, but after many times of trying to run the most simple lines of code in Excel Typescript,    function main(workbook: ExcelScript.Workbook) {   const shee...
developer
Office Scripts
MichelleRanMSFT's avatar
MichelleRanMSFT
Icon for Microsoft rankMicrosoft
Sep 27, 2023

Hi LearnExcelScript, thanks for your question! Office Scripts should be supported in .xls files as long as you open them in a recent Excel client. It's possible there are other issues with your workbook that prevent the script from working properly. Could you share a session id and/or a sample workbook (sensitive data removed as needed)?

    • MichelleRanMSFT's avatar
      MichelleRanMSFT
      Icon for Microsoft rankMicrosoft
      Sep 27, 2023
      Ah, I see - there does indeed appear to be a bug with the getUsedRange API when run on workbooks in compatibility mode. We've logged a bug with the relevant team, although we don't have a timeline to share at the moment. Thanks for reporting this!

Resources