I created the convert csv to excel office script from the template. I used it in power automate to convert all csv files in a folder to excel. It worked great until today now I am receiving and error "selectedsheet not defined". How can I fix this?

aflesner Perhaps you mean this Convert CSV files to Excel workbooks - Office Scripts | Microsoft Learn template in which sheet name is defined explicitly ( as "Sheet1"). Be sure all csv files have sheet with such name. As variant most probably script could be modified to select the sheet not by name but by position, e.g. first sheet in the file.

aflesner Suggestion: Post your issue on the dedicated https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity with your complete script

SergeiBaklanAgreed. @aflesner post already had > 70 views with no reply here ==> only suggested another possible channel

aflesner Instead of let sheet = workbook.getWorksheet("Sheet1"); you may use const sheet = workbook.getWorksheets()[0] to return very first sheet (numbering starts from zero). You may check the sheet name by console.log(sheet.getName()) Just in case, equivalent syntax is let sheet = workbook.getWorksheets()[0];

peiyezhu The idea of this template is to convert set of csv files into Excel ones with help of Power Automate and using Excel on web.

Convert CSV to Excel Office Script | Microsoft Community Hub

22 Replies

Lorenzo
Silver Contributor
Apr 29, 2023
aflesner
Suggestion: Post your issue on the dedicated https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity with your complete script
- SergeiBaklan
  Diamond Contributor
  Apr 29, 2023
  Lorenzo , it's in between. An error most probably is in ExcelScript which is run by Power Automate Flow.
  - Lorenzo
    Silver Contributor
    Apr 29, 2023
    SergeiBaklan
    Agreed. @aflesner post already had > 70 views with no reply here ==> only suggested another possible channel
SergeiBaklan
Diamond Contributor
Apr 29, 2023
aflesner

Perhaps you mean this Convert CSV files to Excel workbooks - Office Scripts | Microsoft Learn template in which sheet name is defined explicitly ( as "Sheet1"). Be sure all csv files have sheet with such name.

As variant most probably script could be modified to select the sheet not by name but by position, e.g. first sheet in the file.
- aflesner
  Copper Contributor
  Apr 29, 2023
  SergeiBaklan
  I think that selecting the sheet not by the name "Sheet1" but by position would fix this. How would that code be written?
  - peiyezhu
    Bronze Contributor
    Apr 29, 2023
    convert an Excel sheet to csv?
    or Csv 2 sheet?

Forum Discussion

Convert CSV to Excel Office Script

22 Replies

Resources