Import data to an excel online

Asked Sep 11 '20 at 02:02

Active Sep 11 '20 at 11:07

Viewed 86 times

What would be the best option to programmatically import large dataset (10 MB) file into an excel online workbook and protect the cells.

Dataset file CSV / Parquet format is stored in azure data lake storage.

I reviewed the Microsoft Graph API however I could not find a way to protect the range of cells. Only worksheet can be protected. Also could not find any API to import data.

Any feedback would be much appreciated.

edited Sep 11 '20 at 11:07

asked Sep 11 '20 at 02:02

Faizal

1

How many rows is that? That file size seems way too big for Excel. – BigBen Sep 11 '20 at 02:13
Around 200,000 rows with 15 columns – Faizal Sep 11 '20 at 02:45

Import data to an excel online

0 Answers0