0

I would like to create script in order to allow user of file.xlsx stored into Onedrive to import date from file.csv (into same folder of file.xlsx into Onedrive). And then, process these data with other script.

  • Folder X

----- file.xlsx

----- file.csv

My users get access via a business licence to Excel Web (no Desktop application).

I read Office Script documentation and I didn't find function to load csv content into worksheet (via Excel Web).

Yutao Huang
  • 1,503
  • 1
  • 13
  • 25
Babi
  • 11
  • 6

1 Answers1

0

Are you able to use Power Automate in your organization? If so, you can use the OneDrive connector to load the .csv file and create a new xlsx file. An Office Script could then fill the .xlsx file with the data by parsing the comma-separated values (here's a Stack thread on how to do that).

There's a sample that shows this whole process in the MSFT docs: Convert CSV files to Excel workbooks.

Alexander Jerabek
  • 358
  • 1
  • 3
  • 10